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

[
  "riding oil"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding oil' 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
  498226
  389304
  485813
  415966
  410682
  416529
  457132
  467939
  521091
  500341
  509805
  537485
  467019
  559073
  660410
  674663
  599188
  603001
  604865
  641370
  620663
  752700
  469823
  426283
  441099
  443089
  490870
  508277
  518493
  485285
  416384
  385007
  399263
  437818
  446692
  449021
  522670
  517847
  545376
  680428
  593860
  623817
  603549
  624742
  619102
  433189
  454931
  517844
  623834
  434242
  445409
  510198
  565168
  704205
  596571
  381994
  389703
  389356
  482478
  550285
  548489
  562124
  777045
  808984
  396784
  528723
  583507
  422044
  519198
  552623
  416635
  430635
  494066
  185044
  432317
  528929
  552706
  509811
]

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 (498226, 389304, 485813, 415966, 410682, 416529, 457132, 467939, 521091, 500341, 509805, 537485, 467019, 559073, 660410, 674663, 599188, 603001, 604865, 641370, 620663, 752700, 469823, 426283, 441099, 443089, 490870, 508277, 518493, 485285, 416384, 385007, 399263, 437818, 446692, 449021, 522670, 517847, 545376, 680428, 593860, 623817, 603549, 624742, 619102, 433189, 454931, 517844, 623834, 434242, 445409, 510198, 565168, 704205, 596571, 381994, 389703, 389356, 482478, 550285, 548489, 562124, 777045, 808984, 396784, 528723, 583507, 422044, 519198, 552623, 416635, 430635, 494066, 185044, 432317, 528929, 552706, 509811);

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
  185044
  381994
  385007
  389304
  389356
  389703
  396784
  399263
  410682
  415966
  416384
  416529
  416635
  422044
  426283
  430635
  432317
  433189
  434242
  437818
  441099
  443089
  445409
  446692
  449021
  454931
  457132
  467019
  467939
  469823
  482478
  485285
  485813
  490870
  494066
  498226
  500341
  508277
  509805
  509811
  510198
  517844
  517847
  518493
  519198
  521091
  522670
  528723
  528929
  537485
  545376
  548489
  550285
  552623
  552706
  559073
  562124
  565168
  583507
  593860
  596571
  599188
  603001
  603549
  604865
  619102
  620663
  623817
  623834
  624742
  641370
  660410
  674663
  680428
  704205
  752700
  777045
  808984
]

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 (185044, 381994, 385007, 389304, 389356, 389703, 396784, 399263, 410682, 415966, 416384, 416529, 416635, 422044, 426283, 430635, 432317, 433189, 434242, 437818, 441099, 443089, 445409, 446692, 449021, 454931, 457132, 467019, 467939, 469823, 482478, 485285, 485813, 490870, 494066, 498226, 500341, 508277, 509805, 509811, 510198, 517844, 517847, 518493, 519198, 521091, 522670, 528723, 528929, 537485, 545376, 548489, 550285, 552623, 552706, 559073, 562124, 565168, 583507, 593860, 596571, 599188, 603001, 603549, 604865, 619102, 620663, 623817, 623834, 624742, 641370, 660410, 674663, 680428, 704205, 752700, 777045, 808984);

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
  185044
  381994
  385007
  389304
  389356
  389703
  396784
  399263
  410682
  415966
  416384
  416529
  416635
  422044
  426283
  430635
  432317
  433189
  434242
  437818
  441099
  443089
  445409
  446692
  449021
  454931
  457132
  467019
  467939
  469823
  482478
  485285
  485813
  490870
  494066
  498226
  500341
  508277
  509805
  509811
  510198
  517844
  517847
  518493
  519198
  521091
  522670
  528723
  528929
  537485
  545376
  548489
  550285
  552623
  552706
  559073
  562124
  565168
  583507
  593860
  596571
  599188
  603001
  603549
  604865
  619102
  620663
  623817
  623834
  624742
  641370
  660410
  674663
  680428
  704205
  752700
  777045
  808984
]

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 (185044, 381994, 385007, 389304, 389356, 389703, 396784, 399263, 410682, 415966, 416384, 416529, 416635, 422044, 426283, 430635, 432317, 433189, 434242, 437818, 441099, 443089, 445409, 446692, 449021, 454931, 457132, 467019, 467939, 469823, 482478, 485285, 485813, 490870, 494066, 498226, 500341, 508277, 509805, 509811, 510198, 517844, 517847, 518493, 519198, 521091, 522670, 528723, 528929, 537485, 545376, 548489, 550285, 552623, 552706, 559073, 562124, 565168, 583507, 593860, 596571, 599188, 603001, 603549, 604865, 619102, 620663, 623817, 623834, 624742, 641370, 660410, 674663, 680428, 704205, 752700, 777045, 808984);

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

[
  "riding масл"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'riding масл';

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

[
  "riding масл"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding масл';