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

[
  "arab hijab muslim"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'arab hijab muslim' 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
  660851
  522432
  618751
  641094
  586499
  586498
  574989
  556932
  585106
  586513
  713258
  543196
  585108
  557424
  544704
  751354
  586508
  556935
  586520
  552051
  585109
  626354
  621534
  585111
  575000
  660573
  612245
  618749
  457392
  543204
  478985
  543431
  660800
  586519
  617116
  586534
  458580
  542345
  478986
  543453
  610743
  586516
  619816
  586528
  556941
  574960
  544700
  660834
  478987
  581089
  543779
  565929
  543191
  556945
  586497
  543236
  544683
  615400
  628631
  800084
  556951
  543435
  604419
  543451
  591870
  623642
  592372
  543777
  543461
  556867
  543186
  575009
  568050
  473218
  586518
  591438
]

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 (660851, 522432, 618751, 641094, 586499, 586498, 574989, 556932, 585106, 586513, 713258, 543196, 585108, 557424, 544704, 751354, 586508, 556935, 586520, 552051, 585109, 626354, 621534, 585111, 575000, 660573, 612245, 618749, 457392, 543204, 478985, 543431, 660800, 586519, 617116, 586534, 458580, 542345, 478986, 543453, 610743, 586516, 619816, 586528, 556941, 574960, 544700, 660834, 478987, 581089, 543779, 565929, 543191, 556945, 586497, 543236, 544683, 615400, 628631, 800084, 556951, 543435, 604419, 543451, 591870, 623642, 592372, 543777, 543461, 556867, 543186, 575009, 568050, 473218, 586518, 591438);

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
  457392
  458580
  473218
  478985
  478986
  478987
  522432
  542345
  543186
  543191
  543196
  543204
  543236
  543431
  543435
  543451
  543453
  543461
  543777
  543779
  544683
  544700
  544704
  552051
  556867
  556932
  556935
  556941
  556945
  556951
  557424
  565929
  568050
  574960
  574989
  575000
  575009
  581089
  585106
  585108
  585109
  585111
  586497
  586498
  586499
  586508
  586513
  586516
  586518
  586519
  586520
  586528
  586534
  591438
  591870
  592372
  604419
  610743
  612245
  615400
  617116
  618749
  618751
  619816
  621534
  623642
  626354
  628631
  641094
  660573
  660800
  660834
  660851
  713258
  751354
  800084
]

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 (457392, 458580, 473218, 478985, 478986, 478987, 522432, 542345, 543186, 543191, 543196, 543204, 543236, 543431, 543435, 543451, 543453, 543461, 543777, 543779, 544683, 544700, 544704, 552051, 556867, 556932, 556935, 556941, 556945, 556951, 557424, 565929, 568050, 574960, 574989, 575000, 575009, 581089, 585106, 585108, 585109, 585111, 586497, 586498, 586499, 586508, 586513, 586516, 586518, 586519, 586520, 586528, 586534, 591438, 591870, 592372, 604419, 610743, 612245, 615400, 617116, 618749, 618751, 619816, 621534, 623642, 626354, 628631, 641094, 660573, 660800, 660834, 660851, 713258, 751354, 800084);

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
  457392
  458580
  473218
  478985
  478986
  478987
  522432
  542345
  543186
  543191
  543196
  543204
  543236
  543431
  543435
  543451
  543453
  543461
  543777
  543779
  544683
  544700
  544704
  552051
  556867
  556932
  556935
  556941
  556945
  556951
  557424
  565929
  568050
  574960
  574989
  575000
  575009
  581089
  585106
  585108
  585109
  585111
  586497
  586498
  586499
  586508
  586513
  586516
  586518
  586519
  586520
  586528
  586534
  591438
  591870
  592372
  604419
  610743
  612245
  615400
  617116
  618749
  618751
  619816
  621534
  623642
  626354
  628631
  641094
  660573
  660800
  660834
  660851
  713258
  751354
  800084
]

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 (457392, 458580, 473218, 478985, 478986, 478987, 522432, 542345, 543186, 543191, 543196, 543204, 543236, 543431, 543435, 543451, 543453, 543461, 543777, 543779, 544683, 544700, 544704, 552051, 556867, 556932, 556935, 556941, 556945, 556951, 557424, 565929, 568050, 574960, 574989, 575000, 575009, 581089, 585106, 585108, 585109, 585111, 586497, 586498, 586499, 586508, 586513, 586516, 586518, 586519, 586520, 586528, 586534, 591438, 591870, 592372, 604419, 610743, 612245, 615400, 617116, 618749, 618751, 619816, 621534, 623642, 626354, 628631, 641094, 660573, 660800, 660834, 660851, 713258, 751354, 800084);

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

[
  "араб hijab muslim"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'араб hijab muslim';

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

[
  "араб hijab muslim"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'араб hijab muslim';