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

[
  "зрелую сильно"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'зрелую сильно' 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
  576653
  605111
  482270
  549727
  566843
  475870
  668505
  523253
  554776
  529355
  577435
  474818
  569955
  563446
  596330
  452080
  514830
  569960
  442239
  464727
  573759
  493204
  482953
  603295
  440426
  609248
  599353
  574450
  527442
  593162
  425829
  486904
  684305
  477873
  545944
  602610
  499867
  538333
  528712
  565783
  619407
  524323
  546114
  553269
  597736
  608930
  605764
  564203
  475630
  465336
  601125
  511345
  554392
  493958
  578631
  527199
  598654
  622778
  407252
  504411
  582468
  524544
  621764
  506606
  623678
  474139
  527908
  491823
  607129
  404584
  523336
]

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 (576653, 605111, 482270, 549727, 566843, 475870, 668505, 523253, 554776, 529355, 577435, 474818, 569955, 563446, 596330, 452080, 514830, 569960, 442239, 464727, 573759, 493204, 482953, 603295, 440426, 609248, 599353, 574450, 527442, 593162, 425829, 486904, 684305, 477873, 545944, 602610, 499867, 538333, 528712, 565783, 619407, 524323, 546114, 553269, 597736, 608930, 605764, 564203, 475630, 465336, 601125, 511345, 554392, 493958, 578631, 527199, 598654, 622778, 407252, 504411, 582468, 524544, 621764, 506606, 623678, 474139, 527908, 491823, 607129, 404584, 523336);

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
  404584
  407252
  425829
  440426
  442239
  452080
  464727
  465336
  474139
  474818
  475630
  475870
  477873
  482270
  482953
  486904
  491823
  493204
  493958
  499867
  504411
  506606
  511345
  514830
  523253
  523336
  524323
  524544
  527199
  527442
  527908
  528712
  529355
  538333
  545944
  546114
  549727
  553269
  554392
  554776
  563446
  564203
  565783
  566843
  569955
  569960
  573759
  574450
  576653
  577435
  578631
  582468
  593162
  596330
  597736
  598654
  599353
  601125
  602610
  603295
  605111
  605764
  607129
  608930
  609248
  619407
  621764
  622778
  623678
  668505
  684305
]

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 (404584, 407252, 425829, 440426, 442239, 452080, 464727, 465336, 474139, 474818, 475630, 475870, 477873, 482270, 482953, 486904, 491823, 493204, 493958, 499867, 504411, 506606, 511345, 514830, 523253, 523336, 524323, 524544, 527199, 527442, 527908, 528712, 529355, 538333, 545944, 546114, 549727, 553269, 554392, 554776, 563446, 564203, 565783, 566843, 569955, 569960, 573759, 574450, 576653, 577435, 578631, 582468, 593162, 596330, 597736, 598654, 599353, 601125, 602610, 603295, 605111, 605764, 607129, 608930, 609248, 619407, 621764, 622778, 623678, 668505, 684305);

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
  404584
  407252
  425829
  440426
  442239
  452080
  464727
  465336
  474139
  474818
  475630
  475870
  477873
  482270
  482953
  486904
  491823
  493204
  493958
  499867
  504411
  506606
  511345
  514830
  523253
  523336
  524323
  524544
  527199
  527442
  527908
  528712
  529355
  538333
  545944
  546114
  549727
  553269
  554392
  554776
  563446
  564203
  565783
  566843
  569955
  569960
  573759
  574450
  576653
  577435
  578631
  582468
  593162
  596330
  597736
  598654
  599353
  601125
  602610
  603295
  605111
  605764
  607129
  608930
  609248
  619407
  621764
  622778
  623678
  668505
  684305
]

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 (404584, 407252, 425829, 440426, 442239, 452080, 464727, 465336, 474139, 474818, 475630, 475870, 477873, 482270, 482953, 486904, 491823, 493204, 493958, 499867, 504411, 506606, 511345, 514830, 523253, 523336, 524323, 524544, 527199, 527442, 527908, 528712, 529355, 538333, 545944, 546114, 549727, 553269, 554392, 554776, 563446, 564203, 565783, 566843, 569955, 569960, 573759, 574450, 576653, 577435, 578631, 582468, 593162, 596330, 597736, 598654, 599353, 601125, 602610, 603295, 605111, 605764, 607129, 608930, 609248, 619407, 621764, 622778, 623678, 668505, 684305);

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

[
  "зрелая женщин сильн"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'зрелая женщин сильн';

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

[
  "зрелая женщин сильн"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'зрелая женщин сильн';

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 ?

[
  "зрелую сильно"
  "зрелую сильно"
  "зрелую сильно"
  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 ('зрелую сильно') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('зрелую сильно')
              AND `query` <> 'зрелую сильно'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;