Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "mature wife orgasm"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature wife orgasm' LIMIT 1;

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  592974
  594491
  634108
  791209
  786114
  738503
  766335
  720206
  444913
  440980
  460754
  467875
  471620
  429916
  391754
  456999
  459649
  461843
  527641
  527670
  528143
  489207
  511911
  485996
  582694
  591197
  521792
  501488
  583021
  485057
  486775
  485064
  513839
  529406
  555972
  555984
  571726
  566788
  709524
  710161
  642022
  609057
  592573
  609083
  434361
  460535
  429861
  444915
  429867
  527624
  530001
  506350
  513328
  525884
  439532
  413373
  520767
  507284
  562973
  440345
  445745
  429888
  492701
  595080
  515341
  429899
  429900
  521798
  492050
  428761
  510898
  424385
  623684
  562790
]

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.search_field,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (592974, 594491, 634108, 791209, 786114, 738503, 766335, 720206, 444913, 440980, 460754, 467875, 471620, 429916, 391754, 456999, 459649, 461843, 527641, 527670, 528143, 489207, 511911, 485996, 582694, 591197, 521792, 501488, 583021, 485057, 486775, 485064, 513839, 529406, 555972, 555984, 571726, 566788, 709524, 710161, 642022, 609057, 592573, 609083, 434361, 460535, 429861, 444915, 429867, 527624, 530001, 506350, 513328, 525884, 439532, 413373, 520767, 507284, 562973, 440345, 445745, 429888, 492701, 595080, 515341, 429899, 429900, 521798, 492050, 428761, 510898, 424385, 623684, 562790);

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  391754
  413373
  424385
  428761
  429861
  429867
  429888
  429899
  429900
  429916
  434361
  439532
  440345
  440980
  444913
  444915
  445745
  456999
  459649
  460535
  460754
  461843
  467875
  471620
  485057
  485064
  485996
  486775
  489207
  492050
  492701
  501488
  506350
  507284
  510898
  511911
  513328
  513839
  515341
  520767
  521792
  521798
  525884
  527624
  527641
  527670
  528143
  529406
  530001
  555972
  555984
  562790
  562973
  566788
  571726
  582694
  583021
  591197
  592573
  592974
  594491
  595080
  609057
  609083
  623684
  634108
  642022
  709524
  710161
  720206
  738503
  766335
  786114
  791209
]

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (391754, 413373, 424385, 428761, 429861, 429867, 429888, 429899, 429900, 429916, 434361, 439532, 440345, 440980, 444913, 444915, 445745, 456999, 459649, 460535, 460754, 461843, 467875, 471620, 485057, 485064, 485996, 486775, 489207, 492050, 492701, 501488, 506350, 507284, 510898, 511911, 513328, 513839, 515341, 520767, 521792, 521798, 525884, 527624, 527641, 527670, 528143, 529406, 530001, 555972, 555984, 562790, 562973, 566788, 571726, 582694, 583021, 591197, 592573, 592974, 594491, 595080, 609057, 609083, 623684, 634108, 642022, 709524, 710161, 720206, 738503, 766335, 786114, 791209);

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  391754
  413373
  424385
  428761
  429861
  429867
  429888
  429899
  429900
  429916
  434361
  439532
  440345
  440980
  444913
  444915
  445745
  456999
  459649
  460535
  460754
  461843
  467875
  471620
  485057
  485064
  485996
  486775
  489207
  492050
  492701
  501488
  506350
  507284
  510898
  511911
  513328
  513839
  515341
  520767
  521792
  521798
  525884
  527624
  527641
  527670
  528143
  529406
  530001
  555972
  555984
  562790
  562973
  566788
  571726
  582694
  583021
  591197
  592573
  592974
  594491
  595080
  609057
  609083
  623684
  634108
  642022
  709524
  710161
  720206
  738503
  766335
  786114
  791209
]

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (391754, 413373, 424385, 428761, 429861, 429867, 429888, 429899, 429900, 429916, 434361, 439532, 440345, 440980, 444913, 444915, 445745, 456999, 459649, 460535, 460754, 461843, 467875, 471620, 485057, 485064, 485996, 486775, 489207, 492050, 492701, 501488, 506350, 507284, 510898, 511911, 513328, 513839, 515341, 520767, 521792, 521798, 525884, 527624, 527641, 527670, 528143, 529406, 530001, 555972, 555984, 562790, 562973, 566788, 571726, 582694, 583021, 591197, 592573, 592974, 594491, 595080, 609057, 609083, 623684, 634108, 642022, 709524, 710161, 720206, 738503, 766335, 786114, 791209);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "mature жен orgasm"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature жен orgasm';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "mature жен orgasm"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature жен orgasm';