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

[
  "xxx public agent"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'xxx public agent' 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
  502065
  502110
  515945
  518771
  497653
  535418
  482992
  487488
  487500
  501273
  510082
  518786
  443655
  443640
  427949
  429256
  491680
  497654
  513545
  526548
  513544
  513541
  465783
  466671
  545690
  564445
  594970
  443645
  457129
  450648
  467735
  450657
  461006
  478905
  429263
  468959
  504589
  511299
  528887
  489187
  513556
  497952
  510078
  481485
  511295
  513271
  522197
  572824
  572839
  546864
  564112
  588305
  601895
  450861
  465777
  420232
  470339
  476430
  519676
  487133
  519657
  572825
  443587
  519665
  528716
  572840
  601900
  607388
  526361
  497661
  525683
  560147
  426654
  526546
  466791
]

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 (502065, 502110, 515945, 518771, 497653, 535418, 482992, 487488, 487500, 501273, 510082, 518786, 443655, 443640, 427949, 429256, 491680, 497654, 513545, 526548, 513544, 513541, 465783, 466671, 545690, 564445, 594970, 443645, 457129, 450648, 467735, 450657, 461006, 478905, 429263, 468959, 504589, 511299, 528887, 489187, 513556, 497952, 510078, 481485, 511295, 513271, 522197, 572824, 572839, 546864, 564112, 588305, 601895, 450861, 465777, 420232, 470339, 476430, 519676, 487133, 519657, 572825, 443587, 519665, 528716, 572840, 601900, 607388, 526361, 497661, 525683, 560147, 426654, 526546, 466791);

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
  420232
  426654
  427949
  429256
  429263
  443587
  443640
  443645
  443655
  450648
  450657
  450861
  457129
  461006
  465777
  465783
  466671
  466791
  467735
  468959
  470339
  476430
  478905
  481485
  482992
  487133
  487488
  487500
  489187
  491680
  497653
  497654
  497661
  497952
  501273
  502065
  502110
  504589
  510078
  510082
  511295
  511299
  513271
  513541
  513544
  513545
  513556
  515945
  518771
  518786
  519657
  519665
  519676
  522197
  525683
  526361
  526546
  526548
  528716
  528887
  535418
  545690
  546864
  560147
  564112
  564445
  572824
  572825
  572839
  572840
  588305
  594970
  601895
  601900
  607388
]

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 (420232, 426654, 427949, 429256, 429263, 443587, 443640, 443645, 443655, 450648, 450657, 450861, 457129, 461006, 465777, 465783, 466671, 466791, 467735, 468959, 470339, 476430, 478905, 481485, 482992, 487133, 487488, 487500, 489187, 491680, 497653, 497654, 497661, 497952, 501273, 502065, 502110, 504589, 510078, 510082, 511295, 511299, 513271, 513541, 513544, 513545, 513556, 515945, 518771, 518786, 519657, 519665, 519676, 522197, 525683, 526361, 526546, 526548, 528716, 528887, 535418, 545690, 546864, 560147, 564112, 564445, 572824, 572825, 572839, 572840, 588305, 594970, 601895, 601900, 607388);

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
  420232
  426654
  427949
  429256
  429263
  443587
  443640
  443645
  443655
  450648
  450657
  450861
  457129
  461006
  465777
  465783
  466671
  466791
  467735
  468959
  470339
  476430
  478905
  481485
  482992
  487133
  487488
  487500
  489187
  491680
  497653
  497654
  497661
  497952
  501273
  502065
  502110
  504589
  510078
  510082
  511295
  511299
  513271
  513541
  513544
  513545
  513556
  515945
  518771
  518786
  519657
  519665
  519676
  522197
  525683
  526361
  526546
  526548
  528716
  528887
  535418
  545690
  546864
  560147
  564112
  564445
  572824
  572825
  572839
  572840
  588305
  594970
  601895
  601900
  607388
]

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 (420232, 426654, 427949, 429256, 429263, 443587, 443640, 443645, 443655, 450648, 450657, 450861, 457129, 461006, 465777, 465783, 466671, 466791, 467735, 468959, 470339, 476430, 478905, 481485, 482992, 487133, 487488, 487500, 489187, 491680, 497653, 497654, 497661, 497952, 501273, 502065, 502110, 504589, 510078, 510082, 511295, 511299, 513271, 513541, 513544, 513545, 513556, 515945, 518771, 518786, 519657, 519665, 519676, 522197, 525683, 526361, 526546, 526548, 528716, 528887, 535418, 545690, 546864, 560147, 564112, 564445, 572824, 572825, 572839, 572840, 588305, 594970, 601895, 601900, 607388);

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

[
  "xxx publicagent"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'xxx publicagent';

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

[
  "xxx publicagent"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'xxx publicagent';