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

[
  "big tits facial"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big tits facial' 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
  646029
  632599
  560176
  530499
  525784
  523819
  531144
  554805
  648816
  695124
  599856
  600321
  540573
  615818
  542907
  646771
  632659
  703833
  472524
  531205
  564675
  571005
  600837
  523802
  528282
  561296
  633793
  643027
  574371
  488398
  676428
  532762
  641698
  591416
  642025
  633770
  601595
  810109
  644986
  544840
  552511
  492733
  531067
  391386
  531136
  600029
  632571
  590884
  569096
  412189
  601924
  523822
  520205
  531247
  666895
  630764
  560189
  532745
  620001
  608560
  608416
  531117
  589048
  621946
  637413
  435792
  642662
  516472
  497953
  565541
  571834
  590493
  621330
]

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 (646029, 632599, 560176, 530499, 525784, 523819, 531144, 554805, 648816, 695124, 599856, 600321, 540573, 615818, 542907, 646771, 632659, 703833, 472524, 531205, 564675, 571005, 600837, 523802, 528282, 561296, 633793, 643027, 574371, 488398, 676428, 532762, 641698, 591416, 642025, 633770, 601595, 810109, 644986, 544840, 552511, 492733, 531067, 391386, 531136, 600029, 632571, 590884, 569096, 412189, 601924, 523822, 520205, 531247, 666895, 630764, 560189, 532745, 620001, 608560, 608416, 531117, 589048, 621946, 637413, 435792, 642662, 516472, 497953, 565541, 571834, 590493, 621330);

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
  391386
  412189
  435792
  472524
  488398
  492733
  497953
  516472
  520205
  523802
  523819
  523822
  525784
  528282
  530499
  531067
  531117
  531136
  531144
  531205
  531247
  532745
  532762
  540573
  542907
  544840
  552511
  554805
  560176
  560189
  561296
  564675
  565541
  569096
  571005
  571834
  574371
  589048
  590493
  590884
  591416
  599856
  600029
  600321
  600837
  601595
  601924
  608416
  608560
  615818
  620001
  621330
  621946
  630764
  632571
  632599
  632659
  633770
  633793
  637413
  641698
  642025
  642662
  643027
  644986
  646029
  646771
  648816
  666895
  676428
  695124
  703833
  810109
]

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 (391386, 412189, 435792, 472524, 488398, 492733, 497953, 516472, 520205, 523802, 523819, 523822, 525784, 528282, 530499, 531067, 531117, 531136, 531144, 531205, 531247, 532745, 532762, 540573, 542907, 544840, 552511, 554805, 560176, 560189, 561296, 564675, 565541, 569096, 571005, 571834, 574371, 589048, 590493, 590884, 591416, 599856, 600029, 600321, 600837, 601595, 601924, 608416, 608560, 615818, 620001, 621330, 621946, 630764, 632571, 632599, 632659, 633770, 633793, 637413, 641698, 642025, 642662, 643027, 644986, 646029, 646771, 648816, 666895, 676428, 695124, 703833, 810109);

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
  391386
  412189
  435792
  472524
  488398
  492733
  497953
  516472
  520205
  523802
  523819
  523822
  525784
  528282
  530499
  531067
  531117
  531136
  531144
  531205
  531247
  532745
  532762
  540573
  542907
  544840
  552511
  554805
  560176
  560189
  561296
  564675
  565541
  569096
  571005
  571834
  574371
  589048
  590493
  590884
  591416
  599856
  600029
  600321
  600837
  601595
  601924
  608416
  608560
  615818
  620001
  621330
  621946
  630764
  632571
  632599
  632659
  633770
  633793
  637413
  641698
  642025
  642662
  643027
  644986
  646029
  646771
  648816
  666895
  676428
  695124
  703833
  810109
]

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 (391386, 412189, 435792, 472524, 488398, 492733, 497953, 516472, 520205, 523802, 523819, 523822, 525784, 528282, 530499, 531067, 531117, 531136, 531144, 531205, 531247, 532745, 532762, 540573, 542907, 544840, 552511, 554805, 560176, 560189, 561296, 564675, 565541, 569096, 571005, 571834, 574371, 589048, 590493, 590884, 591416, 599856, 600029, 600321, 600837, 601595, 601924, 608416, 608560, 615818, 620001, 621330, 621946, 630764, 632571, 632599, 632659, 633770, 633793, 637413, 641698, 642025, 642662, 643027, 644986, 646029, 646771, 648816, 666895, 676428, 695124, 703833, 810109);

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

[
  "большие сиськ facial"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большие сиськ facial';

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

[
  "большие сиськ facial"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большие сиськ facial';