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

[
  "put the hair"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'put the hair' 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
  475144
  524533
  563809
  569654
  584669
  576604
  583550
  588288
  609915
  621354
  603951
  796079
  810902
  811090
  813191
  446828
  447741
  456571
  499588
  516789
  513621
  522272
  500110
  515824
  438836
  464391
  522926
  540626
  559620
  546680
  595950
  604046
  585400
  588724
  478565
  465552
  439754
  446657
  515811
  528264
  512843
  491751
  492229
  496900
  522121
  504759
  536903
  536657
  559927
  664632
  567756
  433888
  501226
  520793
  506990
  484227
  498817
  562363
  569835
  619709
  623933
  469335
  476223
  524897
  565105
  587875
  610628
  603994
  659216
  602010
  608692
  544123
  620757
  484017
]

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 (475144, 524533, 563809, 569654, 584669, 576604, 583550, 588288, 609915, 621354, 603951, 796079, 810902, 811090, 813191, 446828, 447741, 456571, 499588, 516789, 513621, 522272, 500110, 515824, 438836, 464391, 522926, 540626, 559620, 546680, 595950, 604046, 585400, 588724, 478565, 465552, 439754, 446657, 515811, 528264, 512843, 491751, 492229, 496900, 522121, 504759, 536903, 536657, 559927, 664632, 567756, 433888, 501226, 520793, 506990, 484227, 498817, 562363, 569835, 619709, 623933, 469335, 476223, 524897, 565105, 587875, 610628, 603994, 659216, 602010, 608692, 544123, 620757, 484017);

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
  433888
  438836
  439754
  446657
  446828
  447741
  456571
  464391
  465552
  469335
  475144
  476223
  478565
  484017
  484227
  491751
  492229
  496900
  498817
  499588
  500110
  501226
  504759
  506990
  512843
  513621
  515811
  515824
  516789
  520793
  522121
  522272
  522926
  524533
  524897
  528264
  536657
  536903
  540626
  544123
  546680
  559620
  559927
  562363
  563809
  565105
  567756
  569654
  569835
  576604
  583550
  584669
  585400
  587875
  588288
  588724
  595950
  602010
  603951
  603994
  604046
  608692
  609915
  610628
  619709
  620757
  621354
  623933
  659216
  664632
  796079
  810902
  811090
  813191
]

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 (433888, 438836, 439754, 446657, 446828, 447741, 456571, 464391, 465552, 469335, 475144, 476223, 478565, 484017, 484227, 491751, 492229, 496900, 498817, 499588, 500110, 501226, 504759, 506990, 512843, 513621, 515811, 515824, 516789, 520793, 522121, 522272, 522926, 524533, 524897, 528264, 536657, 536903, 540626, 544123, 546680, 559620, 559927, 562363, 563809, 565105, 567756, 569654, 569835, 576604, 583550, 584669, 585400, 587875, 588288, 588724, 595950, 602010, 603951, 603994, 604046, 608692, 609915, 610628, 619709, 620757, 621354, 623933, 659216, 664632, 796079, 810902, 811090, 813191);

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
  433888
  438836
  439754
  446657
  446828
  447741
  456571
  464391
  465552
  469335
  475144
  476223
  478565
  484017
  484227
  491751
  492229
  496900
  498817
  499588
  500110
  501226
  504759
  506990
  512843
  513621
  515811
  515824
  516789
  520793
  522121
  522272
  522926
  524533
  524897
  528264
  536657
  536903
  540626
  544123
  546680
  559620
  559927
  562363
  563809
  565105
  567756
  569654
  569835
  576604
  583550
  584669
  585400
  587875
  588288
  588724
  595950
  602010
  603951
  603994
  604046
  608692
  609915
  610628
  619709
  620757
  621354
  623933
  659216
  664632
  796079
  810902
  811090
  813191
]

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 (433888, 438836, 439754, 446657, 446828, 447741, 456571, 464391, 465552, 469335, 475144, 476223, 478565, 484017, 484227, 491751, 492229, 496900, 498817, 499588, 500110, 501226, 504759, 506990, 512843, 513621, 515811, 515824, 516789, 520793, 522121, 522272, 522926, 524533, 524897, 528264, 536657, 536903, 540626, 544123, 546680, 559620, 559927, 562363, 563809, 565105, 567756, 569654, 569835, 576604, 583550, 584669, 585400, 587875, 588288, 588724, 595950, 602010, 603951, 603994, 604046, 608692, 609915, 610628, 619709, 620757, 621354, 623933, 659216, 664632, 796079, 810902, 811090, 813191);

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

[
  "put hair"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'put hair';

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

[
  "put hair"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'put hair';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "put the hair"
  "put the hair"
  "put the hair"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('put the hair') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('put the hair')
              AND `query` <> 'put the hair'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;