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

[
  "chubby mature office"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'chubby mature office' 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
  636426
  605846
  776215
  444144
  493026
  826155
  739553
  565700
  554465
  666503
  419144
  474079
  519148
  549743
  665297
  692225
  589680
  758823
  725461
  445720
  475279
  455910
  665466
  559682
  591294
  454632
  453136
  513335
  566075
  557165
  678716
  628696
  455034
  483448
  489649
  506606
  385062
  458728
  477708
  512957
  525501
  518568
  549660
  446647
  424457
  424456
  476293
  476032
  502467
  827315
  411769
  425601
  525999
  549702
  824345
  658464
  493020
  465317
  445429
  454437
  454430
  803889
  524641
  667574
  574397
  623468
  524612
  468269
  549736
  476604
  492688
  493163
]

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 (636426, 605846, 776215, 444144, 493026, 826155, 739553, 565700, 554465, 666503, 419144, 474079, 519148, 549743, 665297, 692225, 589680, 758823, 725461, 445720, 475279, 455910, 665466, 559682, 591294, 454632, 453136, 513335, 566075, 557165, 678716, 628696, 455034, 483448, 489649, 506606, 385062, 458728, 477708, 512957, 525501, 518568, 549660, 446647, 424457, 424456, 476293, 476032, 502467, 827315, 411769, 425601, 525999, 549702, 824345, 658464, 493020, 465317, 445429, 454437, 454430, 803889, 524641, 667574, 574397, 623468, 524612, 468269, 549736, 476604, 492688, 493163);

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
  385062
  411769
  419144
  424456
  424457
  425601
  444144
  445429
  445720
  446647
  453136
  454430
  454437
  454632
  455034
  455910
  458728
  465317
  468269
  474079
  475279
  476032
  476293
  476604
  477708
  483448
  489649
  492688
  493020
  493026
  493163
  502467
  506606
  512957
  513335
  518568
  519148
  524612
  524641
  525501
  525999
  549660
  549702
  549736
  549743
  554465
  557165
  559682
  565700
  566075
  574397
  589680
  591294
  605846
  623468
  628696
  636426
  658464
  665297
  665466
  666503
  667574
  678716
  692225
  725461
  739553
  758823
  776215
  803889
  824345
  826155
  827315
]

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 (385062, 411769, 419144, 424456, 424457, 425601, 444144, 445429, 445720, 446647, 453136, 454430, 454437, 454632, 455034, 455910, 458728, 465317, 468269, 474079, 475279, 476032, 476293, 476604, 477708, 483448, 489649, 492688, 493020, 493026, 493163, 502467, 506606, 512957, 513335, 518568, 519148, 524612, 524641, 525501, 525999, 549660, 549702, 549736, 549743, 554465, 557165, 559682, 565700, 566075, 574397, 589680, 591294, 605846, 623468, 628696, 636426, 658464, 665297, 665466, 666503, 667574, 678716, 692225, 725461, 739553, 758823, 776215, 803889, 824345, 826155, 827315);

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
  385062
  411769
  419144
  424456
  424457
  425601
  444144
  445429
  445720
  446647
  453136
  454430
  454437
  454632
  455034
  455910
  458728
  465317
  468269
  474079
  475279
  476032
  476293
  476604
  477708
  483448
  489649
  492688
  493020
  493026
  493163
  502467
  506606
  512957
  513335
  518568
  519148
  524612
  524641
  525501
  525999
  549660
  549702
  549736
  549743
  554465
  557165
  559682
  565700
  566075
  574397
  589680
  591294
  605846
  623468
  628696
  636426
  658464
  665297
  665466
  666503
  667574
  678716
  692225
  725461
  739553
  758823
  776215
  803889
  824345
  826155
  827315
]

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 (385062, 411769, 419144, 424456, 424457, 425601, 444144, 445429, 445720, 446647, 453136, 454430, 454437, 454632, 455034, 455910, 458728, 465317, 468269, 474079, 475279, 476032, 476293, 476604, 477708, 483448, 489649, 492688, 493020, 493026, 493163, 502467, 506606, 512957, 513335, 518568, 519148, 524612, 524641, 525501, 525999, 549660, 549702, 549736, 549743, 554465, 557165, 559682, 565700, 566075, 574397, 589680, 591294, 605846, 623468, 628696, 636426, 658464, 665297, 665466, 666503, 667574, 678716, 692225, 725461, 739553, 758823, 776215, 803889, 824345, 826155, 827315);

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

[
  "chubby mature секретарш"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'chubby mature секретарш';

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

[
  "chubby mature секретарш"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'chubby mature секретарш';

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 ?

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