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

[
  "solo nylon"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'solo nylon' 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
  754085
  818312
  606230
  776780
  796841
  800653
  800664
  776823
  811111
  390846
  817590
  823789
  811104
  731909
  749066
  810480
  202872
  382490
  571695
  795655
  800680
  776868
  811109
  811069
  602242
  806476
  386583
  395949
  813963
  637180
  812403
  799058
  524030
  539318
  202846
  708505
  796818
  134506
  824303
  529943
  800763
  453397
  513202
  424007
  450038
  811110
  518794
  552882
  681232
  706801
  592221
  623821
  760178
  772574
  751017
  770158
  448013
  480641
  508070
  512714
  450065
  542987
  569572
  681251
  557378
  583839
  602197
  800677
  740479
  388110
  574768
  586189
  486875
]

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 (754085, 818312, 606230, 776780, 796841, 800653, 800664, 776823, 811111, 390846, 817590, 823789, 811104, 731909, 749066, 810480, 202872, 382490, 571695, 795655, 800680, 776868, 811109, 811069, 602242, 806476, 386583, 395949, 813963, 637180, 812403, 799058, 524030, 539318, 202846, 708505, 796818, 134506, 824303, 529943, 800763, 453397, 513202, 424007, 450038, 811110, 518794, 552882, 681232, 706801, 592221, 623821, 760178, 772574, 751017, 770158, 448013, 480641, 508070, 512714, 450065, 542987, 569572, 681251, 557378, 583839, 602197, 800677, 740479, 388110, 574768, 586189, 486875);

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
  134506
  202846
  202872
  382490
  386583
  388110
  390846
  395949
  424007
  448013
  450038
  450065
  453397
  480641
  486875
  508070
  512714
  513202
  518794
  524030
  529943
  539318
  542987
  552882
  557378
  569572
  571695
  574768
  583839
  586189
  592221
  602197
  602242
  606230
  623821
  637180
  681232
  681251
  706801
  708505
  731909
  740479
  749066
  751017
  754085
  760178
  770158
  772574
  776780
  776823
  776868
  795655
  796818
  796841
  799058
  800653
  800664
  800677
  800680
  800763
  806476
  810480
  811069
  811104
  811109
  811110
  811111
  812403
  813963
  817590
  818312
  823789
  824303
]

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 (134506, 202846, 202872, 382490, 386583, 388110, 390846, 395949, 424007, 448013, 450038, 450065, 453397, 480641, 486875, 508070, 512714, 513202, 518794, 524030, 529943, 539318, 542987, 552882, 557378, 569572, 571695, 574768, 583839, 586189, 592221, 602197, 602242, 606230, 623821, 637180, 681232, 681251, 706801, 708505, 731909, 740479, 749066, 751017, 754085, 760178, 770158, 772574, 776780, 776823, 776868, 795655, 796818, 796841, 799058, 800653, 800664, 800677, 800680, 800763, 806476, 810480, 811069, 811104, 811109, 811110, 811111, 812403, 813963, 817590, 818312, 823789, 824303);

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
  134506
  202846
  202872
  382490
  386583
  388110
  390846
  395949
  424007
  448013
  450038
  450065
  453397
  480641
  486875
  508070
  512714
  513202
  518794
  524030
  529943
  539318
  542987
  552882
  557378
  569572
  571695
  574768
  583839
  586189
  592221
  602197
  602242
  606230
  623821
  637180
  681232
  681251
  706801
  708505
  731909
  740479
  749066
  751017
  754085
  760178
  770158
  772574
  776780
  776823
  776868
  795655
  796818
  796841
  799058
  800653
  800664
  800677
  800680
  800763
  806476
  810480
  811069
  811104
  811109
  811110
  811111
  812403
  813963
  817590
  818312
  823789
  824303
]

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 (134506, 202846, 202872, 382490, 386583, 388110, 390846, 395949, 424007, 448013, 450038, 450065, 453397, 480641, 486875, 508070, 512714, 513202, 518794, 524030, 529943, 539318, 542987, 552882, 557378, 569572, 571695, 574768, 583839, 586189, 592221, 602197, 602242, 606230, 623821, 637180, 681232, 681251, 706801, 708505, 731909, 740479, 749066, 751017, 754085, 760178, 770158, 772574, 776780, 776823, 776868, 795655, 796818, 796841, 799058, 800653, 800664, 800677, 800680, 800763, 806476, 810480, 811069, 811104, 811109, 811110, 811111, 812403, 813963, 817590, 818312, 823789, 824303);

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

[
  "соло nylon"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'соло nylon';

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

[
  "соло nylon"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'соло nylon';

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 ?

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