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

[
  "scenes film"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'scenes film' 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
  547306
  629859
  705297
  537712
  696163
  547329
  572570
  570826
  537741
  490809
  572595
  56632
  485886
  549351
  549943
  570793
  402585
  566800
  490810
  544241
  628317
  438909
  570803
  630925
  535493
  547309
  583848
  626558
  789016
  549347
  572566
  490807
  572625
  570832
  491814
  696168
  742246
  572645
  549384
  572569
  549317
  549364
  549922
  491829
  549285
  549334
  490813
  572551
  490811
  570804
  549312
  572568
  549293
  570830
  593506
  544317
  544352
  549300
  549327
  557333
  549296
  549964
  526071
  583819
  535488
  661693
  570801
  670955
  541370
  574200
  499877
]

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 (547306, 629859, 705297, 537712, 696163, 547329, 572570, 570826, 537741, 490809, 572595, 56632, 485886, 549351, 549943, 570793, 402585, 566800, 490810, 544241, 628317, 438909, 570803, 630925, 535493, 547309, 583848, 626558, 789016, 549347, 572566, 490807, 572625, 570832, 491814, 696168, 742246, 572645, 549384, 572569, 549317, 549364, 549922, 491829, 549285, 549334, 490813, 572551, 490811, 570804, 549312, 572568, 549293, 570830, 593506, 544317, 544352, 549300, 549327, 557333, 549296, 549964, 526071, 583819, 535488, 661693, 570801, 670955, 541370, 574200, 499877);

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
  56632
  402585
  438909
  485886
  490807
  490809
  490810
  490811
  490813
  491814
  491829
  499877
  526071
  535488
  535493
  537712
  537741
  541370
  544241
  544317
  544352
  547306
  547309
  547329
  549285
  549293
  549296
  549300
  549312
  549317
  549327
  549334
  549347
  549351
  549364
  549384
  549922
  549943
  549964
  557333
  566800
  570793
  570801
  570803
  570804
  570826
  570830
  570832
  572551
  572566
  572568
  572569
  572570
  572595
  572625
  572645
  574200
  583819
  583848
  593506
  626558
  628317
  629859
  630925
  661693
  670955
  696163
  696168
  705297
  742246
  789016
]

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 (56632, 402585, 438909, 485886, 490807, 490809, 490810, 490811, 490813, 491814, 491829, 499877, 526071, 535488, 535493, 537712, 537741, 541370, 544241, 544317, 544352, 547306, 547309, 547329, 549285, 549293, 549296, 549300, 549312, 549317, 549327, 549334, 549347, 549351, 549364, 549384, 549922, 549943, 549964, 557333, 566800, 570793, 570801, 570803, 570804, 570826, 570830, 570832, 572551, 572566, 572568, 572569, 572570, 572595, 572625, 572645, 574200, 583819, 583848, 593506, 626558, 628317, 629859, 630925, 661693, 670955, 696163, 696168, 705297, 742246, 789016);

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
  56632
  402585
  438909
  485886
  490807
  490809
  490810
  490811
  490813
  491814
  491829
  499877
  526071
  535488
  535493
  537712
  537741
  541370
  544241
  544317
  544352
  547306
  547309
  547329
  549285
  549293
  549296
  549300
  549312
  549317
  549327
  549334
  549347
  549351
  549364
  549384
  549922
  549943
  549964
  557333
  566800
  570793
  570801
  570803
  570804
  570826
  570830
  570832
  572551
  572566
  572568
  572569
  572570
  572595
  572625
  572645
  574200
  583819
  583848
  593506
  626558
  628317
  629859
  630925
  661693
  670955
  696163
  696168
  705297
  742246
  789016
]

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 (56632, 402585, 438909, 485886, 490807, 490809, 490810, 490811, 490813, 491814, 491829, 499877, 526071, 535488, 535493, 537712, 537741, 541370, 544241, 544317, 544352, 547306, 547309, 547329, 549285, 549293, 549296, 549300, 549312, 549317, 549327, 549334, 549347, 549351, 549364, 549384, 549922, 549943, 549964, 557333, 566800, 570793, 570801, 570803, 570804, 570826, 570830, 570832, 572551, 572566, 572568, 572569, 572570, 572595, 572625, 572645, 574200, 583819, 583848, 593506, 626558, 628317, 629859, 630925, 661693, 670955, 696163, 696168, 705297, 742246, 789016);

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

[
  "scenes фильм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'scenes фильм';

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

[
  "scenes фильм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'scenes фильм';

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 ?

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