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

[
  "japanese asian mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'japanese asian mom' 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
  460577
  550644
  550643
  621026
  566014
  551966
  552942
  565492
  694195
  391002
  552901
  694199
  166116
  532130
  566013
  619458
  510595
  603458
  619438
  469549
  388113
  572730
  619431
  583298
  551028
  551949
  583213
  627728
  552017
  565468
  552043
  530348
  639310
  556397
  774690
  464676
  397161
  404841
  445438
  622650
  538333
  550642
  550615
  565990
  166675
  580269
  510589
  590934
  565161
  623610
  765721
  797788
  566015
  565986
  562900
  551005
  558368
  586584
  622628
  565982
  566002
  565974
  557812
  623522
  636290
  512212
  550770
  801043
  516873
]

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 (460577, 550644, 550643, 621026, 566014, 551966, 552942, 565492, 694195, 391002, 552901, 694199, 166116, 532130, 566013, 619458, 510595, 603458, 619438, 469549, 388113, 572730, 619431, 583298, 551028, 551949, 583213, 627728, 552017, 565468, 552043, 530348, 639310, 556397, 774690, 464676, 397161, 404841, 445438, 622650, 538333, 550642, 550615, 565990, 166675, 580269, 510589, 590934, 565161, 623610, 765721, 797788, 566015, 565986, 562900, 551005, 558368, 586584, 622628, 565982, 566002, 565974, 557812, 623522, 636290, 512212, 550770, 801043, 516873);

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
  166116
  166675
  388113
  391002
  397161
  404841
  445438
  460577
  464676
  469549
  510589
  510595
  512212
  516873
  530348
  532130
  538333
  550615
  550642
  550643
  550644
  550770
  551005
  551028
  551949
  551966
  552017
  552043
  552901
  552942
  556397
  557812
  558368
  562900
  565161
  565468
  565492
  565974
  565982
  565986
  565990
  566002
  566013
  566014
  566015
  572730
  580269
  583213
  583298
  586584
  590934
  603458
  619431
  619438
  619458
  621026
  622628
  622650
  623522
  623610
  627728
  636290
  639310
  694195
  694199
  765721
  774690
  797788
  801043
]

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 (166116, 166675, 388113, 391002, 397161, 404841, 445438, 460577, 464676, 469549, 510589, 510595, 512212, 516873, 530348, 532130, 538333, 550615, 550642, 550643, 550644, 550770, 551005, 551028, 551949, 551966, 552017, 552043, 552901, 552942, 556397, 557812, 558368, 562900, 565161, 565468, 565492, 565974, 565982, 565986, 565990, 566002, 566013, 566014, 566015, 572730, 580269, 583213, 583298, 586584, 590934, 603458, 619431, 619438, 619458, 621026, 622628, 622650, 623522, 623610, 627728, 636290, 639310, 694195, 694199, 765721, 774690, 797788, 801043);

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
  166116
  166675
  388113
  391002
  397161
  404841
  445438
  460577
  464676
  469549
  510589
  510595
  512212
  516873
  530348
  532130
  538333
  550615
  550642
  550643
  550644
  550770
  551005
  551028
  551949
  551966
  552017
  552043
  552901
  552942
  556397
  557812
  558368
  562900
  565161
  565468
  565492
  565974
  565982
  565986
  565990
  566002
  566013
  566014
  566015
  572730
  580269
  583213
  583298
  586584
  590934
  603458
  619431
  619438
  619458
  621026
  622628
  622650
  623522
  623610
  627728
  636290
  639310
  694195
  694199
  765721
  774690
  797788
  801043
]

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 (166116, 166675, 388113, 391002, 397161, 404841, 445438, 460577, 464676, 469549, 510589, 510595, 512212, 516873, 530348, 532130, 538333, 550615, 550642, 550643, 550644, 550770, 551005, 551028, 551949, 551966, 552017, 552043, 552901, 552942, 556397, 557812, 558368, 562900, 565161, 565468, 565492, 565974, 565982, 565986, 565990, 566002, 566013, 566014, 566015, 572730, 580269, 583213, 583298, 586584, 590934, 603458, 619431, 619438, 619458, 621026, 622628, 622650, 623522, 623610, 627728, 636290, 639310, 694195, 694199, 765721, 774690, 797788, 801043);

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

[
  "японк азиатк азиатк mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'японк азиатк азиатк mom';

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

[
  "японк азиатк азиатк mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'японк азиатк азиатк mom';

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 ?

[
  "japanese asian mom"
  "japanese asian mom"
  "japanese asian mom"
  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 ('japanese asian mom') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('japanese asian mom')
              AND `query` <> 'japanese asian mom'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;