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

[
  "стройная брюнетка в чулках"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'стройная брюнетка в чулках' 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
  786405
  487133
  79683
  387080
  202901
  397852
  343350
  469007
  457808
  593104
  403140
  705136
  715448
  425470
  403843
  391106
  396045
  449264
  428616
  389570
  420048
  422654
  474360
  395377
  451096
  325984
  441560
  449271
  769796
  500585
  95788
  386103
  423225
  422529
  446308
  461932
  406522
  382075
  448050
  477759
  488663
  396091
  486758
  520487
  522077
  470311
  475924
  411433
  492822
  523862
  450808
  491944
  435959
  766016
  414604
  458935
  512873
  637147
  423394
  457165
  452061
  425332
  618787
  487911
  482916
  418139
  466963
]

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 (786405, 487133, 79683, 387080, 202901, 397852, 343350, 469007, 457808, 593104, 403140, 705136, 715448, 425470, 403843, 391106, 396045, 449264, 428616, 389570, 420048, 422654, 474360, 395377, 451096, 325984, 441560, 449271, 769796, 500585, 95788, 386103, 423225, 422529, 446308, 461932, 406522, 382075, 448050, 477759, 488663, 396091, 486758, 520487, 522077, 470311, 475924, 411433, 492822, 523862, 450808, 491944, 435959, 766016, 414604, 458935, 512873, 637147, 423394, 457165, 452061, 425332, 618787, 487911, 482916, 418139, 466963);

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
  79683
  95788
  202901
  325984
  343350
  382075
  386103
  387080
  389570
  391106
  395377
  396045
  396091
  397852
  403140
  403843
  406522
  411433
  414604
  418139
  420048
  422529
  422654
  423225
  423394
  425332
  425470
  428616
  435959
  441560
  446308
  448050
  449264
  449271
  450808
  451096
  452061
  457165
  457808
  458935
  461932
  466963
  469007
  470311
  474360
  475924
  477759
  482916
  486758
  487133
  487911
  488663
  491944
  492822
  500585
  512873
  520487
  522077
  523862
  593104
  618787
  637147
  705136
  715448
  766016
  769796
  786405
]

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 (79683, 95788, 202901, 325984, 343350, 382075, 386103, 387080, 389570, 391106, 395377, 396045, 396091, 397852, 403140, 403843, 406522, 411433, 414604, 418139, 420048, 422529, 422654, 423225, 423394, 425332, 425470, 428616, 435959, 441560, 446308, 448050, 449264, 449271, 450808, 451096, 452061, 457165, 457808, 458935, 461932, 466963, 469007, 470311, 474360, 475924, 477759, 482916, 486758, 487133, 487911, 488663, 491944, 492822, 500585, 512873, 520487, 522077, 523862, 593104, 618787, 637147, 705136, 715448, 766016, 769796, 786405);

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
  79683
  95788
  202901
  325984
  343350
  382075
  386103
  387080
  389570
  391106
  395377
  396045
  396091
  397852
  403140
  403843
  406522
  411433
  414604
  418139
  420048
  422529
  422654
  423225
  423394
  425332
  425470
  428616
  435959
  441560
  446308
  448050
  449264
  449271
  450808
  451096
  452061
  457165
  457808
  458935
  461932
  466963
  469007
  470311
  474360
  475924
  477759
  482916
  486758
  487133
  487911
  488663
  491944
  492822
  500585
  512873
  520487
  522077
  523862
  593104
  618787
  637147
  705136
  715448
  766016
  769796
  786405
]

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 (79683, 95788, 202901, 325984, 343350, 382075, 386103, 387080, 389570, 391106, 395377, 396045, 396091, 397852, 403140, 403843, 406522, 411433, 414604, 418139, 420048, 422529, 422654, 423225, 423394, 425332, 425470, 428616, 435959, 441560, 446308, 448050, 449264, 449271, 450808, 451096, 452061, 457165, 457808, 458935, 461932, 466963, 469007, 470311, 474360, 475924, 477759, 482916, 486758, 487133, 487911, 488663, 491944, 492822, 500585, 512873, 520487, 522077, 523862, 593104, 618787, 637147, 705136, 715448, 766016, 769796, 786405);

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

[
  "стройная черноволосая чулк нижн бел"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'стройная черноволосая чулк нижн бел';

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

[
  "стройная черноволосая чулк нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'стройная черноволосая чулк нижн бел';

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 ?

[
  "стройная брюнетка в чулках"
  "стройная брюнетка в чулках"
  "стройная брюнетка в чулках"
  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 ('стройная брюнетка в чулках') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('стройная брюнетка в чулках')
              AND `query` <> 'стройная брюнетка в чулках'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;