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

[
  "mother son young"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mother son young' 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
  470762
  486533
  474784
  416857
  439671
  531996
  505822
  564173
  561456
  460751
  476271
  439633
  454271
  523907
  506044
  439518
  439558
  518858
  466003
  512516
  520870
  425347
  519931
  489330
  407414
  474800
  439534
  464438
  407379
  400181
  455206
  461018
  512539
  439696
  464564
  512541
  520878
  565983
  428895
  519589
  395721
  485462
  400249
  439718
  519037
  593150
  466133
  523356
  584739
  486540
  461016
  547612
  563446
  484554
  428533
  532682
  439544
  397530
  563218
  486198
  485265
  463215
  518960
  504927
  550960
  439564
  477890
  520881
  601851
  621655
  557537
  591314
  519023
]

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 (470762, 486533, 474784, 416857, 439671, 531996, 505822, 564173, 561456, 460751, 476271, 439633, 454271, 523907, 506044, 439518, 439558, 518858, 466003, 512516, 520870, 425347, 519931, 489330, 407414, 474800, 439534, 464438, 407379, 400181, 455206, 461018, 512539, 439696, 464564, 512541, 520878, 565983, 428895, 519589, 395721, 485462, 400249, 439718, 519037, 593150, 466133, 523356, 584739, 486540, 461016, 547612, 563446, 484554, 428533, 532682, 439544, 397530, 563218, 486198, 485265, 463215, 518960, 504927, 550960, 439564, 477890, 520881, 601851, 621655, 557537, 591314, 519023);

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
  395721
  397530
  400181
  400249
  407379
  407414
  416857
  425347
  428533
  428895
  439518
  439534
  439544
  439558
  439564
  439633
  439671
  439696
  439718
  454271
  455206
  460751
  461016
  461018
  463215
  464438
  464564
  466003
  466133
  470762
  474784
  474800
  476271
  477890
  484554
  485265
  485462
  486198
  486533
  486540
  489330
  504927
  505822
  506044
  512516
  512539
  512541
  518858
  518960
  519023
  519037
  519589
  519931
  520870
  520878
  520881
  523356
  523907
  531996
  532682
  547612
  550960
  557537
  561456
  563218
  563446
  564173
  565983
  584739
  591314
  593150
  601851
  621655
]

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 (395721, 397530, 400181, 400249, 407379, 407414, 416857, 425347, 428533, 428895, 439518, 439534, 439544, 439558, 439564, 439633, 439671, 439696, 439718, 454271, 455206, 460751, 461016, 461018, 463215, 464438, 464564, 466003, 466133, 470762, 474784, 474800, 476271, 477890, 484554, 485265, 485462, 486198, 486533, 486540, 489330, 504927, 505822, 506044, 512516, 512539, 512541, 518858, 518960, 519023, 519037, 519589, 519931, 520870, 520878, 520881, 523356, 523907, 531996, 532682, 547612, 550960, 557537, 561456, 563218, 563446, 564173, 565983, 584739, 591314, 593150, 601851, 621655);

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
  395721
  397530
  400181
  400249
  407379
  407414
  416857
  425347
  428533
  428895
  439518
  439534
  439544
  439558
  439564
  439633
  439671
  439696
  439718
  454271
  455206
  460751
  461016
  461018
  463215
  464438
  464564
  466003
  466133
  470762
  474784
  474800
  476271
  477890
  484554
  485265
  485462
  486198
  486533
  486540
  489330
  504927
  505822
  506044
  512516
  512539
  512541
  518858
  518960
  519023
  519037
  519589
  519931
  520870
  520878
  520881
  523356
  523907
  531996
  532682
  547612
  550960
  557537
  561456
  563218
  563446
  564173
  565983
  584739
  591314
  593150
  601851
  621655
]

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 (395721, 397530, 400181, 400249, 407379, 407414, 416857, 425347, 428533, 428895, 439518, 439534, 439544, 439558, 439564, 439633, 439671, 439696, 439718, 454271, 455206, 460751, 461016, 461018, 463215, 464438, 464564, 466003, 466133, 470762, 474784, 474800, 476271, 477890, 484554, 485265, 485462, 486198, 486533, 486540, 489330, 504927, 505822, 506044, 512516, 512539, 512541, 518858, 518960, 519023, 519037, 519589, 519931, 520870, 520878, 520881, 523356, 523907, 531996, 532682, 547612, 550960, 557537, 561456, 563218, 563446, 564173, 565983, 584739, 591314, 593150, 601851, 621655);

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

[
  "мам женщин son young"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'мам женщин son young';

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

[
  "мам женщин son young"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'мам женщин son young';

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 ?

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