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

[
  "beauty sister"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty sister' 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
  516786
  521664
  493242
  508567
  525259
  496764
  512659
  522121
  523065
  650806
  602981
  420760
  522663
  563553
  616747
  455006
  463614
  414979
  524855
  489281
  492455
  517233
  519528
  565138
  580298
  561346
  580135
  609861
  601879
  437815
  516087
  497951
  514311
  531920
  479629
  571333
  579732
  613924
  623074
  588992
  615765
  428480
  520310
  484694
  597240
  608200
  608737
  621454
  599803
  618717
  628277
  636154
  587933
  599326
  601886
  610574
  619107
  618743
  516890
  524490
  525525
  528116
  429084
  557236
  545667
  565399
  595369
  615429
  613204
  620493
  621735
  602991
  519249
  521815
]

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 (516786, 521664, 493242, 508567, 525259, 496764, 512659, 522121, 523065, 650806, 602981, 420760, 522663, 563553, 616747, 455006, 463614, 414979, 524855, 489281, 492455, 517233, 519528, 565138, 580298, 561346, 580135, 609861, 601879, 437815, 516087, 497951, 514311, 531920, 479629, 571333, 579732, 613924, 623074, 588992, 615765, 428480, 520310, 484694, 597240, 608200, 608737, 621454, 599803, 618717, 628277, 636154, 587933, 599326, 601886, 610574, 619107, 618743, 516890, 524490, 525525, 528116, 429084, 557236, 545667, 565399, 595369, 615429, 613204, 620493, 621735, 602991, 519249, 521815);

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
  414979
  420760
  428480
  429084
  437815
  455006
  463614
  479629
  484694
  489281
  492455
  493242
  496764
  497951
  508567
  512659
  514311
  516087
  516786
  516890
  517233
  519249
  519528
  520310
  521664
  521815
  522121
  522663
  523065
  524490
  524855
  525259
  525525
  528116
  531920
  545667
  557236
  561346
  563553
  565138
  565399
  571333
  579732
  580135
  580298
  587933
  588992
  595369
  597240
  599326
  599803
  601879
  601886
  602981
  602991
  608200
  608737
  609861
  610574
  613204
  613924
  615429
  615765
  616747
  618717
  618743
  619107
  620493
  621454
  621735
  623074
  628277
  636154
  650806
]

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 (414979, 420760, 428480, 429084, 437815, 455006, 463614, 479629, 484694, 489281, 492455, 493242, 496764, 497951, 508567, 512659, 514311, 516087, 516786, 516890, 517233, 519249, 519528, 520310, 521664, 521815, 522121, 522663, 523065, 524490, 524855, 525259, 525525, 528116, 531920, 545667, 557236, 561346, 563553, 565138, 565399, 571333, 579732, 580135, 580298, 587933, 588992, 595369, 597240, 599326, 599803, 601879, 601886, 602981, 602991, 608200, 608737, 609861, 610574, 613204, 613924, 615429, 615765, 616747, 618717, 618743, 619107, 620493, 621454, 621735, 623074, 628277, 636154, 650806);

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
  414979
  420760
  428480
  429084
  437815
  455006
  463614
  479629
  484694
  489281
  492455
  493242
  496764
  497951
  508567
  512659
  514311
  516087
  516786
  516890
  517233
  519249
  519528
  520310
  521664
  521815
  522121
  522663
  523065
  524490
  524855
  525259
  525525
  528116
  531920
  545667
  557236
  561346
  563553
  565138
  565399
  571333
  579732
  580135
  580298
  587933
  588992
  595369
  597240
  599326
  599803
  601879
  601886
  602981
  602991
  608200
  608737
  609861
  610574
  613204
  613924
  615429
  615765
  616747
  618717
  618743
  619107
  620493
  621454
  621735
  623074
  628277
  636154
  650806
]

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 (414979, 420760, 428480, 429084, 437815, 455006, 463614, 479629, 484694, 489281, 492455, 493242, 496764, 497951, 508567, 512659, 514311, 516087, 516786, 516890, 517233, 519249, 519528, 520310, 521664, 521815, 522121, 522663, 523065, 524490, 524855, 525259, 525525, 528116, 531920, 545667, 557236, 561346, 563553, 565138, 565399, 571333, 579732, 580135, 580298, 587933, 588992, 595369, 597240, 599326, 599803, 601879, 601886, 602981, 602991, 608200, 608737, 609861, 610574, 613204, 613924, 615429, 615765, 616747, 618717, 618743, 619107, 620493, 621454, 621735, 623074, 628277, 636154, 650806);

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

[
  "beauty sister"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'beauty sister';

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

[
  "beauty sister"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty sister';