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

[
  "teen blowjob compilation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen blowjob compilation' 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
  552272
  541821
  541879
  592408
  569156
  401859
  574603
  568999
  466404
  541650
  665768
  550315
  453329
  486540
  632595
  632269
  531437
  538262
  517923
  536712
  471183
  477210
  541252
  443323
  523538
  448811
  455898
  650380
  695123
  646450
  632701
  604478
  629951
  541830
  602647
  695181
  456518
  628334
  656303
  601094
  446030
  656499
  427263
  565927
  563535
  477097
  469552
  542192
  632020
  468718
  422512
  425435
  420291
  666850
  744965
  481910
  536695
  541639
  530637
  436178
  541587
  632616
  635243
  568450
  495217
  729223
  556535
  410521
  461191
  541643
  403141
  586601
  489257
  642746
  573212
  508926
  410959
  489258
]

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 (552272, 541821, 541879, 592408, 569156, 401859, 574603, 568999, 466404, 541650, 665768, 550315, 453329, 486540, 632595, 632269, 531437, 538262, 517923, 536712, 471183, 477210, 541252, 443323, 523538, 448811, 455898, 650380, 695123, 646450, 632701, 604478, 629951, 541830, 602647, 695181, 456518, 628334, 656303, 601094, 446030, 656499, 427263, 565927, 563535, 477097, 469552, 542192, 632020, 468718, 422512, 425435, 420291, 666850, 744965, 481910, 536695, 541639, 530637, 436178, 541587, 632616, 635243, 568450, 495217, 729223, 556535, 410521, 461191, 541643, 403141, 586601, 489257, 642746, 573212, 508926, 410959, 489258);

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
  401859
  403141
  410521
  410959
  420291
  422512
  425435
  427263
  436178
  443323
  446030
  448811
  453329
  455898
  456518
  461191
  466404
  468718
  469552
  471183
  477097
  477210
  481910
  486540
  489257
  489258
  495217
  508926
  517923
  523538
  530637
  531437
  536695
  536712
  538262
  541252
  541587
  541639
  541643
  541650
  541821
  541830
  541879
  542192
  550315
  552272
  556535
  563535
  565927
  568450
  568999
  569156
  573212
  574603
  586601
  592408
  601094
  602647
  604478
  628334
  629951
  632020
  632269
  632595
  632616
  632701
  635243
  642746
  646450
  650380
  656303
  656499
  665768
  666850
  695123
  695181
  729223
  744965
]

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 (401859, 403141, 410521, 410959, 420291, 422512, 425435, 427263, 436178, 443323, 446030, 448811, 453329, 455898, 456518, 461191, 466404, 468718, 469552, 471183, 477097, 477210, 481910, 486540, 489257, 489258, 495217, 508926, 517923, 523538, 530637, 531437, 536695, 536712, 538262, 541252, 541587, 541639, 541643, 541650, 541821, 541830, 541879, 542192, 550315, 552272, 556535, 563535, 565927, 568450, 568999, 569156, 573212, 574603, 586601, 592408, 601094, 602647, 604478, 628334, 629951, 632020, 632269, 632595, 632616, 632701, 635243, 642746, 646450, 650380, 656303, 656499, 665768, 666850, 695123, 695181, 729223, 744965);

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
  401859
  403141
  410521
  410959
  420291
  422512
  425435
  427263
  436178
  443323
  446030
  448811
  453329
  455898
  456518
  461191
  466404
  468718
  469552
  471183
  477097
  477210
  481910
  486540
  489257
  489258
  495217
  508926
  517923
  523538
  530637
  531437
  536695
  536712
  538262
  541252
  541587
  541639
  541643
  541650
  541821
  541830
  541879
  542192
  550315
  552272
  556535
  563535
  565927
  568450
  568999
  569156
  573212
  574603
  586601
  592408
  601094
  602647
  604478
  628334
  629951
  632020
  632269
  632595
  632616
  632701
  635243
  642746
  646450
  650380
  656303
  656499
  665768
  666850
  695123
  695181
  729223
  744965
]

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 (401859, 403141, 410521, 410959, 420291, 422512, 425435, 427263, 436178, 443323, 446030, 448811, 453329, 455898, 456518, 461191, 466404, 468718, 469552, 471183, 477097, 477210, 481910, 486540, 489257, 489258, 495217, 508926, 517923, 523538, 530637, 531437, 536695, 536712, 538262, 541252, 541587, 541639, 541643, 541650, 541821, 541830, 541879, 542192, 550315, 552272, 556535, 563535, 565927, 568450, 568999, 569156, 573212, 574603, 586601, 592408, 601094, 602647, 604478, 628334, 629951, 632020, 632269, 632595, 632616, 632701, 635243, 642746, 646450, 650380, 656303, 656499, 665768, 666850, 695123, 695181, 729223, 744965);

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

[
  "teen минет оральн секс подборк"
]

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

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

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

[
  "teen минет оральн секс подборк"
]

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

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