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

[
  "plug and dick"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'plug and dick' 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
  421555
  398695
  499544
  555071
  766849
  421579
  530001
  447861
  494174
  524096
  511631
  590088
  436735
  411478
  454647
  472767
  514252
  505717
  463694
  452300
  461848
  441168
  517431
  495758
  522944
  495813
  552628
  675675
  686868
  675723
  598317
  780419
  813278
  603445
  785096
  415942
  558584
  637540
  770708
  471475
  469546
  493535
  461872
  501506
  537455
  501458
  461890
  500732
  523130
  488747
  627727
  807985
  595950
  510108
  476921
  538281
  451175
  462171
  445367
  814429
  655255
  626965
  749924
  593875
  490060
  583039
  585744
  478090
  632601
  567673
  604743
  615482
]

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 (421555, 398695, 499544, 555071, 766849, 421579, 530001, 447861, 494174, 524096, 511631, 590088, 436735, 411478, 454647, 472767, 514252, 505717, 463694, 452300, 461848, 441168, 517431, 495758, 522944, 495813, 552628, 675675, 686868, 675723, 598317, 780419, 813278, 603445, 785096, 415942, 558584, 637540, 770708, 471475, 469546, 493535, 461872, 501506, 537455, 501458, 461890, 500732, 523130, 488747, 627727, 807985, 595950, 510108, 476921, 538281, 451175, 462171, 445367, 814429, 655255, 626965, 749924, 593875, 490060, 583039, 585744, 478090, 632601, 567673, 604743, 615482);

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
  398695
  411478
  415942
  421555
  421579
  436735
  441168
  445367
  447861
  451175
  452300
  454647
  461848
  461872
  461890
  462171
  463694
  469546
  471475
  472767
  476921
  478090
  488747
  490060
  493535
  494174
  495758
  495813
  499544
  500732
  501458
  501506
  505717
  510108
  511631
  514252
  517431
  522944
  523130
  524096
  530001
  537455
  538281
  552628
  555071
  558584
  567673
  583039
  585744
  590088
  593875
  595950
  598317
  603445
  604743
  615482
  626965
  627727
  632601
  637540
  655255
  675675
  675723
  686868
  749924
  766849
  770708
  780419
  785096
  807985
  813278
  814429
]

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 (398695, 411478, 415942, 421555, 421579, 436735, 441168, 445367, 447861, 451175, 452300, 454647, 461848, 461872, 461890, 462171, 463694, 469546, 471475, 472767, 476921, 478090, 488747, 490060, 493535, 494174, 495758, 495813, 499544, 500732, 501458, 501506, 505717, 510108, 511631, 514252, 517431, 522944, 523130, 524096, 530001, 537455, 538281, 552628, 555071, 558584, 567673, 583039, 585744, 590088, 593875, 595950, 598317, 603445, 604743, 615482, 626965, 627727, 632601, 637540, 655255, 675675, 675723, 686868, 749924, 766849, 770708, 780419, 785096, 807985, 813278, 814429);

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
  398695
  411478
  415942
  421555
  421579
  436735
  441168
  445367
  447861
  451175
  452300
  454647
  461848
  461872
  461890
  462171
  463694
  469546
  471475
  472767
  476921
  478090
  488747
  490060
  493535
  494174
  495758
  495813
  499544
  500732
  501458
  501506
  505717
  510108
  511631
  514252
  517431
  522944
  523130
  524096
  530001
  537455
  538281
  552628
  555071
  558584
  567673
  583039
  585744
  590088
  593875
  595950
  598317
  603445
  604743
  615482
  626965
  627727
  632601
  637540
  655255
  675675
  675723
  686868
  749924
  766849
  770708
  780419
  785096
  807985
  813278
  814429
]

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 (398695, 411478, 415942, 421555, 421579, 436735, 441168, 445367, 447861, 451175, 452300, 454647, 461848, 461872, 461890, 462171, 463694, 469546, 471475, 472767, 476921, 478090, 488747, 490060, 493535, 494174, 495758, 495813, 499544, 500732, 501458, 501506, 505717, 510108, 511631, 514252, 517431, 522944, 523130, 524096, 530001, 537455, 538281, 552628, 555071, 558584, 567673, 583039, 585744, 590088, 593875, 595950, 598317, 603445, 604743, 615482, 626965, 627727, 632601, 637540, 655255, 675675, 675723, 686868, 749924, 766849, 770708, 780419, 785096, 807985, 813278, 814429);

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

[
  "plug член"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'plug член';

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

[
  "plug член"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'plug член';

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 ?

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