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

[
  "put on stockings"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'put on stockings' 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
  741343
  619709
  825928
  779356
  795317
  576886
  534434
  555184
  825778
  687141
  560052
  824253
  706790
  614856
  699871
  605882
  735202
  810719
  759888
  759900
  664994
  609634
  742735
  703486
  793080
  739085
  796836
  547865
  626827
  726884
  522272
  523066
  727460
  742307
  810298
  601388
  588724
  600943
  550337
  620838
  815431
  455478
  780745
  784206
  761018
  521205
  687157
  702038
  635667
  777846
  723885
  782760
  809842
  796079
  516789
  522121
  433888
  584333
  571762
  585400
  154675
  591227
  528264
  524533
  576604
  815473
  580756
  588288
  446657
  506990
  760178
  476223
  410543
]

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 (741343, 619709, 825928, 779356, 795317, 576886, 534434, 555184, 825778, 687141, 560052, 824253, 706790, 614856, 699871, 605882, 735202, 810719, 759888, 759900, 664994, 609634, 742735, 703486, 793080, 739085, 796836, 547865, 626827, 726884, 522272, 523066, 727460, 742307, 810298, 601388, 588724, 600943, 550337, 620838, 815431, 455478, 780745, 784206, 761018, 521205, 687157, 702038, 635667, 777846, 723885, 782760, 809842, 796079, 516789, 522121, 433888, 584333, 571762, 585400, 154675, 591227, 528264, 524533, 576604, 815473, 580756, 588288, 446657, 506990, 760178, 476223, 410543);

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
  154675
  410543
  433888
  446657
  455478
  476223
  506990
  516789
  521205
  522121
  522272
  523066
  524533
  528264
  534434
  547865
  550337
  555184
  560052
  571762
  576604
  576886
  580756
  584333
  585400
  588288
  588724
  591227
  600943
  601388
  605882
  609634
  614856
  619709
  620838
  626827
  635667
  664994
  687141
  687157
  699871
  702038
  703486
  706790
  723885
  726884
  727460
  735202
  739085
  741343
  742307
  742735
  759888
  759900
  760178
  761018
  777846
  779356
  780745
  782760
  784206
  793080
  795317
  796079
  796836
  809842
  810298
  810719
  815431
  815473
  824253
  825778
]

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 (154675, 410543, 433888, 446657, 455478, 476223, 506990, 516789, 521205, 522121, 522272, 523066, 524533, 528264, 534434, 547865, 550337, 555184, 560052, 571762, 576604, 576886, 580756, 584333, 585400, 588288, 588724, 591227, 600943, 601388, 605882, 609634, 614856, 619709, 620838, 626827, 635667, 664994, 687141, 687157, 699871, 702038, 703486, 706790, 723885, 726884, 727460, 735202, 739085, 741343, 742307, 742735, 759888, 759900, 760178, 761018, 777846, 779356, 780745, 782760, 784206, 793080, 795317, 796079, 796836, 809842, 810298, 810719, 815431, 815473, 824253, 825778);

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
  154675
  410543
  433888
  446657
  455478
  476223
  506990
  516789
  521205
  522121
  522272
  523066
  524533
  528264
  534434
  547865
  550337
  555184
  560052
  571762
  576604
  576886
  580756
  584333
  585400
  588288
  588724
  591227
  600943
  601388
  605882
  609634
  614856
  619709
  620838
  626827
  635667
  664994
  687141
  687157
  699871
  702038
  703486
  706790
  723885
  726884
  727460
  735202
  739085
  741343
  742307
  742735
  759888
  759900
  760178
  761018
  777846
  779356
  780745
  782760
  784206
  793080
  795317
  796079
  796836
  809842
  810298
  810719
  815431
  815473
  824253
  825778
]

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 (154675, 410543, 433888, 446657, 455478, 476223, 506990, 516789, 521205, 522121, 522272, 523066, 524533, 528264, 534434, 547865, 550337, 555184, 560052, 571762, 576604, 576886, 580756, 584333, 585400, 588288, 588724, 591227, 600943, 601388, 605882, 609634, 614856, 619709, 620838, 626827, 635667, 664994, 687141, 687157, 699871, 702038, 703486, 706790, 723885, 726884, 727460, 735202, 739085, 741343, 742307, 742735, 759888, 759900, 760178, 761018, 777846, 779356, 780745, 782760, 784206, 793080, 795317, 796079, 796836, 809842, 810298, 810719, 815431, 815473, 824253, 825778);

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

[
  "put чулк нижн бел"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'put чулк нижн бел';

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

[
  "put чулк нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'put чулк нижн бел';

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 ?

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