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

[
  "latin beautiful"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'latin beautiful' 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
  781797
  707450
  798101
  756220
  724433
  602153
  815011
  587467
  630455
  469813
  682206
  760367
  464877
  701989
  803599
  395655
  785547
  440629
  397819
  427203
  720509
  682510
  693034
  728174
  643008
  450254
  532008
  679653
  561431
  643279
  340613
  395724
  401439
  403458
  448756
  461845
  460641
  596907
  812914
  737451
  797460
  402882
  503573
  401114
  397354
  401117
  491288
  564721
  398833
  402136
  453938
  514928
  809291
  804442
  416184
  515179
  596659
  624502
  515153
  472441
  476578
  531776
  625444
  515167
  525236
  481364
  449372
  420530
  454924
  486399
  500758
  448829
  507880
  473871
]

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 (781797, 707450, 798101, 756220, 724433, 602153, 815011, 587467, 630455, 469813, 682206, 760367, 464877, 701989, 803599, 395655, 785547, 440629, 397819, 427203, 720509, 682510, 693034, 728174, 643008, 450254, 532008, 679653, 561431, 643279, 340613, 395724, 401439, 403458, 448756, 461845, 460641, 596907, 812914, 737451, 797460, 402882, 503573, 401114, 397354, 401117, 491288, 564721, 398833, 402136, 453938, 514928, 809291, 804442, 416184, 515179, 596659, 624502, 515153, 472441, 476578, 531776, 625444, 515167, 525236, 481364, 449372, 420530, 454924, 486399, 500758, 448829, 507880, 473871);

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
  340613
  395655
  395724
  397354
  397819
  398833
  401114
  401117
  401439
  402136
  402882
  403458
  416184
  420530
  427203
  440629
  448756
  448829
  449372
  450254
  453938
  454924
  460641
  461845
  464877
  469813
  472441
  473871
  476578
  481364
  486399
  491288
  500758
  503573
  507880
  514928
  515153
  515167
  515179
  525236
  531776
  532008
  561431
  564721
  587467
  596659
  596907
  602153
  624502
  625444
  643008
  643279
  679653
  682206
  682510
  693034
  701989
  707450
  720509
  724433
  728174
  737451
  756220
  760367
  781797
  785547
  797460
  798101
  803599
  804442
  809291
  812914
  815011
]

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 (340613, 395655, 395724, 397354, 397819, 398833, 401114, 401117, 401439, 402136, 402882, 403458, 416184, 420530, 427203, 440629, 448756, 448829, 449372, 450254, 453938, 454924, 460641, 461845, 464877, 469813, 472441, 473871, 476578, 481364, 486399, 491288, 500758, 503573, 507880, 514928, 515153, 515167, 515179, 525236, 531776, 532008, 561431, 564721, 587467, 596659, 596907, 602153, 624502, 625444, 643008, 643279, 679653, 682206, 682510, 693034, 701989, 707450, 720509, 724433, 728174, 737451, 756220, 760367, 781797, 785547, 797460, 798101, 803599, 804442, 809291, 812914, 815011);

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
  340613
  395655
  395724
  397354
  397819
  398833
  401114
  401117
  401439
  402136
  402882
  403458
  416184
  420530
  427203
  440629
  448756
  448829
  449372
  450254
  453938
  454924
  460641
  461845
  464877
  469813
  472441
  473871
  476578
  481364
  486399
  491288
  500758
  503573
  507880
  514928
  515153
  515167
  515179
  525236
  531776
  532008
  561431
  564721
  587467
  596659
  596907
  602153
  624502
  625444
  643008
  643279
  679653
  682206
  682510
  693034
  701989
  707450
  720509
  724433
  728174
  737451
  756220
  760367
  781797
  785547
  797460
  798101
  803599
  804442
  809291
  812914
  815011
]

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 (340613, 395655, 395724, 397354, 397819, 398833, 401114, 401117, 401439, 402136, 402882, 403458, 416184, 420530, 427203, 440629, 448756, 448829, 449372, 450254, 453938, 454924, 460641, 461845, 464877, 469813, 472441, 473871, 476578, 481364, 486399, 491288, 500758, 503573, 507880, 514928, 515153, 515167, 515179, 525236, 531776, 532008, 561431, 564721, 587467, 596659, 596907, 602153, 624502, 625444, 643008, 643279, 679653, 682206, 682510, 693034, 701989, 707450, 720509, 724433, 728174, 737451, 756220, 760367, 781797, 785547, 797460, 798101, 803599, 804442, 809291, 812914, 815011);

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

[
  "latin красивая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'latin красивая';

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

[
  "latin красивая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'latin красивая';

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 ?

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