Noví lidé

OW Debug - Vardump
array
(
    [marks] => array
    (
        [start] => 0.000
        [display -> frontend init] => 0.071
        [__ping__ cmp render start] => 0.071
        [__ping__ cmp render end] => 0.084
        [__sign_in__ cmp render start] => 0.249
        [__forgot_password__ cmp render start] => 0.266
        [__forgot_password__ cmp render end] => 0.277
        [__sign_in__ cmp render end] => 0.277
        [display -> render hid cmp] => 0.177
        [__index__ cmp render start] => 0.177
        [__navigation_menu_main__ cmp render start] => 0.224
        [__registration_popup__ cmp render start] => 1.086
        [__fbc_button__ cmp render start] => 1.102
        [__fbc_button__ cmp render end] => 1.117
        [__join__ cmp render start] => 1.117
        [__join__ cmp render end] => 1.294
        [__registration_popup__ cmp render end] => 1.295
        [__select_language__ cmp render start] => 0.438
        [__select_language__ cmp render end] => 0.445
        [__navigation_menu_main__ cmp render end] => 0.445
        [__hot_list__ cmp render start] => 0.447
        [__hot_list__ cmp render end] => 0.474
        [__profile_list__ cmp render start] => 0.480
        [__profile_list__ cmp render end] => 0.799
        [__main_search__ cmp render start] => 0.801
        [__main_search__ cmp render end] => 0.992
        [__page_footer__ cmp render start] => 1.008
        [__page_footer__ cmp render end] => 1.045
        [__index__ cmp render end] => 1.049
        [display -> render httpdoc] => 1.049
        [display -> dev actions] => 1.061
        [display -> meta get] => 1.061
        [end] => 1.299
    )
    [total] => 1.299
)

Type: Array
    				
total query exec time  0.45449137687683      query count  278
SELECT `section`,`label`,`parent_section_id`,`config_section_id`
FROM `skadate_config_section`
WHERE `parent_section_id`=0 AND `section`="configs"
0.000
SELECT * FROM `skadate_config` WHERE `config_section_id`=82 0.000
SELECT `v`.*, `c`.`name` FROM `skadate_config_value` AS `v` LEFT JOIN `skadate_config` AS `c` USING(`config_id`)
WHERE `c`.`config_section_id`=82
0.000
SELECT `main`.*, `extend`.*, INET_NTOA( `main`.`join_ip` ) AS `join_ip`, `main`.`profile_id` AS `profile_id`,
`location_country`.`Country_str_name` AS `country`, `location_state`.`Admin1_str_name` AS `state`,
`location_city`.`Feature_str_name` AS `city` FROM `skadate_profile` AS `main`
LEFT JOIN `skadate_location_country` AS `location_country`
ON `main`.`country_id`=`location_country`.`Country_str_code`LEFT JOIN `skadate_location_state` AS `location_state`
ON `main`.`state_id`=`location_state`.`Admin1_str_code`LEFT JOIN `skadate_location_city` AS `location_city`
ON `main`.`city_id`=`location_city`.`Feature_int_id`LEFT JOIN `skadate_profile_extended` AS `extend` ON ( `extend`.`profile_id` = `main`.`profile_id` )
WHERE `main`.`profile_id` =136
0.001
SELECT * FROM `skadate_menu` 0.000
SELECT * FROM `skadate_menu_item` ORDER BY `order` 0.000
SELECT * FROM `skadate_document` 0.000
SELECT * FROM `skadate_link_menu_item_membership_type` 0.000
SELECT `document_key` AS `key`, `url` FROM `skadate_document` WHERE `url`='index.php' 0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `feature_id`,`name` FROM `skadate_feature` WHERE `active`='yes' 0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `tpl_timestamp` FROM `skadate_theme`
WHERE `theme_name`='dreamdate'
0.000
SELECT `index_page_code` FROM `skadate_theme`
WHERE `theme_name`='dreamdate'
0.000
SELECT `tpl_timestamp` FROM `skadate_theme`
WHERE `theme_name`='dreamdate'
0.000
SELECT * FROM `skadate_membership_service` INNER JOIN `skadate_feature` USING(`feature_id`) 0.001
SELECT `membership_service_key` FROM `skadate_link_membership_type_service` WHERE `membership_type_id`='1' 0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=6
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '940' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '940' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '940' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '940' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '940' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=9
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1191' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1191' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1191' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1191' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1191' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=1
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '54' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '54' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '54' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '54' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '54' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=10
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1355' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1355' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1355' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1355' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '1355' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex'
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` =0 AND `t1_in`.`value` = 'sex' )
GROUP BY `depended_profile_field_id`
0.023

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join' AND `fields`.`name` NOT IN ( 'match_agerange','relationship','height','match_height','match_general_description','match_sex','body_type','match_body_type','real_name','religion','match_religion','ethnicity','match_ethnicity','eye_color','match_eye_color','hair_color','match_hair_color','occupation','have_children','match_children','language','education','match_education','income','match_income','smoke','match_smoke','drink','match_drink','interests','callto','street','stav' )
ORDER BY `sections`.`order`, `fields`.`order`
0.002
SELECT `field`.*, `match_field_name`.`name` AS `matching`, `match_field`.`match_type` AS `matching_type`
FROM `skadate_profile_field` AS `field`
LEFT JOIN `skadate_link_profile_field_match` AS `match_field` ON `field`.`profile_field_id`=`match_field`.`match_profile_field_id`
LEFT JOIN `skadate_profile_field` AS `match_field_name` ON `match_field`.`profile_field_id`=`match_field_name`.`profile_field_id`
0.001
SELECT * FROM `skadate_profile_field_values` WHERE `profile_field_id` IN (1,2,3,4,5,6,8,9,10,11,12,14,15,16,20,21,56,68,71,98,99,100,101,102,103,104,107,108,109,110,111,112,113,114,115,116,117,122,123,124,126,127,128,129,130,131,132,133,134,135,136,137,139,140,141,142,143,144,145,146,148,150,164,171,186,187,188,197,202,208,210,212) ORDER BY `order` 0.001

SELECT `fields`.`name`, `fields`.`profile_field_id` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `fields`.`order`
0.000
DESCRIBE `skadate_profile` `username` 0.001
DESCRIBE `skadate_profile` `password` 0.000
DESCRIBE `skadate_profile` `email` 0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex'
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` =0 AND `t1_in`.`value` = 'sex' )
GROUP BY `depended_profile_field_id`
0.022

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join' AND `fields`.`name` NOT IN ( 'match_agerange','relationship','height','match_height','match_general_description','match_sex','body_type','match_body_type','real_name','religion','match_religion','ethnicity','match_ethnicity','eye_color','match_eye_color','hair_color','match_hair_color','occupation','have_children','match_children','language','education','match_education','income','match_income','smoke','match_smoke','drink','match_drink','interests','callto','street','stav' )
ORDER BY `sections`.`order`, `fields`.`order`
0.002
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex' AND `t1`.`value` !=1
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` ='sex' AND `t1_in`.`value` = 1 )
GROUP BY `depended_profile_field_id`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex' AND `t1`.`value` !=2
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` ='sex' AND `t1_in`.`value` = 2 )
GROUP BY `depended_profile_field_id`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex' AND `t1`.`value` !=4
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` ='sex' AND `t1_in`.`value` = 4 )
GROUP BY `depended_profile_field_id`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join' AND `fields`.`name` NOT IN ( 'match_sex','stav' )
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `Country_str_code`, `Region_str_code`, SUBSTRING( `Country_str_name`, 1, 33 ) AS `Country_str_name` FROM `skadate_location_country`
ORDER BY `Country_str_name`
0.001
SELECT * FROM `skadate_lang` 0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `membership_service_key` FROM `skadate_membership_service`
WHERE `membership_service_key`='view_hot_list'
AND `is_available_for_guest`='y' LIMIT 1
0.000
SELECT `h`.*, `profile`.*
FROM `skadate_hotlist` AS `h`
INNER JOIN `skadate_profile` AS `profile` ON (`h`.`profile_id`=`profile`.`profile_id`)
LEFT JOIN `skadate_profile_online` AS `o` ON (`o`.`profile_id`=`profile`.`profile_id`)
WHERE ( `profile`.`status`='active' )
ORDER BY `h`.`timestamp` DESC LIMIT 15
0.001
SELECT `active` FROM `skadate_sms_service`
WHERE `service_key`='hot_list'
0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =20004
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=20004 AND `number`=0 AND `status`='active' 0.001
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=20004 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =24553
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=24553 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=24553 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =29597
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=29597 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=29597 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =28434
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=28434 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=28434 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =30108
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=30108 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=30108 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =30119
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=30119 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=30119 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =10843
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=10843 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=10843 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =23991
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=23991 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=23991 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =11692
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=11692 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=11692 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =6831
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=6831 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=6831 0.000
SELECT `main`.* FROM `skadate_profile` AS `main`

WHERE `main`.`profile_id` =29739
0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=29739 AND `number`=0 AND `status`='active' 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=29739 0.000
SELECT `membership_service_key` FROM `skadate_membership_service`
WHERE `membership_service_key`='search'
AND `is_available_for_guest`='y' LIMIT 1
0.000

SELECT `fields`.`name`, `fields`.`profile_field_id` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
WHERE `form`.`profile_field_page_type`='search'
ORDER BY `fields`.`order`
0.000
SELECT DISTINCT `main`.`profile_id` FROM `skadate_profile` AS `main`

LEFT JOIN `skadate_profile_extended` AS `extend` USING( `profile_id` )
LEFT JOIN `skadate_profile_online` AS `online` USING( `profile_id` )

WHERE YEAR(NOW())-YEAR(`main`.`birthdate`)- IF( DAYOFYEAR(`main`.`birthdate`) > DAYOFYEAR(NOW()),1,0) >= 15
AND YEAR(NOW())-YEAR(`main`.`birthdate`)-IF( DAYOFYEAR(`main`.`birthdate`) > DAYOFYEAR(NOW()),1,0) <=104 AND ( `main`.`status`='active' )
ORDER BY `main`.`has_photo` DESC, IF( `online`.`profile_id` <> NULL, 0 , 1 ), `activity_stamp` DESC

LIMIT 500
0.219
INSERT INTO `skadate_tmp_profile_list`(`form_command`, `expiration_time`)
VALUES( 'main',1472668981 )
0.000
INSERT INTO `skadate_tmp_link_profile_list_profile`(`profile_list_id`, `profile_id`, `result_number`)VALUES(323850,11063,1),(323850,18366,2),(323850,23222,3),(323850,5282,4),(323850,28470,5),(323850,5229,6),(323850,7911,7),(323850,5914,8),(323850,25476,9),(323850,23069,10),(323850,11988,11),(323850,27857,12),(323850,10794,13),(323850,1020,14),(323850,25709,15),(323850,12764,16),(323850,27159,17),(323850,11692,18),(323850,814,19),(323850,3457,20),(323850,9784,21),(323850,21534,22),(323850,26080,23),(323850,29214,24),(323850,23980,25),(323850,3275,26),(323850,3728,27),(323850,829,28),(323850,25224,29),(323850,4125,30),(323850,27139,31),(323850,25506,32),(323850,23600,33),(323850,18815,34),(323850,751,35),(323850,1052,36),(323850,24592,37),(323850,22533,38),(323850,2059,39),(323850,28999,40),(323850,19628,41),(323850,27900,42),(323850,1369,43),(323850,892,44),(323850,26209,45),(323850,23192,46),(323850,28228,47),(323850,7616,48),(323850,26508,49),(323850,19994,50),(323850,266,51),(323850,8390,52),(323850,9417,53),(323850,15545,54),(323850,15916,55),(323850,3328,56),(323850,2441,57),(323850,3175,58),(323850,2277,59),(323850,7660,60),(323850,25717,61),(323850,19391,62),(323850,11243,63),(323850,2295,64),(323850,11119,65),(323850,1552,66),(323850,7436,67),(323850,8840,68),(323850,3387,69),(323850,8546,70),(323850,29180,71),(323850,22401,72),(323850,28496,73),(323850,2545,74),(323850,25957,75),(323850,9181,76),(323850,1242,77),(323850,21341,78),(323850,11755,79),(323850,29592,80),(323850,6494,81),(323850,23762,82),(323850,24020,83),(323850,976,84),(323850,4608,85),(323850,6447,86),(323850,10482,87),(323850,7819,88),(323850,3622,89),(323850,3398,90),(323850,25939,91),(323850,14838,92),(323850,9052,93),(323850,4004,94),(323850,28882,95),(323850,17163,96),(323850,24581,97),(323850,27272,98),(323850,1917,99),(323850,6281,100),(323850,30100,101),(323850,25204,102),(323850,822,103),(323850,1182,104),(323850,332,105),(323850,14483,106),(323850,22511,107),(323850,28166,108),(323850,238,109),(323850,433,110),(323850,421,111),(323850,344,112),(323850,23785,113),(323850,21504,114),(323850,25295,115),(323850,8517,116),(323850,3536,117),(323850,768,118),(323850,25718,119),(323850,7241,120),(323850,12352,121),(323850,28354,122),(323850,6852,123),(323850,28326,124),(323850,27905,125),(323850,1964,126),(323850,25926,127),(323850,6345,128),(323850,18924,129),(323850,29707,130),(323850,7182,131),(323850,29984,132),(323850,29828,133),(323850,30095,134),(323850,28386,135),(323850,26602,136),(323850,18668,137),(323850,29597,138),(323850,28919,139),(323850,323,140),(323850,11604,141),(323850,20004,142),(323850,9697,143),(323850,30125,144),(323850,10,145),(323850,8706,146),(323850,30127,147),(323850,30119,148),(323850,413,149),(323850,30113,150),(323850,24224,151),(323850,27564,152),(323850,1380,153),(323850,14,154),(323850,22798,155),(323850,10491,156),(323850,26397,157),(323850,13340,158),(323850,1902,159),(323850,30108,160),(323850,23991,161),(323850,18437,162),(323850,24553,163),(323850,24124,164),(323850,28434,165),(323850,30096,166),(323850,2392,167),(323850,10862,168),(323850,30117,169),(323850,30118,170),(323850,16660,171),(323850,21987,172),(323850,12121,173),(323850,28449,174),(323850,26728,175),(323850,22203,176),(323850,3859,177),(323850,29694,178),(323850,30024,179),(323850,30111,180),(323850,2909,181),(323850,30114,182),(323850,26329,183),(323850,29603,184),(323850,16074,185),(323850,11579,186),(323850,10843,187),(323850,12551,188),(323850,30075,189),(323850,6895,190),(323850,29777,191),(323850,10787,192),(323850,25812,193),(323850,22200,194),(323850,29980,195),(323850,29843,196),(323850,4869,197),(323850,30115,198),(323850,28991,199),(323850,6582,200),(323850,746,201),(323850,26279,202),(323850,29318,203),(323850,9621,204),(323850,22284,205),(323850,30047,206),(323850,554,207),(323850,4180,208),(323850,29477,209),(323850,139,210),(323850,30109,211),(323850,23484,212),(323850,28235,213),(323850,29860,214),(323850,10011,215),(323850,30093,216),(323850,22553,217),(323850,8772,218),(323850,7264,219),(323850,27851,220),(323850,29052,221),(323850,25628,222),(323850,2306,223),(323850,22681,224),(323850,15062,225),(323850,29626,226),(323850,30064,227),(323850,29563,228),(323850,29892,229),(323850,1445,230),(323850,29000,231),(323850,27654,232),(323850,1861,233),(323850,5537,234),(323850,22784,235),(323850,30107,236),(323850,23826,237),(323850,29355,238),(323850,23200,239),(323850,30080,240),(323850,123,241),(323850,19872,242),(323850,24100,243),(323850,21330,244),(323850,26896,245),(323850,29520,246),(323850,25982,247),(323850,30008,248),(323850,29642,249),(323850,2642,250),(323850,27034,251),(323850,23525,252),(323850,11086,253),(323850,11481,254),(323850,10086,255),(323850,28149,256),(323850,29858,257),(323850,30044,258),(323850,6496,259),(323850,19288,260),(323850,30105,261),(323850,29725,262),(323850,1208,263),(323850,19800,264),(323850,29863,265),(323850,1831,266),(323850,28757,267),(323850,2526,268),(323850,23182,269),(323850,29729,270),(323850,14162,271),(323850,29775,272),(323850,30071,273),(323850,30045,274),(323850,3975,275),(323850,28801,276),(323850,1348,277),(323850,30011,278),(323850,27063,279),(323850,25411,280),(323850,24433,281),(323850,7418,282),(323850,29797,283),(323850,30037,284),(323850,1360,285),(323850,24673,286),(323850,5360,287),(323850,25804,288),(323850,26067,289),(323850,20229,290),(323850,25046,291),(323850,3593,292),(323850,29999,293),(323850,19203,294),(323850,24755,295),(323850,29956,296),(323850,770,297),(323850,30090,298),(323850,29885,299),(323850,4949,300),(323850,30091,301),(323850,29688,302),(323850,30098,303),(323850,29806,304),(323850,29030,305),(323850,18330,306),(323850,7043,307),(323850,6831,308),(323850,30082,309),(323850,1316,310),(323850,28148,311),(323850,29988,312),(323850,16755,313),(323850,23448,314),(323850,29833,315),(323850,30067,316),(323850,22658,317),(323850,30097,318),(323850,28226,319),(323850,10950,320),(323850,4031,321),(323850,26255,322),(323850,24805,323),(323850,4210,324),(323850,22843,325),(323850,9175,326),(323850,11044,327),(323850,28718,328),(323850,29739,329),(323850,30089,330),(323850,4927,331),(323850,29901,332),(323850,3695,333),(323850,21045,334),(323850,12701,335),(323850,21459,336),(323850,30086,337),(323850,11850,338),(323850,4583,339),(323850,15618,340),(323850,9602,341),(323850,2458,342),(323850,26640,343),(323850,4252,344),(323850,28472,345),(323850,6932,346),(323850,25374,347),(323850,6224,348),(323850,26795,349),(323850,7312,350),(323850,30021,351),(323850,29307,352),(323850,22883,353),(323850,28248,354),(323850,28657,355),(323850,29727,356),(323850,14847,357),(323850,29023,358),(323850,29693,359),(323850,29467,360),(323850,4712,361),(323850,1228,362),(323850,21672,363),(323850,29068,364),(323850,25266,365),(323850,8382,366),(323850,30000,367),(323850,29681,368),(323850,19136,369),(323850,3820,370),(323850,2520,371),(323850,20066,372),(323850,1856,373),(323850,881,374),(323850,30076,375),(323850,8169,376),(323850,30077,377),(323850,16363,378),(323850,5945,379),(323850,30074,380),(323850,26309,381),(323850,28164,382),(323850,21038,383),(323850,1560,384),(323850,6843,385),(323850,11175,386),(323850,2233,387),(323850,23050,388),(323850,30073,389),(323850,14091,390),(323850,14206,391),(323850,30072,392),(323850,5017,393),(323850,29541,394),(323850,29020,395),(323850,9110,396),(323850,2704,397),(323850,29957,398),(323850,29772,399),(323850,23166,400),(323850,29943,401),(323850,12181,402),(323850,24177,403),(323850,9262,404),(323850,5164,405),(323850,28668,406),(323850,25213,407),(323850,3012,408),(323850,29769,409),(323850,13228,410),(323850,22311,411),(323850,12449,412),(323850,10803,413),(323850,23597,414),(323850,28533,415),(323850,19696,416),(323850,29669,417),(323850,30068,418),(323850,22873,419),(323850,24894,420),(323850,23372,421),(323850,10940,422),(323850,16665,423),(323850,11053,424),(323850,5046,425),(323850,7063,426),(323850,23101,427),(323850,24789,428),(323850,18365,429),(323850,30062,430),(323850,6574,431),(323850,29859,432),(323850,2148,433),(323850,29995,434),(323850,30060,435),(323850,6903,436),(323850,23076,437),(323850,20330,438),(323850,23186,439),(323850,4976,440),(323850,315,441),(323850,30055,442),(323850,26427,443),(323850,15151,444),(323850,28802,445),(323850,27200,446),(323850,30052,447),(323850,11372,448),(323850,25809,449),(323850,27317,450),(323850,6727,451),(323850,29954,452),(323850,10607,453),(323850,2977,454),(323850,29965,455),(323850,8482,456),(323850,30049,457),(323850,23936,458),(323850,24845,459),(323850,24738,460),(323850,14163,461),(323850,27191,462),(323850,12066,463),(323850,624,464),(323850,30002,465),(323850,29621,466),(323850,630,467),(323850,16550,468),(323850,12646,469),(323850,28099,470),(323850,9018,471),(323850,16272,472),(323850,1077,473),(323850,28670,474),(323850,18622,475),(323850,23530,476),(323850,29587,477),(323850,1745,478),(323850,28865,479),(323850,16195,480),(323850,27680,481),(323850,10810,482),(323850,4968,483),(323850,25441,484),(323850,13615,485),(323850,4554,486),(323850,8322,487),(323850,6873,488),(323850,29664,489),(323850,6920,490),(323850,24515,491),(323850,30041,492),(323850,23320,493),(323850,5997,494),(323850,29959,495),(323850,17021,496),(323850,9637,497),(323850,24578,498),(323850,1890,499),(323850,21958,500) 0.004
SELECT `prof_extend`.*, `prof`.*, `tmp_list_link`.`result_number`, `prof_online`.`hash` AS `online` FROM `skadate_tmp_link_profile_list_profile` AS `tmp_list_link`
LEFT JOIN `skadate_profile` AS `prof` USING( `profile_id` )
LEFT JOIN `skadate_profile_extended` AS `prof_extend` USING( `profile_id` )
LEFT JOIN `skadate_profile_online` AS `prof_online` USING( `profile_id` )
WHERE `tmp_list_link`.`profile_list_id`=323850
ORDER BY `tmp_list_link`.`result_number`
LIMIT 0, 16
0.003
SELECT `name` FROM `skadate_profile_field`
WHERE `presentation`='birthdate' AND `profile_list_template` = 1
0.000
SELECT `value` FROM `skadate_profile_field_dependence` WHERE `depended_profile_field_id`=8 0.000
SELECT `main`.* FROM `skadate_profile` AS `main` WHERE `main`.`profile_id` IN (11063,18366,23222,5282,28470,5229,7911,5914,25476,23069,11988,27857,10794,1020,25709,12764) 0.000
SELECT `main`.*,`location_country`.`Country_str_name` AS `country`,`location_state`.`Admin1_str_name` AS `state`,`location_city`.`Feature_str_name` AS `city` FROM `skadate_profile` AS `main` LEFT JOIN `skadate_location_country` AS `location_country`
ON `main`.`country_id`=`location_country`.`Country_str_code`LEFT JOIN `skadate_location_state` AS `location_state`
ON `main`.`state_id`=`location_state`.`Admin1_str_code`LEFT JOIN `skadate_location_city` AS `location_city`
ON `main`.`city_id`=`location_city`.`Feature_int_id` WHERE `main`.`profile_id` IN (11063,18366,23222,5282,28470,5229,7911,5914,25476,23069,11988,27857,10794,1020,25709,12764)
0.001
SELECT `status`, `profile_id` FROM `skadate_user_status` WHERE `profile_id` IN (11063,18366,23222,5282,28470,5229,7911,5914,25476,23069,11988,27857,10794,1020,25709,12764) 0.000
SELECT `profile_id`, COUNT(`photo`.`photo_id`) as `count` FROM `skadate_profile_photo` AS `photo`
LEFT JOIN `skadate_photo_album_items` AS `album` ON `photo`.`photo_id` = `album`.`photo_id`
WHERE `profile_id` IN (11063,18366,23222,5282,28470,5229,7911,5914,25476,23069,11988,27857,10794,1020,25709,12764) AND `album`.`photo_id` IS NULL AND `photo`.`number`!=0 AND `photo`.`status`='active' group by `profile_id`
0.001
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=11063 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=11063 AND `number`=0 0.000
SELECT * FROM `skadate_badword` 0.000
SELECT * FROM `skadate_smile` 0.000
SELECT * FROM `skadate_profile_preference` WHERE 1 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=11063 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=18366 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=18366 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=18366 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=23222 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=23222 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=23222 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=5282 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=5282 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=5282 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=28470 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=28470 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=28470 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=5229 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=5229 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=5229 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=7911 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=7911 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=7911 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=5914 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=5914 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=5914 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=25476 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=25476 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=25476 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=23069 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=23069 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=23069 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=11988 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=11988 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=11988 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=27857 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=27857 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=27857 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=10794 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=10794 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=10794 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=1020 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=1020 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=1020 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=25709 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=25709 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=25709 0.000
SELECT `hash` FROM `skadate_profile_online` WHERE `profile_id`=12764 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=12764 AND `number`=0 0.000
SELECT * FROM `skadate_profile_preference_data` WHERE `profile_id`=12764 0.000
SELECT `profile_id` FROM `skadate_hotlist` 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=11063 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=18366 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=23222 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=5282 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=28470 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=5229 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=7911 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=5914 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=25476 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=23069 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=11988 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=27857 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=10794 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=1020 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=25709 AND `number`=0 AND `status`='active' 0.000
SELECT * FROM `skadate_profile_photo` WHERE `profile_id`=12764 AND `number`=0 AND `status`='active' 0.000

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='edit'
ORDER BY `sections`.`order`, `fields`.`order`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='edit'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t2`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
GROUP BY `t1`.`profile_field_id`
LIMIT 1
0.000
SELECT `fields`.`name`,`fields`.`profile_field_id`,`fields`.`profile_field_section_id` FROM `skadate_link_profile_field_page` AS `page_link`
LEFT JOIN `skadate_profile_field` AS `fields` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `page_link`.`profile_field_page_type`='search' AND `page_link`.`number`=1
ORDER BY `sections`.`order`, `fields`.`order`
0.001

SELECT `fields`.`name`, `fields`.`profile_field_id` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
WHERE `form`.`profile_field_page_type`='search'
ORDER BY `fields`.`order`
0.002
SELECT `Country_str_code`, `Region_str_code`, SUBSTRING( `Country_str_name`, 1, 33 ) AS `Country_str_name` FROM `skadate_location_country`
ORDER BY `Country_str_name`
0.002
SELECT count(*) FROM `skadate_location_zip` 0.004
SELECT `region_str_name` as `name`, `r`.`region_str_code` as `code` FROM `skadate_location_region` AS `r`
LEFT JOIN `skadate_location_country` AS `c` ON ( `r`.`Region_str_code` = `c`.`Region_str_code` )
WHERE `c`.`Country_str_code` IS NOT NULL
0.001
SELECT `Country_str_code`, `Region_str_code`, SUBSTRING( `Country_str_name`, 1, 33 ) AS `Country_str_name` FROM `skadate_location_country`
ORDER BY `Country_str_name`
0.001
SELECT count(*) FROM `skadate_location_zip` 0.000
SELECT `Country_str_code`, `Region_str_code`, SUBSTRING( `Country_str_name`, 1, 33 ) AS `Country_str_name` FROM `skadate_location_country`
ORDER BY `Country_str_name`
0.001
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=4
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '57' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '57' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '57' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '57' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '57' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=14
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2011' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2011' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2011' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2011' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2011' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=15
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2175' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2175' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2175' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2175' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2175' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=16
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2339' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2339' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.001
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2339' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2339' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2339' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=17
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.003
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2503' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2503' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2503' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2503' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '2503' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT `link_id` FROM `skadate_link_ads_page_position`
WHERE `document_key`='index' AND `position_id`=2
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '55' AND ( `tplc`.`Country_str_code` = 'Q' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '55' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '55' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '55' AND ( `tplc`.`Country_str_code` = 'EN' OR `tplc`.`Country_str_code` = '' )
0.000
SELECT `tpl`.`code` FROM `skadate_link_ads_binding_template_set` AS `bind`
LEFT JOIN `skadate_link_ads_binding_country` AS `tplc` USING ( `template_set_id` )
LEFT JOIN `skadate_ads_template` AS `tpl` USING ( `template_id` )
WHERE `bind`.`link_id` = '55' AND ( `tplc`.`Country_str_code` = 'XX' OR `tplc`.`Country_str_code` = 'XX' )
0.000
SELECT lang_id, abbrev FROM `skadate_lang` 0.000
SELECT `abbrev` FROM `skadate_lang` WHERE `lang_id` = 1 LIMIT 1 0.000

SELECT * FROM `skadate_theme` WHERE `theme_name`='dreamdate'
0.000
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex'
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` =0 AND `t1_in`.`value` = 'sex' )
GROUP BY `depended_profile_field_id`
0.035

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join' AND `fields`.`name` NOT IN ( 'match_agerange','relationship','height','match_height','match_general_description','match_sex','body_type','match_body_type','real_name','religion','match_religion','ethnicity','match_ethnicity','eye_color','match_eye_color','hair_color','match_hair_color','occupation','have_children','match_children','language','education','match_education','income','match_income','smoke','match_smoke','drink','match_drink','interests','callto','street','stav' )
ORDER BY `sections`.`order`, `fields`.`order`
0.003

SELECT `fields`.`name`, `fields`.`profile_field_id` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `fields`.`order`
0.001
DESCRIBE `skadate_profile` `username` 0.001
DESCRIBE `skadate_profile` `password` 0.000
DESCRIBE `skadate_profile` `email` 0.000

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex'
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` =0 AND `t1_in`.`value` = 'sex' )
GROUP BY `depended_profile_field_id`
0.037

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join' AND `fields`.`name` NOT IN ( 'match_agerange','relationship','height','match_height','match_general_description','match_sex','body_type','match_body_type','real_name','religion','match_religion','ethnicity','match_ethnicity','eye_color','match_eye_color','hair_color','match_hair_color','occupation','have_children','match_children','language','education','match_education','income','match_income','smoke','match_smoke','drink','match_drink','interests','callto','street','stav' )
ORDER BY `sections`.`order`, `fields`.`order`
0.008
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex' AND `t1`.`value` !=1
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` ='sex' AND `t1_in`.`value` = 1 )
GROUP BY `depended_profile_field_id`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex' AND `t1`.`value` !=2
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` ='sex' AND `t1_in`.`value` = 2 )
GROUP BY `depended_profile_field_id`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join'
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `t3`.`name` FROM `skadate_profile_field_dependence` AS `t1`
LEFT JOIN `skadate_profile_field` AS `t2` USING( `profile_field_id` )
LEFT JOIN `skadate_profile_field` AS `t3` ON( `t1`.`depended_profile_field_id` = `t3`.`profile_field_id` )
WHERE `t2`.`name` ='sex' AND `t1`.`value` !=4
AND `depended_profile_field_id` NOT IN ( SELECT `depended_profile_field_id` FROM `skadate_profile_field_dependence` AS `t1_in`
LEFT JOIN `skadate_profile_field` AS `t2_in` USING( `profile_field_id` )
WHERE `t2_in`.`name` ='sex' AND `t1_in`.`value` = 4 )
GROUP BY `depended_profile_field_id`
0.001

SELECT `form`.`number`, `fields`.`profile_field_id` AS `id`, `fields`.`name` FROM `skadate_link_profile_field_page` AS `form`
JOIN `skadate_profile_field` AS `fields` USING(`profile_field_id`)
LEFT JOIN `skadate_profile_field_section` AS `sections` USING( `profile_field_section_id` )
WHERE `form`.`profile_field_page_type`='join' AND `fields`.`name` NOT IN ( 'match_sex','stav' )
ORDER BY `sections`.`order`, `fields`.`order`
0.001
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.009
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=127 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=107 AND `lang_id`=1
0.000
SELECT `key`, `value`
FROM `skadate_lang_key` LEFT JOIN `skadate_lang_value` USING(`lang_key_id`)
WHERE `lang_section_id`=110 AND `lang_id`=1
0.002
SELECT `Country_str_code`, `Region_str_code`, SUBSTRING( `Country_str_name`, 1, 33 ) AS `Country_str_name` FROM `skadate_location_country`
ORDER BY `Country_str_name`
0.001
OW Debug - Vardump
13.881217956543

Type: Double