Noví lidé

OW Debug - Vardump
array
(
    [marks] => array
    (
        [start] => 0.000
        [display -> frontend init] => 0.070
        [__ping__ cmp render start] => 0.071
        [__ping__ cmp render end] => 0.083
        [__sign_in__ cmp render start] => 0.244
        [__forgot_password__ cmp render start] => 0.304
        [__forgot_password__ cmp render end] => 0.316
        [__sign_in__ cmp render end] => 0.316
        [display -> render hid cmp] => 0.172
        [__index__ cmp render start] => 0.172
        [__navigation_menu_main__ cmp render start] => 0.219
        [__registration_popup__ cmp render start] => 0.956
        [__fbc_button__ cmp render start] => 0.965
        [__fbc_button__ cmp render end] => 0.974
        [__join__ cmp render start] => 0.974
        [__join__ cmp render end] => 1.124
        [__registration_popup__ cmp render end] => 1.124
        [__select_language__ cmp render start] => 0.468
        [__select_language__ cmp render end] => 0.475
        [__navigation_menu_main__ cmp render end] => 0.475
        [__hot_list__ cmp render start] => 0.477
        [__hot_list__ cmp render end] => 0.503
        [__profile_list__ cmp render start] => 0.509
        [__profile_list__ cmp render end] => 0.818
        [__main_search__ cmp render start] => 0.819
        [__main_search__ cmp render end] => 0.907
        [__page_footer__ cmp render start] => 0.919
        [__page_footer__ cmp render end] => 0.936
        [__index__ cmp render end] => 0.940
        [display -> render httpdoc] => 0.940
        [display -> dev actions] => 0.944
        [display -> meta get] => 0.944
        [end] => 1.129
    )
    [total] => 1.129
)

Type: Array
    				
total query exec time  0.39760780334473      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.026

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

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 `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.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.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 `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
OW Debug - Vardump
13.881378173828

Type: Double