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

[
  "kitchen table"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kitchen table' 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
  417514
  514467
  489597
  498671
  569289
  572927
  573445
  581306
  591067
  510705
  512608
  530414
  487498
  553921
  562742
  579617
  556121
  590990
  591014
  422269
  509630
  591512
  512257
  585140
  590545
  503389
  521995
  490274
  567429
  620216
  788399
  777178
  729773
  761666
  543661
  796369
  541172
  753950
  793095
  564670
  788909
  777678
  807481
  723020
  749896
  479918
  645736
  477625
  422188
  559470
  479987
  523716
  522299
  522304
  574818
  498265
  561852
  566765
  575498
  475210
  512260
  554173
  511465
  491322
  557928
  591908
  617019
  514478
  586963
  522690
  598161
]

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 (417514, 514467, 489597, 498671, 569289, 572927, 573445, 581306, 591067, 510705, 512608, 530414, 487498, 553921, 562742, 579617, 556121, 590990, 591014, 422269, 509630, 591512, 512257, 585140, 590545, 503389, 521995, 490274, 567429, 620216, 788399, 777178, 729773, 761666, 543661, 796369, 541172, 753950, 793095, 564670, 788909, 777678, 807481, 723020, 749896, 479918, 645736, 477625, 422188, 559470, 479987, 523716, 522299, 522304, 574818, 498265, 561852, 566765, 575498, 475210, 512260, 554173, 511465, 491322, 557928, 591908, 617019, 514478, 586963, 522690, 598161);

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
  417514
  422188
  422269
  475210
  477625
  479918
  479987
  487498
  489597
  490274
  491322
  498265
  498671
  503389
  509630
  510705
  511465
  512257
  512260
  512608
  514467
  514478
  521995
  522299
  522304
  522690
  523716
  530414
  541172
  543661
  553921
  554173
  556121
  557928
  559470
  561852
  562742
  564670
  566765
  567429
  569289
  572927
  573445
  574818
  575498
  579617
  581306
  585140
  586963
  590545
  590990
  591014
  591067
  591512
  591908
  598161
  617019
  620216
  645736
  723020
  729773
  749896
  753950
  761666
  777178
  777678
  788399
  788909
  793095
  796369
  807481
]

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 (417514, 422188, 422269, 475210, 477625, 479918, 479987, 487498, 489597, 490274, 491322, 498265, 498671, 503389, 509630, 510705, 511465, 512257, 512260, 512608, 514467, 514478, 521995, 522299, 522304, 522690, 523716, 530414, 541172, 543661, 553921, 554173, 556121, 557928, 559470, 561852, 562742, 564670, 566765, 567429, 569289, 572927, 573445, 574818, 575498, 579617, 581306, 585140, 586963, 590545, 590990, 591014, 591067, 591512, 591908, 598161, 617019, 620216, 645736, 723020, 729773, 749896, 753950, 761666, 777178, 777678, 788399, 788909, 793095, 796369, 807481);

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
  417514
  422188
  422269
  475210
  477625
  479918
  479987
  487498
  489597
  490274
  491322
  498265
  498671
  503389
  509630
  510705
  511465
  512257
  512260
  512608
  514467
  514478
  521995
  522299
  522304
  522690
  523716
  530414
  541172
  543661
  553921
  554173
  556121
  557928
  559470
  561852
  562742
  564670
  566765
  567429
  569289
  572927
  573445
  574818
  575498
  579617
  581306
  585140
  586963
  590545
  590990
  591014
  591067
  591512
  591908
  598161
  617019
  620216
  645736
  723020
  729773
  749896
  753950
  761666
  777178
  777678
  788399
  788909
  793095
  796369
  807481
]

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 (417514, 422188, 422269, 475210, 477625, 479918, 479987, 487498, 489597, 490274, 491322, 498265, 498671, 503389, 509630, 510705, 511465, 512257, 512260, 512608, 514467, 514478, 521995, 522299, 522304, 522690, 523716, 530414, 541172, 543661, 553921, 554173, 556121, 557928, 559470, 561852, 562742, 564670, 566765, 567429, 569289, 572927, 573445, 574818, 575498, 579617, 581306, 585140, 586963, 590545, 590990, 591014, 591067, 591512, 591908, 598161, 617019, 620216, 645736, 723020, 729773, 749896, 753950, 761666, 777178, 777678, 788399, 788909, 793095, 796369, 807481);

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

[
  "кухн table"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'кухн table';

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

[
  "кухн table"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'кухн table';

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 ?

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