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

[
  b"ðÂðÁð¢Ðâ ð▓ ÐçðÁÐÇð¢ÐïÐà ÐéÐÇÐâÐüð©ð║ð░ÐÔǪ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD0B6D0B5D0BDD18320D0B220D187D0B5D180D0BDD18BD18520D182D180D183D181D0B8D0BAD0B0D1E280A6 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
  454399
  519131
  527201
  492138
  598213
  424274
  496053
  510007
  496850
  509642
  440682
  470919
  681382
  471611
  439763
  446592
  521133
  511711
  555200
  411689
  421809
  655904
  668382
  571792
  600822
  485551
  601213
  476249
  419956
  509590
  491669
  605569
  506436
  486339
  414135
  478952
  478528
  483057
  581571
  484455
  496597
  577584
  423934
  470768
  537377
  453336
  445943
  580113
  456663
  439609
  510522
  511991
  514125
  520393
  455368
  472785
  481630
  474073
  474279
  479059
  484568
  560664
  515601
  622805
  466119
  609784
  445201
  439715
  603810
  506796
  453683
  617175
  521141
  583099
  668140
  520759
  593596
]

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 (454399, 519131, 527201, 492138, 598213, 424274, 496053, 510007, 496850, 509642, 440682, 470919, 681382, 471611, 439763, 446592, 521133, 511711, 555200, 411689, 421809, 655904, 668382, 571792, 600822, 485551, 601213, 476249, 419956, 509590, 491669, 605569, 506436, 486339, 414135, 478952, 478528, 483057, 581571, 484455, 496597, 577584, 423934, 470768, 537377, 453336, 445943, 580113, 456663, 439609, 510522, 511991, 514125, 520393, 455368, 472785, 481630, 474073, 474279, 479059, 484568, 560664, 515601, 622805, 466119, 609784, 445201, 439715, 603810, 506796, 453683, 617175, 521141, 583099, 668140, 520759, 593596);

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
  411689
  414135
  419956
  421809
  423934
  424274
  439609
  439715
  439763
  440682
  445201
  445943
  446592
  453336
  453683
  454399
  455368
  456663
  466119
  470768
  470919
  471611
  472785
  474073
  474279
  476249
  478528
  478952
  479059
  481630
  483057
  484455
  484568
  485551
  486339
  491669
  492138
  496053
  496597
  496850
  506436
  506796
  509590
  509642
  510007
  510522
  511711
  511991
  514125
  515601
  519131
  520393
  520759
  521133
  521141
  537377
  555200
  560664
  571792
  577584
  580113
  581571
  583099
  593596
  598213
  600822
  601213
  603810
  605569
  609784
  617175
  622805
  655904
  668140
  668382
  681382
]

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 (411689, 414135, 419956, 421809, 423934, 424274, 439609, 439715, 439763, 440682, 445201, 445943, 446592, 453336, 453683, 454399, 455368, 456663, 466119, 470768, 470919, 471611, 472785, 474073, 474279, 476249, 478528, 478952, 479059, 481630, 483057, 484455, 484568, 485551, 486339, 491669, 492138, 496053, 496597, 496850, 506436, 506796, 509590, 509642, 510007, 510522, 511711, 511991, 514125, 515601, 519131, 520393, 520759, 521133, 521141, 537377, 555200, 560664, 571792, 577584, 580113, 581571, 583099, 593596, 598213, 600822, 601213, 603810, 605569, 609784, 617175, 622805, 655904, 668140, 668382, 681382);

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
  411689
  414135
  419956
  421809
  423934
  424274
  439609
  439715
  439763
  440682
  445201
  445943
  446592
  453336
  453683
  454399
  455368
  456663
  466119
  470768
  470919
  471611
  472785
  474073
  474279
  476249
  478528
  478952
  479059
  481630
  483057
  484455
  484568
  485551
  486339
  491669
  492138
  496053
  496597
  496850
  506436
  506796
  509590
  509642
  510007
  510522
  511711
  511991
  514125
  515601
  519131
  520393
  520759
  521133
  521141
  537377
  555200
  560664
  571792
  577584
  580113
  581571
  583099
  593596
  598213
  600822
  601213
  603810
  605569
  609784
  617175
  622805
  655904
  668140
  668382
  681382
]

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 (411689, 414135, 419956, 421809, 423934, 424274, 439609, 439715, 439763, 440682, 445201, 445943, 446592, 453336, 453683, 454399, 455368, 456663, 466119, 470768, 470919, 471611, 472785, 474073, 474279, 476249, 478528, 478952, 479059, 481630, 483057, 484455, 484568, 485551, 486339, 491669, 492138, 496053, 496597, 496850, 506436, 506796, 509590, 509642, 510007, 510522, 511711, 511991, 514125, 515601, 519131, 520393, 520759, 521133, 521141, 537377, 555200, 560664, 571792, 577584, 580113, 581571, 583099, 593596, 598213, 600822, 601213, 603810, 605569, 609784, 617175, 622805, 655904, 668140, 668382, 681382);

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` = 'жен в черные трусик нижн бел';