object(Zend_Db_Statement_Mysqli_Exception)#437 (7) {
["message":protected]=>
string(81) "Mysqli prepare error: Table 'escortdirectory_com_www.escort_photos' doesn't exist"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(1146)
["file":protected]=>
string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php"
["line":protected]=>
int(77)
["trace":"Exception":private]=>
array(19) {
[0]=>
array(6) {
["file"]=>
string(36) "/usr/share/php/Zend/Db/Statement.php"
["line"]=>
int(115)
["function"]=>
string(8) "_prepare"
["class"]=>
string(24) "Zend_Db_Statement_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
}
[1]=>
array(6) {
["file"]=>
string(41) "/usr/share/php/Zend/Db/Adapter/Mysqli.php"
["line"]=>
int(381)
["function"]=>
string(11) "__construct"
["class"]=>
string(17) "Zend_Db_Statement"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
object(Cubix_Db_Adapter_Mysqli)#244 (12) {
["_numericDataTypes":protected]=>
array(16) {
[0]=>
int(0)
[1]=>
int(1)
[2]=>
int(2)
["INT"]=>
int(0)
["INTEGER"]=>
int(0)
["MEDIUMINT"]=>
int(0)
["SMALLINT"]=>
int(0)
["TINYINT"]=>
int(0)
["BIGINT"]=>
int(1)
["SERIAL"]=>
int(1)
["DEC"]=>
int(2)
["DECIMAL"]=>
int(2)
["DOUBLE"]=>
int(2)
["DOUBLE PRECISION"]=>
int(2)
["FIXED"]=>
int(2)
["FLOAT"]=>
int(2)
}
["_stmt":protected]=>
object(Zend_Db_Statement_Mysqli)#481 (12) {
["_keys":protected]=>
array(2) {
[0]=>
string(2) "id"
[1]=>
string(5) "title"
}
["_values":protected]=>
array(2) {
[0]=>
string(2) "ro"
[1]=>
string(8) "Romanian"
}
["_meta":protected]=>
object(mysqli_result)#483 (5) {
["current_field"]=>
int(0)
["field_count"]=>
int(2)
["lengths"]=>
NULL
["num_rows"]=>
int(0)
["type"]=>
int(1)
}
["_stmt":protected]=>
NULL
["_adapter":protected]=>
*RECURSION*
["_fetchMode":protected]=>
int(5)
["_attribute":protected]=>
array(0) {
}
["_bindColumn":protected]=>
array(0) {
}
["_bindParam":protected]=>
array(0) {
}
["_sqlSplit":protected]=>
array(3) {
[0]=>
string(121) "SELECT l.id, l.title FROM langs l
INNER JOIN application_langs al ON al.lang_id = l.id
WHERE al.application_id = "
[1]=>
string(1) "?"
[2]=>
string(34) " ORDER BY al.is_default DESC, l.id"
}
["_sqlParam":protected]=>
array(3) {
[0]=>
string(121) "SELECT l.id, l.title FROM langs l
INNER JOIN application_langs al ON al.lang_id = l.id
WHERE al.application_id = "
[1]=>
string(1) "?"
[2]=>
string(34) " ORDER BY al.is_default DESC, l.id"
}
["_queryId":protected]=>
NULL
}
["_defaultStmtClass":protected]=>
string(24) "Zend_Db_Statement_Mysqli"
["_config":protected]=>
array(9) {
["charset"]=>
string(4) "utf8"
["host"]=>
string(6) "galera"
["port"]=>
string(5) "13306"
["password"]=>
string(6) "654321"
["username"]=>
string(14) "ed_cubix_front"
["dbname"]=>
string(23) "escortdirectory_com_www"
["persistent"]=>
bool(false)
["options"]=>
array(2) {
["caseFolding"]=>
int(0)
["autoQuoteIdentifiers"]=>
bool(true)
}
["driver_options"]=>
array(0) {
}
}
["_fetchMode":protected]=>
int(5)
["_profiler":protected]=>
object(Zend_Db_Profiler)#245 (4) {
["_queryProfiles":protected]=>
array(0) {
}
["_enabled":protected]=>
bool(false)
["_filterElapsedSecs":protected]=>
NULL
["_filterTypes":protected]=>
NULL
}
["_defaultProfilerClass":protected]=>
string(16) "Zend_Db_Profiler"
["_connection":protected]=>
object(mysqli)#247 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(1146)
["error"]=>
string(59) "Table 'escortdirectory_com_www.escort_photos' doesn't exist"
["error_list"]=>
array(1) {
[0]=>
array(3) {
["errno"]=>
int(1146)
["sqlstate"]=>
string(5) "42S02"
["error"]=>
string(59) "Table 'escortdirectory_com_www.escort_photos' doesn't exist"
}
}
["field_count"]=>
int(2)
["host_info"]=>
string(17) "galera via TCP/IP"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(21) "5.5.5-10.3.39-MariaDB"
["server_version"]=>
int(100339)
["stat"]=>
string(153) "Uptime: 5778868 Threads: 57 Questions: 3926777320 Slow queries: 181 Opens: 135617 Flush tables: 1 Open tables: 948 Queries per second avg: 679.506"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(12347421)
["warning_count"]=>
int(0)
}
["_caseFolding":protected]=>
int(0)
["_autoQuoteIdentifiers":protected]=>
bool(true)
["_allowSerialization":protected]=>
bool(true)
["_autoReconnectOnUnserialize":protected]=>
bool(false)
}
[1]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
}
[2]=>
array(6) {
["file"]=>
string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php"
["line"]=>
int(38)
["function"]=>
string(7) "prepare"
["class"]=>
string(22) "Zend_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
}
[3]=>
array(6) {
["file"]=>
string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php"
["line"]=>
int(799)
["function"]=>
string(5) "query"
["class"]=>
string(23) "Cubix_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
[1]=>
array(0) {
}
}
}
[4]=>
array(6) {
["file"]=>
string(65) "/var/www/www.escortdirectory.com/application/models/Campaigns.php"
["line"]=>
int(46)
["function"]=>
string(8) "fetchOne"
["class"]=>
string(24) "Zend_Db_Adapter_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(514) "SELECT
sum( is_contest )
FROM
escort_photos eph
INNER JOIN escorts e ON e.id = eph.escort_id
WHERE
e.country_id NOT IN ( 23, 68 )
AND e.verified_status = 2"
}
}
[5]=>
array(6) {
["file"]=>
string(75) "/var/www/www.escortdirectory.com/application/layouts/header/main-head.phtml"
["line"]=>
int(21)
["function"]=>
string(18) "enoughParticipants"
["class"]=>
string(15) "Model_Campaigns"
["type"]=>
string(2) "::"
["args"]=>
array(0) {
}
}
[6]=>
array(4) {
["file"]=>
string(28) "/usr/share/php/Zend/View.php"
["line"]=>
int(108)
["args"]=>
array(1) {
[0]=>
string(75) "/var/www/www.escortdirectory.com/application/layouts/header/main-head.phtml"
}
["function"]=>
string(7) "include"
}
[7]=>
array(6) {
["file"]=>
string(37) "/usr/share/php/Zend/View/Abstract.php"
["line"]=>
int(880)
["function"]=>
string(4) "_run"
["class"]=>
string(9) "Zend_View"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(75) "/var/www/www.escortdirectory.com/application/layouts/header/main-head.phtml"
}
}
[8]=>
array(6) {
["file"]=>
string(63) "/var/www/www.escortdirectory.com/application/layouts/main.phtml"
["line"]=>
int(14)
["function"]=>
string(6) "render"
["class"]=>
string(18) "Zend_View_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
[9]=>
array(4) {
["file"]=>
string(28) "/usr/share/php/Zend/View.php"
["line"]=>
int(108)
["args"]=>
array(1) {
[0]=>
string(63) "/var/www/www.escortdirectory.com/application/layouts/main.phtml"
}
["function"]=>
string(7) "include"
}
[10]=>
array(6) {
["file"]=>
string(37) "/usr/share/php/Zend/View/Abstract.php"
["line"]=>
int(880)
["function"]=>
string(4) "_run"
["class"]=>
string(9) "Zend_View"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(63) "/var/www/www.escortdirectory.com/application/layouts/main.phtml"
}
}
[11]=>
array(6) {
["file"]=>
string(30) "/usr/share/php/Zend/Layout.php"
["line"]=>
int(796)
["function"]=>
string(6) "render"
["class"]=>
string(18) "Zend_View_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
[12]=>
array(6) {
["file"]=>
string(55) "/usr/share/php/Zend/Layout/Controller/Plugin/Layout.php"
["line"]=>
int(143)
["function"]=>
string(6) "render"
["class"]=>
string(11) "Zend_Layout"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[13]=>
array(6) {
["file"]=>
string(48) "/usr/share/php/Zend/Controller/Plugin/Broker.php"
["line"]=>
int(331)
["function"]=>
string(12) "postDispatch"
["class"]=>
string(36) "Zend_Layout_Controller_Plugin_Layout"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
object(Zend_Controller_Request_Http)#315 (15) {
["_paramSources":protected]=>
array(2) {
[0]=>
string(4) "_GET"
[1]=>
string(5) "_POST"
}
["_requestUri":protected]=>
string(168) "/?advanced_search=1%2Ffr%2F%2F%2Fpt%2F%2Fit%2F%2F%2F%2Fde%2F%2Fes%2F%2Fpt%2F%2Ffr%2F%2Ffr%2F%2F%2Fpt%2F%2F%2F&page=157%2Ffr%2F%2F%2Fde%2F%2F%2Fro%2F%2Fit%2F%2Fpt%2F%2F/"
["_baseUrl":protected]=>
string(0) ""
["_basePath":protected]=>
NULL
["_pathInfo":protected]=>
string(1) "/"
["_params":protected]=>
array(9) {
["module"]=>
string(7) "default"
["controller"]=>
string(7) "escorts"
["action"]=>
string(5) "index"
["lang_id"]=>
string(2) "en"
["chatVersion"]=>
int(2)
["sort"]=>
string(11) "close-to-me"
["error_handler"]=>
object(ArrayObject)#249 (1) {
["storage":"ArrayObject":private]=>
array(3) {
["exception"]=>
object(Zend_Db_Statement_Mysqli_Exception)#488 (7) {
["message":protected]=>
string(67) "Mysqli prepare error: Unknown column 'e.products' in 'where clause'"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(1054)
["file":protected]=>
string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php"
["line":protected]=>
int(77)
["trace":"Exception":private]=>
array(14) {
[0]=>
array(6) {
["file"]=>
string(36) "/usr/share/php/Zend/Db/Statement.php"
["line"]=>
int(115)
["function"]=>
string(8) "_prepare"
["class"]=>
string(24) "Zend_Db_Statement_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(3323) "
SELECT SQL_CALC_FOUND_ROWS
e.id, e.showname, e.age, UNIX_TIMESTAMP(e.date_registered) AS date_registered, e.user_id, e.is_pornstar, e.last_hand_verification_date, e.is_inactive,
UNIX_TIMESTAMP(e.date_activated) AS date_activated, ct.slug AS city_slug, ct.id AS city_id, ct.title_en AS city, e.rates,
e.incall_type, e.outcall_type, e.is_new, cr.id AS country_id, cr.slug AS country_slug, cr.title_en AS country, e.verified_status,
e.photo_hash, e.photo_ext, e.photo_args, e.photo_status, 69 AS application_id,
e.incall_currency, e.incall_price, e.outcall_currency, e.outcall_price, e.comment_count, e.review_count,
e.travel_place, e.email, e.website, e.phone_instr, e.phone_instr_no_withheld, e.phone_instr_other,
e.phone_country_id, e.disable_phone_prefix, e.phone_number_free AS phone_number,
IF (ulrt.refresh_date >= DATE_ADD(NOW(), INTERVAL -5 MINUTE), 1, 0) AS is_login, e.allow_show_online,
e.hit_count, e.slogan, e.incall_price, e.date_last_modified, eic.is_premium, eic.is_vip, e.hh_is_active,
e.is_on_tour AS is_tour, e.tour_date_from, e.tour_date_to, ctt.title_en AS tour_city,
e.is_suspicious, e.is_online, ct.id AS city_id,
CASE
WHEN LENGTH(e.about_en) > 0 THEN e.about_en
WHEN LENGTH(e.about_de) > 0 THEN e.about_de WHEN LENGTH(e.about_en) > 0 THEN e.about_en WHEN LENGTH(e.about_es) > 0 THEN e.about_es WHEN LENGTH(e.about_fr) > 0 THEN e.about_fr WHEN LENGTH(e.about_it) > 0 THEN e.about_it WHEN LENGTH(e.about_pt) > 0 THEN e.about_pt WHEN LENGTH(e.about_ro) > 0 THEN e.about_ro
ELSE e.about_en
END AS about
, e.agency_name,
(e.incall_price / er.rate) * 0 AS incall_price_converted,
e.agency_slug, e.agency_id, eic.type as escort_type, ulrt.refresh_date AS refresh_date ,
((2 * 6371 *
ATAN2(
SQRT(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
),
SQRT(1-(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
))
)
)) AS distance
FROM escorts_in_cities eic /*USE INDEX(by_googo3)*/
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN cities ct ON ct.id = eic.city_id
INNER JOIN countries cr ON cr.id = ct.country_id
LEFT JOIN users_last_refresh_time ulrt ON ulrt.user_id = e.user_id
LEFT JOIN cities ctt ON ctt.id = e.tour_city_id
/*LEFT JOIN countries crtt ON crtt.id = ctt.country_id*/
LEFT JOIN currencies cur ON cur.id = e.incall_currency
LEFT JOIN exchange_rates er ON er.iso = cur.title
WHERE eic.is_premium = 1 AND eic.is_vip = 0 AND ( FIND_IN_SET(4, e.products) > 0 OR ( cr.iso = 'us' AND FIND_IN_SET(15, e.products ) > 0 )) AND eic.is_inactive = 0 AND eic.gender = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
GROUP BY eic.escort_id
ORDER BY distance ASC, e.is_vip DESC, eic.is_premium DESC, eic.ordering DESC LIMIT 7020, 45"
}
}
[1]=>
array(6) {
["file"]=>
string(41) "/usr/share/php/Zend/Db/Adapter/Mysqli.php"
["line"]=>
int(381)
["function"]=>
string(11) "__construct"
["class"]=>
string(17) "Zend_Db_Statement"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
object(Cubix_Db_Adapter_Mysqli)#244 (12) {
["_numericDataTypes":protected]=>
array(16) {
[0]=>
int(0)
[1]=>
int(1)
[2]=>
int(2)
["INT"]=>
int(0)
["INTEGER"]=>
int(0)
["MEDIUMINT"]=>
int(0)
["SMALLINT"]=>
int(0)
["TINYINT"]=>
int(0)
["BIGINT"]=>
int(1)
["SERIAL"]=>
int(1)
["DEC"]=>
int(2)
["DECIMAL"]=>
int(2)
["DOUBLE"]=>
int(2)
["DOUBLE PRECISION"]=>
int(2)
["FIXED"]=>
int(2)
["FLOAT"]=>
int(2)
}
["_stmt":protected]=>
object(Zend_Db_Statement_Mysqli)#481 (12) {
["_keys":protected]=>
array(2) {
[0]=>
string(2) "id"
[1]=>
string(5) "title"
}
["_values":protected]=>
array(2) {
[0]=>
string(2) "ro"
[1]=>
string(8) "Romanian"
}
["_meta":protected]=>
object(mysqli_result)#483 (5) {
["current_field"]=>
int(0)
["field_count"]=>
int(2)
["lengths"]=>
NULL
["num_rows"]=>
int(0)
["type"]=>
int(1)
}
["_stmt":protected]=>
NULL
["_adapter":protected]=>
*RECURSION*
["_fetchMode":protected]=>
int(5)
["_attribute":protected]=>
array(0) {
}
["_bindColumn":protected]=>
array(0) {
}
["_bindParam":protected]=>
array(0) {
}
["_sqlSplit":protected]=>
array(3) {
[0]=>
string(121) "SELECT l.id, l.title FROM langs l
INNER JOIN application_langs al ON al.lang_id = l.id
WHERE al.application_id = "
[1]=>
string(1) "?"
[2]=>
string(34) " ORDER BY al.is_default DESC, l.id"
}
["_sqlParam":protected]=>
array(3) {
[0]=>
string(121) "SELECT l.id, l.title FROM langs l
INNER JOIN application_langs al ON al.lang_id = l.id
WHERE al.application_id = "
[1]=>
string(1) "?"
[2]=>
string(34) " ORDER BY al.is_default DESC, l.id"
}
["_queryId":protected]=>
NULL
}
["_defaultStmtClass":protected]=>
string(24) "Zend_Db_Statement_Mysqli"
["_config":protected]=>
array(9) {
["charset"]=>
string(4) "utf8"
["host"]=>
string(6) "galera"
["port"]=>
string(5) "13306"
["password"]=>
string(6) "654321"
["username"]=>
string(14) "ed_cubix_front"
["dbname"]=>
string(23) "escortdirectory_com_www"
["persistent"]=>
bool(false)
["options"]=>
array(2) {
["caseFolding"]=>
int(0)
["autoQuoteIdentifiers"]=>
bool(true)
}
["driver_options"]=>
array(0) {
}
}
["_fetchMode":protected]=>
int(5)
["_profiler":protected]=>
object(Zend_Db_Profiler)#245 (4) {
["_queryProfiles":protected]=>
array(0) {
}
["_enabled":protected]=>
bool(false)
["_filterElapsedSecs":protected]=>
NULL
["_filterTypes":protected]=>
NULL
}
["_defaultProfilerClass":protected]=>
string(16) "Zend_Db_Profiler"
["_connection":protected]=>
object(mysqli)#247 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(2)
["host_info"]=>
string(17) "galera via TCP/IP"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(21) "5.5.5-10.3.39-MariaDB"
["server_version"]=>
int(100339)
["stat"]=>
string(153) "Uptime: 5778868 Threads: 57 Questions: 3926777321 Slow queries: 181 Opens: 135617 Flush tables: 1 Open tables: 948 Queries per second avg: 679.506"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(12347421)
["warning_count"]=>
int(0)
}
["_caseFolding":protected]=>
int(0)
["_autoQuoteIdentifiers":protected]=>
bool(true)
["_allowSerialization":protected]=>
bool(true)
["_autoReconnectOnUnserialize":protected]=>
bool(false)
}
[1]=>
string(3323) "
SELECT SQL_CALC_FOUND_ROWS
e.id, e.showname, e.age, UNIX_TIMESTAMP(e.date_registered) AS date_registered, e.user_id, e.is_pornstar, e.last_hand_verification_date, e.is_inactive,
UNIX_TIMESTAMP(e.date_activated) AS date_activated, ct.slug AS city_slug, ct.id AS city_id, ct.title_en AS city, e.rates,
e.incall_type, e.outcall_type, e.is_new, cr.id AS country_id, cr.slug AS country_slug, cr.title_en AS country, e.verified_status,
e.photo_hash, e.photo_ext, e.photo_args, e.photo_status, 69 AS application_id,
e.incall_currency, e.incall_price, e.outcall_currency, e.outcall_price, e.comment_count, e.review_count,
e.travel_place, e.email, e.website, e.phone_instr, e.phone_instr_no_withheld, e.phone_instr_other,
e.phone_country_id, e.disable_phone_prefix, e.phone_number_free AS phone_number,
IF (ulrt.refresh_date >= DATE_ADD(NOW(), INTERVAL -5 MINUTE), 1, 0) AS is_login, e.allow_show_online,
e.hit_count, e.slogan, e.incall_price, e.date_last_modified, eic.is_premium, eic.is_vip, e.hh_is_active,
e.is_on_tour AS is_tour, e.tour_date_from, e.tour_date_to, ctt.title_en AS tour_city,
e.is_suspicious, e.is_online, ct.id AS city_id,
CASE
WHEN LENGTH(e.about_en) > 0 THEN e.about_en
WHEN LENGTH(e.about_de) > 0 THEN e.about_de WHEN LENGTH(e.about_en) > 0 THEN e.about_en WHEN LENGTH(e.about_es) > 0 THEN e.about_es WHEN LENGTH(e.about_fr) > 0 THEN e.about_fr WHEN LENGTH(e.about_it) > 0 THEN e.about_it WHEN LENGTH(e.about_pt) > 0 THEN e.about_pt WHEN LENGTH(e.about_ro) > 0 THEN e.about_ro
ELSE e.about_en
END AS about
, e.agency_name,
(e.incall_price / er.rate) * 0 AS incall_price_converted,
e.agency_slug, e.agency_id, eic.type as escort_type, ulrt.refresh_date AS refresh_date ,
((2 * 6371 *
ATAN2(
SQRT(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
),
SQRT(1-(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
))
)
)) AS distance
FROM escorts_in_cities eic /*USE INDEX(by_googo3)*/
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN cities ct ON ct.id = eic.city_id
INNER JOIN countries cr ON cr.id = ct.country_id
LEFT JOIN users_last_refresh_time ulrt ON ulrt.user_id = e.user_id
LEFT JOIN cities ctt ON ctt.id = e.tour_city_id
/*LEFT JOIN countries crtt ON crtt.id = ctt.country_id*/
LEFT JOIN currencies cur ON cur.id = e.incall_currency
LEFT JOIN exchange_rates er ON er.iso = cur.title
WHERE eic.is_premium = 1 AND eic.is_vip = 0 AND ( FIND_IN_SET(4, e.products) > 0 OR ( cr.iso = 'us' AND FIND_IN_SET(15, e.products ) > 0 )) AND eic.is_inactive = 0 AND eic.gender = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
GROUP BY eic.escort_id
ORDER BY distance ASC, e.is_vip DESC, eic.is_premium DESC, eic.ordering DESC LIMIT 7020, 45"
}
}
[2]=>
array(6) {
["file"]=>
string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php"
["line"]=>
int(38)
["function"]=>
string(7) "prepare"
["class"]=>
string(22) "Zend_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(3323) "
SELECT SQL_CALC_FOUND_ROWS
e.id, e.showname, e.age, UNIX_TIMESTAMP(e.date_registered) AS date_registered, e.user_id, e.is_pornstar, e.last_hand_verification_date, e.is_inactive,
UNIX_TIMESTAMP(e.date_activated) AS date_activated, ct.slug AS city_slug, ct.id AS city_id, ct.title_en AS city, e.rates,
e.incall_type, e.outcall_type, e.is_new, cr.id AS country_id, cr.slug AS country_slug, cr.title_en AS country, e.verified_status,
e.photo_hash, e.photo_ext, e.photo_args, e.photo_status, 69 AS application_id,
e.incall_currency, e.incall_price, e.outcall_currency, e.outcall_price, e.comment_count, e.review_count,
e.travel_place, e.email, e.website, e.phone_instr, e.phone_instr_no_withheld, e.phone_instr_other,
e.phone_country_id, e.disable_phone_prefix, e.phone_number_free AS phone_number,
IF (ulrt.refresh_date >= DATE_ADD(NOW(), INTERVAL -5 MINUTE), 1, 0) AS is_login, e.allow_show_online,
e.hit_count, e.slogan, e.incall_price, e.date_last_modified, eic.is_premium, eic.is_vip, e.hh_is_active,
e.is_on_tour AS is_tour, e.tour_date_from, e.tour_date_to, ctt.title_en AS tour_city,
e.is_suspicious, e.is_online, ct.id AS city_id,
CASE
WHEN LENGTH(e.about_en) > 0 THEN e.about_en
WHEN LENGTH(e.about_de) > 0 THEN e.about_de WHEN LENGTH(e.about_en) > 0 THEN e.about_en WHEN LENGTH(e.about_es) > 0 THEN e.about_es WHEN LENGTH(e.about_fr) > 0 THEN e.about_fr WHEN LENGTH(e.about_it) > 0 THEN e.about_it WHEN LENGTH(e.about_pt) > 0 THEN e.about_pt WHEN LENGTH(e.about_ro) > 0 THEN e.about_ro
ELSE e.about_en
END AS about
, e.agency_name,
(e.incall_price / er.rate) * 0 AS incall_price_converted,
e.agency_slug, e.agency_id, eic.type as escort_type, ulrt.refresh_date AS refresh_date ,
((2 * 6371 *
ATAN2(
SQRT(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
),
SQRT(1-(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
))
)
)) AS distance
FROM escorts_in_cities eic /*USE INDEX(by_googo3)*/
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN cities ct ON ct.id = eic.city_id
INNER JOIN countries cr ON cr.id = ct.country_id
LEFT JOIN users_last_refresh_time ulrt ON ulrt.user_id = e.user_id
LEFT JOIN cities ctt ON ctt.id = e.tour_city_id
/*LEFT JOIN countries crtt ON crtt.id = ctt.country_id*/
LEFT JOIN currencies cur ON cur.id = e.incall_currency
LEFT JOIN exchange_rates er ON er.iso = cur.title
WHERE eic.is_premium = 1 AND eic.is_vip = 0 AND ( FIND_IN_SET(4, e.products) > 0 OR ( cr.iso = 'us' AND FIND_IN_SET(15, e.products ) > 0 )) AND eic.is_inactive = 0 AND eic.gender = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
GROUP BY eic.escort_id
ORDER BY distance ASC, e.is_vip DESC, eic.is_premium DESC, eic.ordering DESC LIMIT 7020, 45"
}
}
[3]=>
array(6) {
["file"]=>
string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php"
["line"]=>
int(706)
["function"]=>
string(5) "query"
["class"]=>
string(23) "Cubix_Db_Adapter_Mysqli"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(3323) "
SELECT SQL_CALC_FOUND_ROWS
e.id, e.showname, e.age, UNIX_TIMESTAMP(e.date_registered) AS date_registered, e.user_id, e.is_pornstar, e.last_hand_verification_date, e.is_inactive,
UNIX_TIMESTAMP(e.date_activated) AS date_activated, ct.slug AS city_slug, ct.id AS city_id, ct.title_en AS city, e.rates,
e.incall_type, e.outcall_type, e.is_new, cr.id AS country_id, cr.slug AS country_slug, cr.title_en AS country, e.verified_status,
e.photo_hash, e.photo_ext, e.photo_args, e.photo_status, 69 AS application_id,
e.incall_currency, e.incall_price, e.outcall_currency, e.outcall_price, e.comment_count, e.review_count,
e.travel_place, e.email, e.website, e.phone_instr, e.phone_instr_no_withheld, e.phone_instr_other,
e.phone_country_id, e.disable_phone_prefix, e.phone_number_free AS phone_number,
IF (ulrt.refresh_date >= DATE_ADD(NOW(), INTERVAL -5 MINUTE), 1, 0) AS is_login, e.allow_show_online,
e.hit_count, e.slogan, e.incall_price, e.date_last_modified, eic.is_premium, eic.is_vip, e.hh_is_active,
e.is_on_tour AS is_tour, e.tour_date_from, e.tour_date_to, ctt.title_en AS tour_city,
e.is_suspicious, e.is_online, ct.id AS city_id,
CASE
WHEN LENGTH(e.about_en) > 0 THEN e.about_en
WHEN LENGTH(e.about_de) > 0 THEN e.about_de WHEN LENGTH(e.about_en) > 0 THEN e.about_en WHEN LENGTH(e.about_es) > 0 THEN e.about_es WHEN LENGTH(e.about_fr) > 0 THEN e.about_fr WHEN LENGTH(e.about_it) > 0 THEN e.about_it WHEN LENGTH(e.about_pt) > 0 THEN e.about_pt WHEN LENGTH(e.about_ro) > 0 THEN e.about_ro
ELSE e.about_en
END AS about
, e.agency_name,
(e.incall_price / er.rate) * 0 AS incall_price_converted,
e.agency_slug, e.agency_id, eic.type as escort_type, ulrt.refresh_date AS refresh_date ,
((2 * 6371 *
ATAN2(
SQRT(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
),
SQRT(1-(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
))
)
)) AS distance
FROM escorts_in_cities eic /*USE INDEX(by_googo3)*/
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN cities ct ON ct.id = eic.city_id
INNER JOIN countries cr ON cr.id = ct.country_id
LEFT JOIN users_last_refresh_time ulrt ON ulrt.user_id = e.user_id
LEFT JOIN cities ctt ON ctt.id = e.tour_city_id
/*LEFT JOIN countries crtt ON crtt.id = ctt.country_id*/
LEFT JOIN currencies cur ON cur.id = e.incall_currency
LEFT JOIN exchange_rates er ON er.iso = cur.title
WHERE eic.is_premium = 1 AND eic.is_vip = 0 AND ( FIND_IN_SET(4, e.products) > 0 OR ( cr.iso = 'us' AND FIND_IN_SET(15, e.products ) > 0 )) AND eic.is_inactive = 0 AND eic.gender = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
GROUP BY eic.escort_id
ORDER BY distance ASC, e.is_vip DESC, eic.is_premium DESC, eic.ordering DESC LIMIT 7020, 45"
[1]=>
array(0) {
}
}
}
[4]=>
array(6) {
["file"]=>
string(67) "/var/www/www.escortdirectory.com/application/models/Escort/List.php"
["line"]=>
int(1133)
["function"]=>
string(8) "fetchAll"
["class"]=>
string(24) "Zend_Db_Adapter_Abstract"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(3323) "
SELECT SQL_CALC_FOUND_ROWS
e.id, e.showname, e.age, UNIX_TIMESTAMP(e.date_registered) AS date_registered, e.user_id, e.is_pornstar, e.last_hand_verification_date, e.is_inactive,
UNIX_TIMESTAMP(e.date_activated) AS date_activated, ct.slug AS city_slug, ct.id AS city_id, ct.title_en AS city, e.rates,
e.incall_type, e.outcall_type, e.is_new, cr.id AS country_id, cr.slug AS country_slug, cr.title_en AS country, e.verified_status,
e.photo_hash, e.photo_ext, e.photo_args, e.photo_status, 69 AS application_id,
e.incall_currency, e.incall_price, e.outcall_currency, e.outcall_price, e.comment_count, e.review_count,
e.travel_place, e.email, e.website, e.phone_instr, e.phone_instr_no_withheld, e.phone_instr_other,
e.phone_country_id, e.disable_phone_prefix, e.phone_number_free AS phone_number,
IF (ulrt.refresh_date >= DATE_ADD(NOW(), INTERVAL -5 MINUTE), 1, 0) AS is_login, e.allow_show_online,
e.hit_count, e.slogan, e.incall_price, e.date_last_modified, eic.is_premium, eic.is_vip, e.hh_is_active,
e.is_on_tour AS is_tour, e.tour_date_from, e.tour_date_to, ctt.title_en AS tour_city,
e.is_suspicious, e.is_online, ct.id AS city_id,
CASE
WHEN LENGTH(e.about_en) > 0 THEN e.about_en
WHEN LENGTH(e.about_de) > 0 THEN e.about_de WHEN LENGTH(e.about_en) > 0 THEN e.about_en WHEN LENGTH(e.about_es) > 0 THEN e.about_es WHEN LENGTH(e.about_fr) > 0 THEN e.about_fr WHEN LENGTH(e.about_it) > 0 THEN e.about_it WHEN LENGTH(e.about_pt) > 0 THEN e.about_pt WHEN LENGTH(e.about_ro) > 0 THEN e.about_ro
ELSE e.about_en
END AS about
, e.agency_name,
(e.incall_price / er.rate) * 0 AS incall_price_converted,
e.agency_slug, e.agency_id, eic.type as escort_type, ulrt.refresh_date AS refresh_date ,
((2 * 6371 *
ATAN2(
SQRT(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
),
SQRT(1-(
POWER(SIN((RADIANS(39.961380004883 - ct.latitude))/2), 2) +
COS(RADIANS(ct.latitude)) *
COS(RADIANS(39.961380004883)) *
POWER(SIN((RADIANS(-82.997749328613 - ct.longitude))/2), 2)
))
)
)) AS distance
FROM escorts_in_cities eic /*USE INDEX(by_googo3)*/
INNER JOIN escorts e ON e.id = eic.escort_id
INNER JOIN cities ct ON ct.id = eic.city_id
INNER JOIN countries cr ON cr.id = ct.country_id
LEFT JOIN users_last_refresh_time ulrt ON ulrt.user_id = e.user_id
LEFT JOIN cities ctt ON ctt.id = e.tour_city_id
/*LEFT JOIN countries crtt ON crtt.id = ctt.country_id*/
LEFT JOIN currencies cur ON cur.id = e.incall_currency
LEFT JOIN exchange_rates er ON er.iso = cur.title
WHERE eic.is_premium = 1 AND eic.is_vip = 0 AND ( FIND_IN_SET(4, e.products) > 0 OR ( cr.iso = 'us' AND FIND_IN_SET(15, e.products ) > 0 )) AND eic.is_inactive = 0 AND eic.gender = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0
GROUP BY eic.escort_id
ORDER BY distance ASC, e.is_vip DESC, eic.is_premium DESC, eic.ordering DESC LIMIT 7020, 45"
}
}
[5]=>
array(6) {
["file"]=>
string(67) "/var/www/www.escortdirectory.com/application/models/Escort/List.php"
["line"]=>
int(1906)
["function"]=>
string(21) "getFilteredWhereQuery"
["class"]=>
string(17) "Model_Escort_List"
["type"]=>
string(2) "::"
["args"]=>
array(13) {
[0]=>
array(5) {
[" eic.is_premium = 1 AND eic.is_vip = 0"]=>
array(0) {
}
["( FIND_IN_SET(4, e.products) > 0 OR ( cr.iso = ? AND FIND_IN_SET(15, e.products ) > 0 )) "]=>
string(2) "us"
["eic.is_inactive = 0"]=>
array(0) {
}
["eic.gender = ? "]=>
int(1)
["eic.is_base = 1"]=>
array(0) {
}
}
[1]=>
string(8) "premiums"
[2]=>
int(157)
[3]=>
int(45)
[4]=>
int(0)
[5]=>
bool(false)
[6]=>
bool(false)
[7]=>
array(2) {
["gender"]=>
array(1) {
[0]=>
NULL
}
["currency"]=>
string(3) "EUR"
}
[8]=>
bool(false)
[9]=>
array(7) {
["ip"]=>
string(13) "3.146.107.152"
["country"]=>
string(24) "United States of America"
["country_iso"]=>
string(2) "us"
["region"]=>
string(4) "Ohio"
["city"]=>
string(8) "Columbus"
["latitude"]=>
float(39.961380004883)
["longitude"]=>
float(-82.997749328613)
}
[10]=>
string(7) "gallery"
[11]=>
NULL
[12]=>
NULL
}
}
[6]=>
array(6) {
["file"]=>
string(78) "/var/www/www.escortdirectory.com/application/controllers/EscortsController.php"
["line"]=>
int(1416)
["function"]=>
string(28) "getFilteredForAdvancedSearch"
["class"]=>
string(17) "Model_Escort_List"
["type"]=>
string(2) "::"
["args"]=>
array(15) {
[0]=>
array(2) {
["eic.gender = 1"]=>
array(0) {
}
["show_all_agency_escorts"]=>
bool(true)
}
[1]=>
string(11) "close-to-me"
[2]=>
int(157)
[3]=>
int(45)
[4]=>
int(0)
[5]=>
array(2) {
["gender"]=>
array(1) {
[0]=>
NULL
}
["currency"]=>
string(3) "EUR"
}
[6]=>
bool(false)
[7]=>
array(7) {
["ip"]=>
string(13) "3.146.107.152"
["country"]=>
string(24) "United States of America"
["country_iso"]=>
string(2) "us"
["region"]=>
string(4) "Ohio"
["city"]=>
string(8) "Columbus"
["latitude"]=>
float(39.961380004883)
["longitude"]=>
float(-82.997749328613)
}
[8]=>
string(7) "gallery"
[9]=>
string(7) "escorts"
[10]=>
NULL
[11]=>
NULL
[12]=>
string(3) "USD"
[13]=>
bool(true)
[14]=>
int(0)
}
}
[7]=>
array(6) {
["file"]=>
string(41) "/usr/share/php/Zend/Controller/Action.php"
["line"]=>
int(513)
["function"]=>
string(11) "indexAction"
["class"]=>
string(17) "EscortsController"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[8]=>
array(6) {
["file"]=>
string(54) "/usr/share/php/Zend/Controller/Dispatcher/Standard.php"
["line"]=>
int(289)
["function"]=>
string(8) "dispatch"
["class"]=>
string(22) "Zend_Controller_Action"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(11) "indexAction"
}
}
[9]=>
array(6) {
["file"]=>
string(40) "/usr/share/php/Zend/Controller/Front.php"
["line"]=>
int(954)
["function"]=>
string(8) "dispatch"
["class"]=>
string(35) "Zend_Controller_Dispatcher_Standard"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
*RECURSION*
[1]=>
object(Zend_Controller_Response_Http)#316 (8) {
["_body":protected]=>
array(1) {
["default"]=>
string(0) ""
}
["_exceptions":protected]=>
array(2) {
[0]=>
*RECURSION*
[1]=>
*RECURSION*
}
["_headers":protected]=>
array(0) {
}
["_headersRaw":protected]=>
array(0) {
}
["_httpResponseCode":protected]=>
int(200)
["_isRedirect":protected]=>
bool(false)
["_renderExceptions":protected]=>
bool(false)
["headersSentThrowsException"]=>
bool(true)
}
}
}
[10]=>
array(6) {
["file"]=>
string(55) "/usr/share/php/Zend/Application/Bootstrap/Bootstrap.php"
["line"]=>
int(97)
["function"]=>
string(8) "dispatch"
["class"]=>
string(21) "Zend_Controller_Front"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[11]=>
array(6) {
["file"]=>
string(58) "/var/www/www.escortdirectory.com/application/Bootstrap.php"
["line"]=>
int(30)
["function"]=>
string(3) "run"
["class"]=>
string(36) "Zend_Application_Bootstrap_Bootstrap"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[12]=>
array(6) {
["file"]=>
string(35) "/usr/share/php/Zend/Application.php"
["line"]=>
int(366)
["function"]=>
string(3) "run"
["class"]=>
string(9) "Bootstrap"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[13]=>
array(6) {
["file"]=>
string(49) "/var/www/www.escortdirectory.com/public/index.php"
["line"]=>
int(367)
["function"]=>
string(3) "run"
["class"]=>
string(16) "Zend_Application"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
}
["previous":"Exception":private]=>
NULL
}
["type"]=>
string(15) "EXCEPTION_OTHER"
["request"]=>
object(Zend_Controller_Request_Http)#248 (15) {
["_paramSources":protected]=>
array(2) {
[0]=>
string(4) "_GET"
[1]=>
string(5) "_POST"
}
["_requestUri":protected]=>
string(168) "/?advanced_search=1%2Ffr%2F%2F%2Fpt%2F%2Fit%2F%2F%2F%2Fde%2F%2Fes%2F%2Fpt%2F%2Ffr%2F%2Ffr%2F%2F%2Fpt%2F%2F%2F&page=157%2Ffr%2F%2F%2Fde%2F%2F%2Fro%2F%2Fit%2F%2Fpt%2F%2F/"
["_baseUrl":protected]=>
string(0) ""
["_basePath":protected]=>
NULL
["_pathInfo":protected]=>
string(1) "/"
["_params":protected]=>
array(6) {
["module"]=>
string(7) "default"
["controller"]=>
string(7) "escorts"
["action"]=>
string(5) "index"
["lang_id"]=>
string(2) "en"
["chatVersion"]=>
int(2)
["sort"]=>
string(11) "close-to-me"
}
["_rawBody":protected]=>
NULL
["_aliases":protected]=>
array(0) {
}
["_dispatched":protected]=>
bool(true)
["_module":protected]=>
string(7) "default"
["_moduleKey":protected]=>
string(6) "module"
["_controller":protected]=>
string(7) "escorts"
["_controllerKey":protected]=>
string(10) "controller"
["_action":protected]=>
string(5) "index"
["_actionKey":protected]=>
string(6) "action"
}
}
}
["layoutFullContent"]=>
string(14529) "