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

[
  "русский свингеры жена…"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русский свингеры жена…' 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
  542971
  577966
  551577
  590543
  419550
  457783
  462700
  472328
  466094
  483388
  484665
  522221
  484419
  516090
  495741
  510742
  513607
  526948
  544528
  499028
  590628
  464327
  421907
  484463
  437811
  429857
  554568
  730798
  421871
  476797
  470939
  421839
  466090
  485703
  548751
  476251
  473586
  473596
  504183
  615703
  446659
  628426
  614273
  622832
  485928
  460733
  559712
  583723
  620674
  751565
  420635
  441004
  506047
  607026
  582811
  600973
  476022
  516875
  514815
  544249
  523608
  473923
  583500
  603923
  473598
  514645
  518012
  518521
  586575
  603933
  622351
  439819
  470605
  470487
  562358
  513604
  625322
  625001
  521832
]

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 (542971, 577966, 551577, 590543, 419550, 457783, 462700, 472328, 466094, 483388, 484665, 522221, 484419, 516090, 495741, 510742, 513607, 526948, 544528, 499028, 590628, 464327, 421907, 484463, 437811, 429857, 554568, 730798, 421871, 476797, 470939, 421839, 466090, 485703, 548751, 476251, 473586, 473596, 504183, 615703, 446659, 628426, 614273, 622832, 485928, 460733, 559712, 583723, 620674, 751565, 420635, 441004, 506047, 607026, 582811, 600973, 476022, 516875, 514815, 544249, 523608, 473923, 583500, 603923, 473598, 514645, 518012, 518521, 586575, 603933, 622351, 439819, 470605, 470487, 562358, 513604, 625322, 625001, 521832);

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
  419550
  420635
  421839
  421871
  421907
  429857
  437811
  439819
  441004
  446659
  457783
  460733
  462700
  464327
  466090
  466094
  470487
  470605
  470939
  472328
  473586
  473596
  473598
  473923
  476022
  476251
  476797
  483388
  484419
  484463
  484665
  485703
  485928
  495741
  499028
  504183
  506047
  510742
  513604
  513607
  514645
  514815
  516090
  516875
  518012
  518521
  521832
  522221
  523608
  526948
  542971
  544249
  544528
  548751
  551577
  554568
  559712
  562358
  577966
  582811
  583500
  583723
  586575
  590543
  590628
  600973
  603923
  603933
  607026
  614273
  615703
  620674
  622351
  622832
  625001
  625322
  628426
  730798
  751565
]

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 (419550, 420635, 421839, 421871, 421907, 429857, 437811, 439819, 441004, 446659, 457783, 460733, 462700, 464327, 466090, 466094, 470487, 470605, 470939, 472328, 473586, 473596, 473598, 473923, 476022, 476251, 476797, 483388, 484419, 484463, 484665, 485703, 485928, 495741, 499028, 504183, 506047, 510742, 513604, 513607, 514645, 514815, 516090, 516875, 518012, 518521, 521832, 522221, 523608, 526948, 542971, 544249, 544528, 548751, 551577, 554568, 559712, 562358, 577966, 582811, 583500, 583723, 586575, 590543, 590628, 600973, 603923, 603933, 607026, 614273, 615703, 620674, 622351, 622832, 625001, 625322, 628426, 730798, 751565);

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
  419550
  420635
  421839
  421871
  421907
  429857
  437811
  439819
  441004
  446659
  457783
  460733
  462700
  464327
  466090
  466094
  470487
  470605
  470939
  472328
  473586
  473596
  473598
  473923
  476022
  476251
  476797
  483388
  484419
  484463
  484665
  485703
  485928
  495741
  499028
  504183
  506047
  510742
  513604
  513607
  514645
  514815
  516090
  516875
  518012
  518521
  521832
  522221
  523608
  526948
  542971
  544249
  544528
  548751
  551577
  554568
  559712
  562358
  577966
  582811
  583500
  583723
  586575
  590543
  590628
  600973
  603923
  603933
  607026
  614273
  615703
  620674
  622351
  622832
  625001
  625322
  628426
  730798
  751565
]

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 (419550, 420635, 421839, 421871, 421907, 429857, 437811, 439819, 441004, 446659, 457783, 460733, 462700, 464327, 466090, 466094, 470487, 470605, 470939, 472328, 473586, 473596, 473598, 473923, 476022, 476251, 476797, 483388, 484419, 484463, 484665, 485703, 485928, 495741, 499028, 504183, 506047, 510742, 513604, 513607, 514645, 514815, 516090, 516875, 518012, 518521, 521832, 522221, 523608, 526948, 542971, 544249, 544528, 548751, 551577, 554568, 559712, 562358, 577966, 582811, 583500, 583723, 586575, 590543, 590628, 600973, 603923, 603933, 607026, 614273, 615703, 620674, 622351, 622832, 625001, 625322, 628426, 730798, 751565);

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

[
  "русск свингер жен"
]

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

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

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

[
  "русск свингер жен"
]

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

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