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

[
  "money blowjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'money blowjob' 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
  420769
  594966
  525835
  489060
  485158
  518595
  533607
  551620
  591648
  594933
  594863
  612051
  467404
  483379
  486965
  497203
  510686
  435716
  481688
  576082
  443381
  430291
  504593
  551456
  578128
  584646
  488212
  594874
  591791
  584863
  467186
  589716
  554563
  562626
  543917
  520299
  483594
  487144
  489134
  564737
  599222
  521552
  577396
  496259
  594770
  518943
  534683
  486587
  465354
  515126
  565077
  603937
  594964
  625968
  403538
  515778
  589731
  573477
  492712
  554770
  630859
  594819
  661528
  513707
  515613
  521526
  543479
  467293
  611649
  611989
  611892
  611616
  558991
  611986
  609652
]

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 (420769, 594966, 525835, 489060, 485158, 518595, 533607, 551620, 591648, 594933, 594863, 612051, 467404, 483379, 486965, 497203, 510686, 435716, 481688, 576082, 443381, 430291, 504593, 551456, 578128, 584646, 488212, 594874, 591791, 584863, 467186, 589716, 554563, 562626, 543917, 520299, 483594, 487144, 489134, 564737, 599222, 521552, 577396, 496259, 594770, 518943, 534683, 486587, 465354, 515126, 565077, 603937, 594964, 625968, 403538, 515778, 589731, 573477, 492712, 554770, 630859, 594819, 661528, 513707, 515613, 521526, 543479, 467293, 611649, 611989, 611892, 611616, 558991, 611986, 609652);

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
  403538
  420769
  430291
  435716
  443381
  465354
  467186
  467293
  467404
  481688
  483379
  483594
  485158
  486587
  486965
  487144
  488212
  489060
  489134
  492712
  496259
  497203
  504593
  510686
  513707
  515126
  515613
  515778
  518595
  518943
  520299
  521526
  521552
  525835
  533607
  534683
  543479
  543917
  551456
  551620
  554563
  554770
  558991
  562626
  564737
  565077
  573477
  576082
  577396
  578128
  584646
  584863
  589716
  589731
  591648
  591791
  594770
  594819
  594863
  594874
  594933
  594964
  594966
  599222
  603937
  609652
  611616
  611649
  611892
  611986
  611989
  612051
  625968
  630859
  661528
]

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 (403538, 420769, 430291, 435716, 443381, 465354, 467186, 467293, 467404, 481688, 483379, 483594, 485158, 486587, 486965, 487144, 488212, 489060, 489134, 492712, 496259, 497203, 504593, 510686, 513707, 515126, 515613, 515778, 518595, 518943, 520299, 521526, 521552, 525835, 533607, 534683, 543479, 543917, 551456, 551620, 554563, 554770, 558991, 562626, 564737, 565077, 573477, 576082, 577396, 578128, 584646, 584863, 589716, 589731, 591648, 591791, 594770, 594819, 594863, 594874, 594933, 594964, 594966, 599222, 603937, 609652, 611616, 611649, 611892, 611986, 611989, 612051, 625968, 630859, 661528);

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
  403538
  420769
  430291
  435716
  443381
  465354
  467186
  467293
  467404
  481688
  483379
  483594
  485158
  486587
  486965
  487144
  488212
  489060
  489134
  492712
  496259
  497203
  504593
  510686
  513707
  515126
  515613
  515778
  518595
  518943
  520299
  521526
  521552
  525835
  533607
  534683
  543479
  543917
  551456
  551620
  554563
  554770
  558991
  562626
  564737
  565077
  573477
  576082
  577396
  578128
  584646
  584863
  589716
  589731
  591648
  591791
  594770
  594819
  594863
  594874
  594933
  594964
  594966
  599222
  603937
  609652
  611616
  611649
  611892
  611986
  611989
  612051
  625968
  630859
  661528
]

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 (403538, 420769, 430291, 435716, 443381, 465354, 467186, 467293, 467404, 481688, 483379, 483594, 485158, 486587, 486965, 487144, 488212, 489060, 489134, 492712, 496259, 497203, 504593, 510686, 513707, 515126, 515613, 515778, 518595, 518943, 520299, 521526, 521552, 525835, 533607, 534683, 543479, 543917, 551456, 551620, 554563, 554770, 558991, 562626, 564737, 565077, 573477, 576082, 577396, 578128, 584646, 584863, 589716, 589731, 591648, 591791, 594770, 594819, 594863, 594874, 594933, 594964, 594966, 599222, 603937, 609652, 611616, 611649, 611892, 611986, 611989, 612051, 625968, 630859, 661528);

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

[
  "money минет оральн секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'money минет оральн секс';

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

[
  "money минет оральн секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'money минет оральн секс';