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

[
  "skinny sex yoga"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny sex yoga' 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
  501203
  718084
  598045
  778875
  737734
  822538
  826737
  397114
  745241
  632719
  992
  533500
  754180
  810349
  771859
  777652
  689758
  821444
  559383
  690648
  422910
  598538
  598552
  479538
  436523
  709627
  406347
  491528
  578451
  499012
  601678
  382837
  442992
  553320
  420268
  731884
  568445
  557657
  571735
  729535
  586152
  420289
  577301
  814810
  523409
  440671
  435426
  490458
  582871
  461616
  417136
  513449
  581730
  587453
  439361
  640708
  454099
  416817
  635234
  549513
  598076
  483039
  587421
  601650
  418361
  577931
  519087
  599694
  490373
  596168
  556489
  602945
]

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 (501203, 718084, 598045, 778875, 737734, 822538, 826737, 397114, 745241, 632719, 992, 533500, 754180, 810349, 771859, 777652, 689758, 821444, 559383, 690648, 422910, 598538, 598552, 479538, 436523, 709627, 406347, 491528, 578451, 499012, 601678, 382837, 442992, 553320, 420268, 731884, 568445, 557657, 571735, 729535, 586152, 420289, 577301, 814810, 523409, 440671, 435426, 490458, 582871, 461616, 417136, 513449, 581730, 587453, 439361, 640708, 454099, 416817, 635234, 549513, 598076, 483039, 587421, 601650, 418361, 577931, 519087, 599694, 490373, 596168, 556489, 602945);

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
  992
  382837
  397114
  406347
  416817
  417136
  418361
  420268
  420289
  422910
  435426
  436523
  439361
  440671
  442992
  454099
  461616
  479538
  483039
  490373
  490458
  491528
  499012
  501203
  513449
  519087
  523409
  533500
  549513
  553320
  556489
  557657
  559383
  568445
  571735
  577301
  577931
  578451
  581730
  582871
  586152
  587421
  587453
  596168
  598045
  598076
  598538
  598552
  599694
  601650
  601678
  602945
  632719
  635234
  640708
  689758
  690648
  709627
  718084
  729535
  731884
  737734
  745241
  754180
  771859
  777652
  778875
  810349
  814810
  821444
  822538
  826737
]

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 (992, 382837, 397114, 406347, 416817, 417136, 418361, 420268, 420289, 422910, 435426, 436523, 439361, 440671, 442992, 454099, 461616, 479538, 483039, 490373, 490458, 491528, 499012, 501203, 513449, 519087, 523409, 533500, 549513, 553320, 556489, 557657, 559383, 568445, 571735, 577301, 577931, 578451, 581730, 582871, 586152, 587421, 587453, 596168, 598045, 598076, 598538, 598552, 599694, 601650, 601678, 602945, 632719, 635234, 640708, 689758, 690648, 709627, 718084, 729535, 731884, 737734, 745241, 754180, 771859, 777652, 778875, 810349, 814810, 821444, 822538, 826737);

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
  992
  382837
  397114
  406347
  416817
  417136
  418361
  420268
  420289
  422910
  435426
  436523
  439361
  440671
  442992
  454099
  461616
  479538
  483039
  490373
  490458
  491528
  499012
  501203
  513449
  519087
  523409
  533500
  549513
  553320
  556489
  557657
  559383
  568445
  571735
  577301
  577931
  578451
  581730
  582871
  586152
  587421
  587453
  596168
  598045
  598076
  598538
  598552
  599694
  601650
  601678
  602945
  632719
  635234
  640708
  689758
  690648
  709627
  718084
  729535
  731884
  737734
  745241
  754180
  771859
  777652
  778875
  810349
  814810
  821444
  822538
  826737
]

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 (992, 382837, 397114, 406347, 416817, 417136, 418361, 420268, 420289, 422910, 435426, 436523, 439361, 440671, 442992, 454099, 461616, 479538, 483039, 490373, 490458, 491528, 499012, 501203, 513449, 519087, 523409, 533500, 549513, 553320, 556489, 557657, 559383, 568445, 571735, 577301, 577931, 578451, 581730, 582871, 586152, 587421, 587453, 596168, 598045, 598076, 598538, 598552, 599694, 601650, 601678, 602945, 632719, 635234, 640708, 689758, 690648, 709627, 718084, 729535, 731884, 737734, 745241, 754180, 771859, 777652, 778875, 810349, 814810, 821444, 822538, 826737);

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

[
  "худые секс yoga"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'худые секс yoga';

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

[
  "худые секс yoga"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'худые секс yoga';

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 ?

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