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
  613396
  565322
  546347
  554790
  555054
  576723
  654399
  655410
  656782
  657361
  653249
  657402
  659216
  652907
  659564
  568072
  569065
  573557
  600531
  619318
  590670
  594400
  597791
  618717
  622932
  586431
  598770
  601851
  613819
  618941
  624776
  614920
  405804
  464062
  465248
  469476
  521576
  512885
  514577
  536802
  519285
  526248
  530232
  535338
  539417
  564009
  654740
  653238
  654474
  563441
  599468
  603813
  606015
  609842
  591706
  625983
  605996
  612348
  599703
  622832
  623468
  625701
  629445
  474289
  504718
  502741
  533534
  520672
  567416
  591647
  589127
  609196
  614745
  616024
  507421
  598215
]

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 (613396, 565322, 546347, 554790, 555054, 576723, 654399, 655410, 656782, 657361, 653249, 657402, 659216, 652907, 659564, 568072, 569065, 573557, 600531, 619318, 590670, 594400, 597791, 618717, 622932, 586431, 598770, 601851, 613819, 618941, 624776, 614920, 405804, 464062, 465248, 469476, 521576, 512885, 514577, 536802, 519285, 526248, 530232, 535338, 539417, 564009, 654740, 653238, 654474, 563441, 599468, 603813, 606015, 609842, 591706, 625983, 605996, 612348, 599703, 622832, 623468, 625701, 629445, 474289, 504718, 502741, 533534, 520672, 567416, 591647, 589127, 609196, 614745, 616024, 507421, 598215);

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
  405804
  464062
  465248
  469476
  474289
  502741
  504718
  507421
  512885
  514577
  519285
  520672
  521576
  526248
  530232
  533534
  535338
  536802
  539417
  546347
  554790
  555054
  563441
  564009
  565322
  567416
  568072
  569065
  573557
  576723
  586431
  589127
  590670
  591647
  591706
  594400
  597791
  598215
  598770
  599468
  599703
  600531
  601851
  603813
  605996
  606015
  609196
  609842
  612348
  613396
  613819
  614745
  614920
  616024
  618717
  618941
  619318
  622832
  622932
  623468
  624776
  625701
  625983
  629445
  652907
  653238
  653249
  654399
  654474
  654740
  655410
  656782
  657361
  657402
  659216
  659564
]

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 (405804, 464062, 465248, 469476, 474289, 502741, 504718, 507421, 512885, 514577, 519285, 520672, 521576, 526248, 530232, 533534, 535338, 536802, 539417, 546347, 554790, 555054, 563441, 564009, 565322, 567416, 568072, 569065, 573557, 576723, 586431, 589127, 590670, 591647, 591706, 594400, 597791, 598215, 598770, 599468, 599703, 600531, 601851, 603813, 605996, 606015, 609196, 609842, 612348, 613396, 613819, 614745, 614920, 616024, 618717, 618941, 619318, 622832, 622932, 623468, 624776, 625701, 625983, 629445, 652907, 653238, 653249, 654399, 654474, 654740, 655410, 656782, 657361, 657402, 659216, 659564);

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
  405804
  464062
  465248
  469476
  474289
  502741
  504718
  507421
  512885
  514577
  519285
  520672
  521576
  526248
  530232
  533534
  535338
  536802
  539417
  546347
  554790
  555054
  563441
  564009
  565322
  567416
  568072
  569065
  573557
  576723
  586431
  589127
  590670
  591647
  591706
  594400
  597791
  598215
  598770
  599468
  599703
  600531
  601851
  603813
  605996
  606015
  609196
  609842
  612348
  613396
  613819
  614745
  614920
  616024
  618717
  618941
  619318
  622832
  622932
  623468
  624776
  625701
  625983
  629445
  652907
  653238
  653249
  654399
  654474
  654740
  655410
  656782
  657361
  657402
  659216
  659564
]

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 (405804, 464062, 465248, 469476, 474289, 502741, 504718, 507421, 512885, 514577, 519285, 520672, 521576, 526248, 530232, 533534, 535338, 536802, 539417, 546347, 554790, 555054, 563441, 564009, 565322, 567416, 568072, 569065, 573557, 576723, 586431, 589127, 590670, 591647, 591706, 594400, 597791, 598215, 598770, 599468, 599703, 600531, 601851, 603813, 605996, 606015, 609196, 609842, 612348, 613396, 613819, 614745, 614920, 616024, 618717, 618941, 619318, 622832, 622932, 623468, 624776, 625701, 625983, 629445, 652907, 653238, 653249, 654399, 654474, 654740, 655410, 656782, 657361, 657402, 659216, 659564);

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` = 'быстр рак';