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

[
  "stockings student"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'stockings student' 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
  580702
  549083
  482505
  467484
  491319
  489396
  549692
  645920
  650303
  598228
  756506
  627095
  633421
  280073
  475189
  461006
  469014
  517953
  502929
  520424
  571784
  557118
  574696
  662378
  465524
  522616
  458728
  467504
  467551
  559532
  570899
  555141
  590545
  591069
  749693
  785572
  450861
  465823
  508003
  487138
  495252
  486111
  511528
  511534
  567685
  569930
  618787
  473180
  444165
  518617
  520011
  519665
  603765
  535022
  482536
  551243
  556009
  602747
  447718
  478978
  467476
  620086
  623365
  601462
  486963
  518430
  625884
  563472
  569421
  478981
  470087
  560794
  467519
  439656
]

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 (580702, 549083, 482505, 467484, 491319, 489396, 549692, 645920, 650303, 598228, 756506, 627095, 633421, 280073, 475189, 461006, 469014, 517953, 502929, 520424, 571784, 557118, 574696, 662378, 465524, 522616, 458728, 467504, 467551, 559532, 570899, 555141, 590545, 591069, 749693, 785572, 450861, 465823, 508003, 487138, 495252, 486111, 511528, 511534, 567685, 569930, 618787, 473180, 444165, 518617, 520011, 519665, 603765, 535022, 482536, 551243, 556009, 602747, 447718, 478978, 467476, 620086, 623365, 601462, 486963, 518430, 625884, 563472, 569421, 478981, 470087, 560794, 467519, 439656);

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
  280073
  439656
  444165
  447718
  450861
  458728
  461006
  465524
  465823
  467476
  467484
  467504
  467519
  467551
  469014
  470087
  473180
  475189
  478978
  478981
  482505
  482536
  486111
  486963
  487138
  489396
  491319
  495252
  502929
  508003
  511528
  511534
  517953
  518430
  518617
  519665
  520011
  520424
  522616
  535022
  549083
  549692
  551243
  555141
  556009
  557118
  559532
  560794
  563472
  567685
  569421
  569930
  570899
  571784
  574696
  580702
  590545
  591069
  598228
  601462
  602747
  603765
  618787
  620086
  623365
  625884
  627095
  633421
  645920
  650303
  662378
  749693
  756506
  785572
]

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 (280073, 439656, 444165, 447718, 450861, 458728, 461006, 465524, 465823, 467476, 467484, 467504, 467519, 467551, 469014, 470087, 473180, 475189, 478978, 478981, 482505, 482536, 486111, 486963, 487138, 489396, 491319, 495252, 502929, 508003, 511528, 511534, 517953, 518430, 518617, 519665, 520011, 520424, 522616, 535022, 549083, 549692, 551243, 555141, 556009, 557118, 559532, 560794, 563472, 567685, 569421, 569930, 570899, 571784, 574696, 580702, 590545, 591069, 598228, 601462, 602747, 603765, 618787, 620086, 623365, 625884, 627095, 633421, 645920, 650303, 662378, 749693, 756506, 785572);

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
  280073
  439656
  444165
  447718
  450861
  458728
  461006
  465524
  465823
  467476
  467484
  467504
  467519
  467551
  469014
  470087
  473180
  475189
  478978
  478981
  482505
  482536
  486111
  486963
  487138
  489396
  491319
  495252
  502929
  508003
  511528
  511534
  517953
  518430
  518617
  519665
  520011
  520424
  522616
  535022
  549083
  549692
  551243
  555141
  556009
  557118
  559532
  560794
  563472
  567685
  569421
  569930
  570899
  571784
  574696
  580702
  590545
  591069
  598228
  601462
  602747
  603765
  618787
  620086
  623365
  625884
  627095
  633421
  645920
  650303
  662378
  749693
  756506
  785572
]

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 (280073, 439656, 444165, 447718, 450861, 458728, 461006, 465524, 465823, 467476, 467484, 467504, 467519, 467551, 469014, 470087, 473180, 475189, 478978, 478981, 482505, 482536, 486111, 486963, 487138, 489396, 491319, 495252, 502929, 508003, 511528, 511534, 517953, 518430, 518617, 519665, 520011, 520424, 522616, 535022, 549083, 549692, 551243, 555141, 556009, 557118, 559532, 560794, 563472, 567685, 569421, 569930, 570899, 571784, 574696, 580702, 590545, 591069, 598228, 601462, 602747, 603765, 618787, 620086, 623365, 625884, 627095, 633421, 645920, 650303, 662378, 749693, 756506, 785572);

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

[
  "чулк нижн бел student"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'чулк нижн бел student';

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

[
  "чулк нижн бел student"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'чулк нижн бел student';