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

[
  "best blowjob pov"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'best blowjob pov' 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
  551886
  447625
  746510
  577392
  581625
  632551
  511882
  528856
  564161
  614687
  555510
  442918
  559109
  598195
  607277
  791943
  771918
  508836
  442864
  641901
  452545
  582417
  565866
  527989
  527135
  560816
  449778
  449666
  452456
  555325
  463511
  512844
  623212
  600990
  448260
  524225
  447722
  457887
  508516
  525277
  434792
  514645
  462685
  441398
  564162
  425523
  500194
  566295
  601845
  446984
  446431
  552974
  559567
  578587
  577335
  446897
  568796
  436820
  528738
  608206
  526258
  567051
  540073
  577323
  543906
  488123
  560517
  599144
  582258
  568062
  621277
]

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 (551886, 447625, 746510, 577392, 581625, 632551, 511882, 528856, 564161, 614687, 555510, 442918, 559109, 598195, 607277, 791943, 771918, 508836, 442864, 641901, 452545, 582417, 565866, 527989, 527135, 560816, 449778, 449666, 452456, 555325, 463511, 512844, 623212, 600990, 448260, 524225, 447722, 457887, 508516, 525277, 434792, 514645, 462685, 441398, 564162, 425523, 500194, 566295, 601845, 446984, 446431, 552974, 559567, 578587, 577335, 446897, 568796, 436820, 528738, 608206, 526258, 567051, 540073, 577323, 543906, 488123, 560517, 599144, 582258, 568062, 621277);

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
  425523
  434792
  436820
  441398
  442864
  442918
  446431
  446897
  446984
  447625
  447722
  448260
  449666
  449778
  452456
  452545
  457887
  462685
  463511
  488123
  500194
  508516
  508836
  511882
  512844
  514645
  524225
  525277
  526258
  527135
  527989
  528738
  528856
  540073
  543906
  551886
  552974
  555325
  555510
  559109
  559567
  560517
  560816
  564161
  564162
  565866
  566295
  567051
  568062
  568796
  577323
  577335
  577392
  578587
  581625
  582258
  582417
  598195
  599144
  600990
  601845
  607277
  608206
  614687
  621277
  623212
  632551
  641901
  746510
  771918
  791943
]

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 (425523, 434792, 436820, 441398, 442864, 442918, 446431, 446897, 446984, 447625, 447722, 448260, 449666, 449778, 452456, 452545, 457887, 462685, 463511, 488123, 500194, 508516, 508836, 511882, 512844, 514645, 524225, 525277, 526258, 527135, 527989, 528738, 528856, 540073, 543906, 551886, 552974, 555325, 555510, 559109, 559567, 560517, 560816, 564161, 564162, 565866, 566295, 567051, 568062, 568796, 577323, 577335, 577392, 578587, 581625, 582258, 582417, 598195, 599144, 600990, 601845, 607277, 608206, 614687, 621277, 623212, 632551, 641901, 746510, 771918, 791943);

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
  425523
  434792
  436820
  441398
  442864
  442918
  446431
  446897
  446984
  447625
  447722
  448260
  449666
  449778
  452456
  452545
  457887
  462685
  463511
  488123
  500194
  508516
  508836
  511882
  512844
  514645
  524225
  525277
  526258
  527135
  527989
  528738
  528856
  540073
  543906
  551886
  552974
  555325
  555510
  559109
  559567
  560517
  560816
  564161
  564162
  565866
  566295
  567051
  568062
  568796
  577323
  577335
  577392
  578587
  581625
  582258
  582417
  598195
  599144
  600990
  601845
  607277
  608206
  614687
  621277
  623212
  632551
  641901
  746510
  771918
  791943
]

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 (425523, 434792, 436820, 441398, 442864, 442918, 446431, 446897, 446984, 447625, 447722, 448260, 449666, 449778, 452456, 452545, 457887, 462685, 463511, 488123, 500194, 508516, 508836, 511882, 512844, 514645, 524225, 525277, 526258, 527135, 527989, 528738, 528856, 540073, 543906, 551886, 552974, 555325, 555510, 559109, 559567, 560517, 560816, 564161, 564162, 565866, 566295, 567051, 568062, 568796, 577323, 577335, 577392, 578587, 581625, 582258, 582417, 598195, 599144, 600990, 601845, 607277, 608206, 614687, 621277, 623212, 632551, 641901, 746510, 771918, 791943);

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

[
  "best минет оральн секс пов"
]

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

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

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

[
  "best минет оральн секс пов"
]

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

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