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

[
  "dick little"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dick little' 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
  480439
  538281
  533512
  630297
  642751
  635220
  393481
  477554
  677108
  621410
  586190
  515203
  487721
  501338
  509969
  497951
  441645
  474748
  534229
  674962
  423205
  462208
  628282
  633446
  444660
  476753
  569967
  569520
  422633
  572333
  688581
  610404
  418941
  509997
  526906
  634482
  524931
  487435
  518131
  509345
  464887
  662137
  582376
  434369
  602519
  622666
  606002
  523492
  530690
  565256
  556037
  640813
  556327
  652263
  517665
  513736
  525154
  676020
  651938
  633449
  430444
  481803
  558127
  544686
  628126
  477773
  603875
  575197
  607256
  606762
  491823
  603810
]

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 (480439, 538281, 533512, 630297, 642751, 635220, 393481, 477554, 677108, 621410, 586190, 515203, 487721, 501338, 509969, 497951, 441645, 474748, 534229, 674962, 423205, 462208, 628282, 633446, 444660, 476753, 569967, 569520, 422633, 572333, 688581, 610404, 418941, 509997, 526906, 634482, 524931, 487435, 518131, 509345, 464887, 662137, 582376, 434369, 602519, 622666, 606002, 523492, 530690, 565256, 556037, 640813, 556327, 652263, 517665, 513736, 525154, 676020, 651938, 633449, 430444, 481803, 558127, 544686, 628126, 477773, 603875, 575197, 607256, 606762, 491823, 603810);

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
  393481
  418941
  422633
  423205
  430444
  434369
  441645
  444660
  462208
  464887
  474748
  476753
  477554
  477773
  480439
  481803
  487435
  487721
  491823
  497951
  501338
  509345
  509969
  509997
  513736
  515203
  517665
  518131
  523492
  524931
  525154
  526906
  530690
  533512
  534229
  538281
  544686
  556037
  556327
  558127
  565256
  569520
  569967
  572333
  575197
  582376
  586190
  602519
  603810
  603875
  606002
  606762
  607256
  610404
  621410
  622666
  628126
  628282
  630297
  633446
  633449
  634482
  635220
  640813
  642751
  651938
  652263
  662137
  674962
  676020
  677108
  688581
]

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 (393481, 418941, 422633, 423205, 430444, 434369, 441645, 444660, 462208, 464887, 474748, 476753, 477554, 477773, 480439, 481803, 487435, 487721, 491823, 497951, 501338, 509345, 509969, 509997, 513736, 515203, 517665, 518131, 523492, 524931, 525154, 526906, 530690, 533512, 534229, 538281, 544686, 556037, 556327, 558127, 565256, 569520, 569967, 572333, 575197, 582376, 586190, 602519, 603810, 603875, 606002, 606762, 607256, 610404, 621410, 622666, 628126, 628282, 630297, 633446, 633449, 634482, 635220, 640813, 642751, 651938, 652263, 662137, 674962, 676020, 677108, 688581);

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
  393481
  418941
  422633
  423205
  430444
  434369
  441645
  444660
  462208
  464887
  474748
  476753
  477554
  477773
  480439
  481803
  487435
  487721
  491823
  497951
  501338
  509345
  509969
  509997
  513736
  515203
  517665
  518131
  523492
  524931
  525154
  526906
  530690
  533512
  534229
  538281
  544686
  556037
  556327
  558127
  565256
  569520
  569967
  572333
  575197
  582376
  586190
  602519
  603810
  603875
  606002
  606762
  607256
  610404
  621410
  622666
  628126
  628282
  630297
  633446
  633449
  634482
  635220
  640813
  642751
  651938
  652263
  662137
  674962
  676020
  677108
  688581
]

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 (393481, 418941, 422633, 423205, 430444, 434369, 441645, 444660, 462208, 464887, 474748, 476753, 477554, 477773, 480439, 481803, 487435, 487721, 491823, 497951, 501338, 509345, 509969, 509997, 513736, 515203, 517665, 518131, 523492, 524931, 525154, 526906, 530690, 533512, 534229, 538281, 544686, 556037, 556327, 558127, 565256, 569520, 569967, 572333, 575197, 582376, 586190, 602519, 603810, 603875, 606002, 606762, 607256, 610404, 621410, 622666, 628126, 628282, 630297, 633446, 633449, 634482, 635220, 640813, 642751, 651938, 652263, 662137, 674962, 676020, 677108, 688581);

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

[
  "член little"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'член little';

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

[
  "член little"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'член little';