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

[
  "homemade phone"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'homemade phone' 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
  484995
  517060
  493851
  520596
  481908
  464999
  496565
  520213
  504756
  552880
  561560
  602578
  436098
  452399
  458026
  512738
  525258
  493132
  505084
  510704
  485250
  510518
  663297
  609464
  603055
  609181
  510697
  532102
  525022
  559008
  542531
  565631
  521408
  525706
  501603
  507740
  518798
  527355
  462078
  500175
  573357
  564246
  572913
  481407
  448457
  503085
  653101
  604046
  521507
  566230
  539764
  573455
  552550
  590579
  451751
  516823
  549682
  512055
  591595
  564244
  447208
  475473
  622686
  663264
  591198
  605552
  599368
  636154
  599483
  486871
  618334
  668140
  588991
  620009
  602912
]

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 (484995, 517060, 493851, 520596, 481908, 464999, 496565, 520213, 504756, 552880, 561560, 602578, 436098, 452399, 458026, 512738, 525258, 493132, 505084, 510704, 485250, 510518, 663297, 609464, 603055, 609181, 510697, 532102, 525022, 559008, 542531, 565631, 521408, 525706, 501603, 507740, 518798, 527355, 462078, 500175, 573357, 564246, 572913, 481407, 448457, 503085, 653101, 604046, 521507, 566230, 539764, 573455, 552550, 590579, 451751, 516823, 549682, 512055, 591595, 564244, 447208, 475473, 622686, 663264, 591198, 605552, 599368, 636154, 599483, 486871, 618334, 668140, 588991, 620009, 602912);

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
  436098
  447208
  448457
  451751
  452399
  458026
  462078
  464999
  475473
  481407
  481908
  484995
  485250
  486871
  493132
  493851
  496565
  500175
  501603
  503085
  504756
  505084
  507740
  510518
  510697
  510704
  512055
  512738
  516823
  517060
  518798
  520213
  520596
  521408
  521507
  525022
  525258
  525706
  527355
  532102
  539764
  542531
  549682
  552550
  552880
  559008
  561560
  564244
  564246
  565631
  566230
  572913
  573357
  573455
  588991
  590579
  591198
  591595
  599368
  599483
  602578
  602912
  603055
  604046
  605552
  609181
  609464
  618334
  620009
  622686
  636154
  653101
  663264
  663297
  668140
]

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 (436098, 447208, 448457, 451751, 452399, 458026, 462078, 464999, 475473, 481407, 481908, 484995, 485250, 486871, 493132, 493851, 496565, 500175, 501603, 503085, 504756, 505084, 507740, 510518, 510697, 510704, 512055, 512738, 516823, 517060, 518798, 520213, 520596, 521408, 521507, 525022, 525258, 525706, 527355, 532102, 539764, 542531, 549682, 552550, 552880, 559008, 561560, 564244, 564246, 565631, 566230, 572913, 573357, 573455, 588991, 590579, 591198, 591595, 599368, 599483, 602578, 602912, 603055, 604046, 605552, 609181, 609464, 618334, 620009, 622686, 636154, 653101, 663264, 663297, 668140);

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
  436098
  447208
  448457
  451751
  452399
  458026
  462078
  464999
  475473
  481407
  481908
  484995
  485250
  486871
  493132
  493851
  496565
  500175
  501603
  503085
  504756
  505084
  507740
  510518
  510697
  510704
  512055
  512738
  516823
  517060
  518798
  520213
  520596
  521408
  521507
  525022
  525258
  525706
  527355
  532102
  539764
  542531
  549682
  552550
  552880
  559008
  561560
  564244
  564246
  565631
  566230
  572913
  573357
  573455
  588991
  590579
  591198
  591595
  599368
  599483
  602578
  602912
  603055
  604046
  605552
  609181
  609464
  618334
  620009
  622686
  636154
  653101
  663264
  663297
  668140
]

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 (436098, 447208, 448457, 451751, 452399, 458026, 462078, 464999, 475473, 481407, 481908, 484995, 485250, 486871, 493132, 493851, 496565, 500175, 501603, 503085, 504756, 505084, 507740, 510518, 510697, 510704, 512055, 512738, 516823, 517060, 518798, 520213, 520596, 521408, 521507, 525022, 525258, 525706, 527355, 532102, 539764, 542531, 549682, 552550, 552880, 559008, 561560, 564244, 564246, 565631, 566230, 572913, 573357, 573455, 588991, 590579, 591198, 591595, 599368, 599483, 602578, 602912, 603055, 604046, 605552, 609181, 609464, 618334, 620009, 622686, 636154, 653101, 663264, 663297, 668140);

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

[
  "домашн любительск phone"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'домашн любительск phone';

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

[
  "домашн любительск phone"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'домашн любительск phone';