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

[
  "anal granny panties"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal granny 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
  450122
  447745
  450165
  518875
  547029
  744210
  770139
  776312
  469420
  817963
  713193
  788978
  189743
  803019
  549228
  545964
  563164
  592945
  387951
  489323
  187789
  547523
  811013
  650614
  678767
  388712
  545982
  390567
  466986
  567424
  742849
  678805
  420178
  453074
  810770
  452936
  500459
  523563
  549255
  518858
  810775
  409408
  485711
  531534
  484624
  678794
  776217
  746162
  476239
  549233
  522616
  514436
  515693
  496346
  574384
  580340
  466979
  487347
  578823
  466989
  452637
  476246
  677976
  483355
  388719
  559377
  454526
  486483
  522619
  587987
  474125
  550434
]

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 (450122, 447745, 450165, 518875, 547029, 744210, 770139, 776312, 469420, 817963, 713193, 788978, 189743, 803019, 549228, 545964, 563164, 592945, 387951, 489323, 187789, 547523, 811013, 650614, 678767, 388712, 545982, 390567, 466986, 567424, 742849, 678805, 420178, 453074, 810770, 452936, 500459, 523563, 549255, 518858, 810775, 409408, 485711, 531534, 484624, 678794, 776217, 746162, 476239, 549233, 522616, 514436, 515693, 496346, 574384, 580340, 466979, 487347, 578823, 466989, 452637, 476246, 677976, 483355, 388719, 559377, 454526, 486483, 522619, 587987, 474125, 550434);

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
  187789
  189743
  387951
  388712
  388719
  390567
  409408
  420178
  447745
  450122
  450165
  452637
  452936
  453074
  454526
  466979
  466986
  466989
  469420
  474125
  476239
  476246
  483355
  484624
  485711
  486483
  487347
  489323
  496346
  500459
  514436
  515693
  518858
  518875
  522616
  522619
  523563
  531534
  545964
  545982
  547029
  547523
  549228
  549233
  549255
  550434
  559377
  563164
  567424
  574384
  578823
  580340
  587987
  592945
  650614
  677976
  678767
  678794
  678805
  713193
  742849
  744210
  746162
  770139
  776217
  776312
  788978
  803019
  810770
  810775
  811013
  817963
]

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 (187789, 189743, 387951, 388712, 388719, 390567, 409408, 420178, 447745, 450122, 450165, 452637, 452936, 453074, 454526, 466979, 466986, 466989, 469420, 474125, 476239, 476246, 483355, 484624, 485711, 486483, 487347, 489323, 496346, 500459, 514436, 515693, 518858, 518875, 522616, 522619, 523563, 531534, 545964, 545982, 547029, 547523, 549228, 549233, 549255, 550434, 559377, 563164, 567424, 574384, 578823, 580340, 587987, 592945, 650614, 677976, 678767, 678794, 678805, 713193, 742849, 744210, 746162, 770139, 776217, 776312, 788978, 803019, 810770, 810775, 811013, 817963);

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
  187789
  189743
  387951
  388712
  388719
  390567
  409408
  420178
  447745
  450122
  450165
  452637
  452936
  453074
  454526
  466979
  466986
  466989
  469420
  474125
  476239
  476246
  483355
  484624
  485711
  486483
  487347
  489323
  496346
  500459
  514436
  515693
  518858
  518875
  522616
  522619
  523563
  531534
  545964
  545982
  547029
  547523
  549228
  549233
  549255
  550434
  559377
  563164
  567424
  574384
  578823
  580340
  587987
  592945
  650614
  677976
  678767
  678794
  678805
  713193
  742849
  744210
  746162
  770139
  776217
  776312
  788978
  803019
  810770
  810775
  811013
  817963
]

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 (187789, 189743, 387951, 388712, 388719, 390567, 409408, 420178, 447745, 450122, 450165, 452637, 452936, 453074, 454526, 466979, 466986, 466989, 469420, 474125, 476239, 476246, 483355, 484624, 485711, 486483, 487347, 489323, 496346, 500459, 514436, 515693, 518858, 518875, 522616, 522619, 523563, 531534, 545964, 545982, 547029, 547523, 549228, 549233, 549255, 550434, 559377, 563164, 567424, 574384, 578823, 580340, 587987, 592945, 650614, 677976, 678767, 678794, 678805, 713193, 742849, 744210, 746162, 770139, 776217, 776312, 788978, 803019, 810770, 810775, 811013, 817963);

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

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

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

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

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

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

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

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

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 ?

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