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

[
  "big bob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big bob' 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
  523408
  526359
  495392
  564327
  524104
  469552
  502147
  558441
  482313
  491782
  529355
  555143
  657051
  584724
  595315
  512928
  612799
  724305
  525113
  507651
  567151
  562000
  474643
  550315
  566597
  670089
  653219
  654617
  586519
  599533
  472155
  524508
  617370
  497779
  545015
  572026
  582730
  562531
  599317
  498043
  609140
  457103
  543061
  652893
  658269
  655705
  594802
  618762
  520145
  550415
  612698
  532246
  522865
  502533
  562358
  621946
  590221
  613867
  494617
  515723
  584704
  615429
  587896
  543772
  621735
  504718
  527048
  671863
  492736
  632059
  559392
  549225
  562825
]

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 (523408, 526359, 495392, 564327, 524104, 469552, 502147, 558441, 482313, 491782, 529355, 555143, 657051, 584724, 595315, 512928, 612799, 724305, 525113, 507651, 567151, 562000, 474643, 550315, 566597, 670089, 653219, 654617, 586519, 599533, 472155, 524508, 617370, 497779, 545015, 572026, 582730, 562531, 599317, 498043, 609140, 457103, 543061, 652893, 658269, 655705, 594802, 618762, 520145, 550415, 612698, 532246, 522865, 502533, 562358, 621946, 590221, 613867, 494617, 515723, 584704, 615429, 587896, 543772, 621735, 504718, 527048, 671863, 492736, 632059, 559392, 549225, 562825);

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
  457103
  469552
  472155
  474643
  482313
  491782
  492736
  494617
  495392
  497779
  498043
  502147
  502533
  504718
  507651
  512928
  515723
  520145
  522865
  523408
  524104
  524508
  525113
  526359
  527048
  529355
  532246
  543061
  543772
  545015
  549225
  550315
  550415
  555143
  558441
  559392
  562000
  562358
  562531
  562825
  564327
  566597
  567151
  572026
  582730
  584704
  584724
  586519
  587896
  590221
  594802
  595315
  599317
  599533
  609140
  612698
  612799
  613867
  615429
  617370
  618762
  621735
  621946
  632059
  652893
  653219
  654617
  655705
  657051
  658269
  670089
  671863
  724305
]

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 (457103, 469552, 472155, 474643, 482313, 491782, 492736, 494617, 495392, 497779, 498043, 502147, 502533, 504718, 507651, 512928, 515723, 520145, 522865, 523408, 524104, 524508, 525113, 526359, 527048, 529355, 532246, 543061, 543772, 545015, 549225, 550315, 550415, 555143, 558441, 559392, 562000, 562358, 562531, 562825, 564327, 566597, 567151, 572026, 582730, 584704, 584724, 586519, 587896, 590221, 594802, 595315, 599317, 599533, 609140, 612698, 612799, 613867, 615429, 617370, 618762, 621735, 621946, 632059, 652893, 653219, 654617, 655705, 657051, 658269, 670089, 671863, 724305);

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
  457103
  469552
  472155
  474643
  482313
  491782
  492736
  494617
  495392
  497779
  498043
  502147
  502533
  504718
  507651
  512928
  515723
  520145
  522865
  523408
  524104
  524508
  525113
  526359
  527048
  529355
  532246
  543061
  543772
  545015
  549225
  550315
  550415
  555143
  558441
  559392
  562000
  562358
  562531
  562825
  564327
  566597
  567151
  572026
  582730
  584704
  584724
  586519
  587896
  590221
  594802
  595315
  599317
  599533
  609140
  612698
  612799
  613867
  615429
  617370
  618762
  621735
  621946
  632059
  652893
  653219
  654617
  655705
  657051
  658269
  670089
  671863
  724305
]

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 (457103, 469552, 472155, 474643, 482313, 491782, 492736, 494617, 495392, 497779, 498043, 502147, 502533, 504718, 507651, 512928, 515723, 520145, 522865, 523408, 524104, 524508, 525113, 526359, 527048, 529355, 532246, 543061, 543772, 545015, 549225, 550315, 550415, 555143, 558441, 559392, 562000, 562358, 562531, 562825, 564327, 566597, 567151, 572026, 582730, 584704, 584724, 586519, 587896, 590221, 594802, 595315, 599317, 599533, 609140, 612698, 612799, 613867, 615429, 617370, 618762, 621735, 621946, 632059, 652893, 653219, 654617, 655705, 657051, 658269, 670089, 671863, 724305);

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 ?

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