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

[
  "part 1"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'part 1' 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
  456981
  462537
  452617
  414337
  427083
  500369
  527074
  500366
  494285
  516711
  531204
  563093
  648254
  604939
  623622
  639712
  446457
  452311
  519908
  584636
  425829
  453529
  517563
  518497
  532667
  526443
  587167
  629963
  623818
  591141
  491021
  532662
  623616
  622241
  497917
  456680
  512384
  545015
  615654
  613221
  441024
  523780
  591139
  623468
  520759
  712067
  766670
  788183
  606873
  801950
  740150
  526364
  513897
  603648
  794273
  684213
  749544
  755176
  386626
  524940
  528764
  759700
  483010
  518966
  528767
  551971
  518624
  578146
  629330
  448108
  513043
  478807
  470546
  562973
  514062
]

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 (456981, 462537, 452617, 414337, 427083, 500369, 527074, 500366, 494285, 516711, 531204, 563093, 648254, 604939, 623622, 639712, 446457, 452311, 519908, 584636, 425829, 453529, 517563, 518497, 532667, 526443, 587167, 629963, 623818, 591141, 491021, 532662, 623616, 622241, 497917, 456680, 512384, 545015, 615654, 613221, 441024, 523780, 591139, 623468, 520759, 712067, 766670, 788183, 606873, 801950, 740150, 526364, 513897, 603648, 794273, 684213, 749544, 755176, 386626, 524940, 528764, 759700, 483010, 518966, 528767, 551971, 518624, 578146, 629330, 448108, 513043, 478807, 470546, 562973, 514062);

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
  386626
  414337
  425829
  427083
  441024
  446457
  448108
  452311
  452617
  453529
  456680
  456981
  462537
  470546
  478807
  483010
  491021
  494285
  497917
  500366
  500369
  512384
  513043
  513897
  514062
  516711
  517563
  518497
  518624
  518966
  519908
  520759
  523780
  524940
  526364
  526443
  527074
  528764
  528767
  531204
  532662
  532667
  545015
  551971
  562973
  563093
  578146
  584636
  587167
  591139
  591141
  603648
  604939
  606873
  613221
  615654
  622241
  623468
  623616
  623622
  623818
  629330
  629963
  639712
  648254
  684213
  712067
  740150
  749544
  755176
  759700
  766670
  788183
  794273
  801950
]

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 (386626, 414337, 425829, 427083, 441024, 446457, 448108, 452311, 452617, 453529, 456680, 456981, 462537, 470546, 478807, 483010, 491021, 494285, 497917, 500366, 500369, 512384, 513043, 513897, 514062, 516711, 517563, 518497, 518624, 518966, 519908, 520759, 523780, 524940, 526364, 526443, 527074, 528764, 528767, 531204, 532662, 532667, 545015, 551971, 562973, 563093, 578146, 584636, 587167, 591139, 591141, 603648, 604939, 606873, 613221, 615654, 622241, 623468, 623616, 623622, 623818, 629330, 629963, 639712, 648254, 684213, 712067, 740150, 749544, 755176, 759700, 766670, 788183, 794273, 801950);

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
  386626
  414337
  425829
  427083
  441024
  446457
  448108
  452311
  452617
  453529
  456680
  456981
  462537
  470546
  478807
  483010
  491021
  494285
  497917
  500366
  500369
  512384
  513043
  513897
  514062
  516711
  517563
  518497
  518624
  518966
  519908
  520759
  523780
  524940
  526364
  526443
  527074
  528764
  528767
  531204
  532662
  532667
  545015
  551971
  562973
  563093
  578146
  584636
  587167
  591139
  591141
  603648
  604939
  606873
  613221
  615654
  622241
  623468
  623616
  623622
  623818
  629330
  629963
  639712
  648254
  684213
  712067
  740150
  749544
  755176
  759700
  766670
  788183
  794273
  801950
]

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 (386626, 414337, 425829, 427083, 441024, 446457, 448108, 452311, 452617, 453529, 456680, 456981, 462537, 470546, 478807, 483010, 491021, 494285, 497917, 500366, 500369, 512384, 513043, 513897, 514062, 516711, 517563, 518497, 518624, 518966, 519908, 520759, 523780, 524940, 526364, 526443, 527074, 528764, 528767, 531204, 532662, 532667, 545015, 551971, 562973, 563093, 578146, 584636, 587167, 591139, 591141, 603648, 604939, 606873, 613221, 615654, 622241, 623468, 623616, 623622, 623818, 629330, 629963, 639712, 648254, 684213, 712067, 740150, 749544, 755176, 759700, 766670, 788183, 794273, 801950);

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

[
  "part 1"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'part 1';

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

[
  "part 1"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'part 1';