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

[
  "micro panties"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'micro panties' 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
  549482
  434077
  812216
  797695
  785429
  759077
  827243
  585036
  585043
  783339
  538771
  752892
  775320
  539072
  820328
  585059
  812212
  405448
  576863
  590114
  751200
  601757
  434124
  585077
  434136
  427480
  531311
  710860
  434109
  434072
  662905
  798842
  539076
  434128
  413043
  585052
  584593
  550013
  798805
  469163
  434071
  614710
  802925
  810633
  810644
  827350
  434133
  434081
  413438
  458550
  434032
  469148
  541707
  804272
  434131
  556673
  487442
  434112
  533145
  434107
  434023
  704243
  434122
  661008
  458686
  434106
  487427
  434115
  434104
  458461
  576770
  434070
]

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 (549482, 434077, 812216, 797695, 785429, 759077, 827243, 585036, 585043, 783339, 538771, 752892, 775320, 539072, 820328, 585059, 812212, 405448, 576863, 590114, 751200, 601757, 434124, 585077, 434136, 427480, 531311, 710860, 434109, 434072, 662905, 798842, 539076, 434128, 413043, 585052, 584593, 550013, 798805, 469163, 434071, 614710, 802925, 810633, 810644, 827350, 434133, 434081, 413438, 458550, 434032, 469148, 541707, 804272, 434131, 556673, 487442, 434112, 533145, 434107, 434023, 704243, 434122, 661008, 458686, 434106, 487427, 434115, 434104, 458461, 576770, 434070);

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
  405448
  413043
  413438
  427480
  434023
  434032
  434070
  434071
  434072
  434077
  434081
  434104
  434106
  434107
  434109
  434112
  434115
  434122
  434124
  434128
  434131
  434133
  434136
  458461
  458550
  458686
  469148
  469163
  487427
  487442
  531311
  533145
  538771
  539072
  539076
  541707
  549482
  550013
  556673
  576770
  576863
  584593
  585036
  585043
  585052
  585059
  585077
  590114
  601757
  614710
  661008
  662905
  704243
  710860
  751200
  752892
  759077
  775320
  783339
  785429
  797695
  798805
  798842
  802925
  804272
  810633
  810644
  812212
  812216
  820328
  827243
  827350
]

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 (405448, 413043, 413438, 427480, 434023, 434032, 434070, 434071, 434072, 434077, 434081, 434104, 434106, 434107, 434109, 434112, 434115, 434122, 434124, 434128, 434131, 434133, 434136, 458461, 458550, 458686, 469148, 469163, 487427, 487442, 531311, 533145, 538771, 539072, 539076, 541707, 549482, 550013, 556673, 576770, 576863, 584593, 585036, 585043, 585052, 585059, 585077, 590114, 601757, 614710, 661008, 662905, 704243, 710860, 751200, 752892, 759077, 775320, 783339, 785429, 797695, 798805, 798842, 802925, 804272, 810633, 810644, 812212, 812216, 820328, 827243, 827350);

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
  405448
  413043
  413438
  427480
  434023
  434032
  434070
  434071
  434072
  434077
  434081
  434104
  434106
  434107
  434109
  434112
  434115
  434122
  434124
  434128
  434131
  434133
  434136
  458461
  458550
  458686
  469148
  469163
  487427
  487442
  531311
  533145
  538771
  539072
  539076
  541707
  549482
  550013
  556673
  576770
  576863
  584593
  585036
  585043
  585052
  585059
  585077
  590114
  601757
  614710
  661008
  662905
  704243
  710860
  751200
  752892
  759077
  775320
  783339
  785429
  797695
  798805
  798842
  802925
  804272
  810633
  810644
  812212
  812216
  820328
  827243
  827350
]

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 (405448, 413043, 413438, 427480, 434023, 434032, 434070, 434071, 434072, 434077, 434081, 434104, 434106, 434107, 434109, 434112, 434115, 434122, 434124, 434128, 434131, 434133, 434136, 458461, 458550, 458686, 469148, 469163, 487427, 487442, 531311, 533145, 538771, 539072, 539076, 541707, 549482, 550013, 556673, 576770, 576863, 584593, 585036, 585043, 585052, 585059, 585077, 590114, 601757, 614710, 661008, 662905, 704243, 710860, 751200, 752892, 759077, 775320, 783339, 785429, 797695, 798805, 798842, 802925, 804272, 810633, 810644, 812212, 812216, 820328, 827243, 827350);

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

[
  "micro трусик нижн бел"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'micro трусик нижн бел';

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

[
  "micro трусик нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'micro трусик нижн бел';

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 ?

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