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

[
  "russian wife home"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian wife home' 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
  493382
  440893
  443085
  580113
  575261
  797241
  448074
  400497
  463305
  439791
  439808
  452179
  475195
  520700
  510425
  492705
  507638
  509561
  513521
  527257
  564656
  415342
  491943
  552908
  553608
  510083
  522311
  439586
  476015
  507711
  597015
  513506
  617370
  470506
  554210
  601848
  439627
  439768
  462351
  421878
  517833
  484583
  516718
  586134
  620836
  435436
  527839
  602716
  608106
  556009
  423783
  518611
  520911
  620754
  517118
  519128
  549830
  528452
  519528
  557021
  613282
  464327
  569386
  504183
  520870
  590596
  582269
  751565
  419628
  485928
  514815
  623074
  603923
  568072
  546114
]

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 (493382, 440893, 443085, 580113, 575261, 797241, 448074, 400497, 463305, 439791, 439808, 452179, 475195, 520700, 510425, 492705, 507638, 509561, 513521, 527257, 564656, 415342, 491943, 552908, 553608, 510083, 522311, 439586, 476015, 507711, 597015, 513506, 617370, 470506, 554210, 601848, 439627, 439768, 462351, 421878, 517833, 484583, 516718, 586134, 620836, 435436, 527839, 602716, 608106, 556009, 423783, 518611, 520911, 620754, 517118, 519128, 549830, 528452, 519528, 557021, 613282, 464327, 569386, 504183, 520870, 590596, 582269, 751565, 419628, 485928, 514815, 623074, 603923, 568072, 546114);

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
  400497
  415342
  419628
  421878
  423783
  435436
  439586
  439627
  439768
  439791
  439808
  440893
  443085
  448074
  452179
  462351
  463305
  464327
  470506
  475195
  476015
  484583
  485928
  491943
  492705
  493382
  504183
  507638
  507711
  509561
  510083
  510425
  513506
  513521
  514815
  516718
  517118
  517833
  518611
  519128
  519528
  520700
  520870
  520911
  522311
  527257
  527839
  528452
  546114
  549830
  552908
  553608
  554210
  556009
  557021
  564656
  568072
  569386
  575261
  580113
  582269
  586134
  590596
  597015
  601848
  602716
  603923
  608106
  613282
  617370
  620754
  620836
  623074
  751565
  797241
]

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 (400497, 415342, 419628, 421878, 423783, 435436, 439586, 439627, 439768, 439791, 439808, 440893, 443085, 448074, 452179, 462351, 463305, 464327, 470506, 475195, 476015, 484583, 485928, 491943, 492705, 493382, 504183, 507638, 507711, 509561, 510083, 510425, 513506, 513521, 514815, 516718, 517118, 517833, 518611, 519128, 519528, 520700, 520870, 520911, 522311, 527257, 527839, 528452, 546114, 549830, 552908, 553608, 554210, 556009, 557021, 564656, 568072, 569386, 575261, 580113, 582269, 586134, 590596, 597015, 601848, 602716, 603923, 608106, 613282, 617370, 620754, 620836, 623074, 751565, 797241);

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
  400497
  415342
  419628
  421878
  423783
  435436
  439586
  439627
  439768
  439791
  439808
  440893
  443085
  448074
  452179
  462351
  463305
  464327
  470506
  475195
  476015
  484583
  485928
  491943
  492705
  493382
  504183
  507638
  507711
  509561
  510083
  510425
  513506
  513521
  514815
  516718
  517118
  517833
  518611
  519128
  519528
  520700
  520870
  520911
  522311
  527257
  527839
  528452
  546114
  549830
  552908
  553608
  554210
  556009
  557021
  564656
  568072
  569386
  575261
  580113
  582269
  586134
  590596
  597015
  601848
  602716
  603923
  608106
  613282
  617370
  620754
  620836
  623074
  751565
  797241
]

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 (400497, 415342, 419628, 421878, 423783, 435436, 439586, 439627, 439768, 439791, 439808, 440893, 443085, 448074, 452179, 462351, 463305, 464327, 470506, 475195, 476015, 484583, 485928, 491943, 492705, 493382, 504183, 507638, 507711, 509561, 510083, 510425, 513506, 513521, 514815, 516718, 517118, 517833, 518611, 519128, 519528, 520700, 520870, 520911, 522311, 527257, 527839, 528452, 546114, 549830, 552908, 553608, 554210, 556009, 557021, 564656, 568072, 569386, 575261, 580113, 582269, 586134, 590596, 597015, 601848, 602716, 603923, 608106, 613282, 617370, 620754, 620836, 623074, 751565, 797241);

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

[
  "русск жен home"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск жен home';

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

[
  "русск жен home"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск жен home';