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

[
  "blowjob kitchen asian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blowjob kitchen asian' 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
  538674
  390207
  621034
  572736
  420230
  691221
  383734
  386323
  694194
  550997
  551960
  382018
  512215
  528777
  586886
  634613
  510590
  381767
  458844
  469549
  552040
  793294
  566013
  619458
  449360
  622625
  465194
  395511
  472959
  524492
  559883
  459594
  590934
  572732
  443602
  429565
  421198
  458341
  590919
  384461
  415554
  557494
  422926
  550618
  394376
  422587
  435727
  590127
  559885
  564601
  499065
  500686
  565997
  497447
  566002
  804677
  471973
  420069
  535002
  460211
  541215
  428293
  564213
  601339
  472567
  668451
  556405
  609933
  496569
  468666
  541885
  503043
]

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 (538674, 390207, 621034, 572736, 420230, 691221, 383734, 386323, 694194, 550997, 551960, 382018, 512215, 528777, 586886, 634613, 510590, 381767, 458844, 469549, 552040, 793294, 566013, 619458, 449360, 622625, 465194, 395511, 472959, 524492, 559883, 459594, 590934, 572732, 443602, 429565, 421198, 458341, 590919, 384461, 415554, 557494, 422926, 550618, 394376, 422587, 435727, 590127, 559885, 564601, 499065, 500686, 565997, 497447, 566002, 804677, 471973, 420069, 535002, 460211, 541215, 428293, 564213, 601339, 472567, 668451, 556405, 609933, 496569, 468666, 541885, 503043);

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
  381767
  382018
  383734
  384461
  386323
  390207
  394376
  395511
  415554
  420069
  420230
  421198
  422587
  422926
  428293
  429565
  435727
  443602
  449360
  458341
  458844
  459594
  460211
  465194
  468666
  469549
  471973
  472567
  472959
  496569
  497447
  499065
  500686
  503043
  510590
  512215
  524492
  528777
  535002
  538674
  541215
  541885
  550618
  550997
  551960
  552040
  556405
  557494
  559883
  559885
  564213
  564601
  565997
  566002
  566013
  572732
  572736
  586886
  590127
  590919
  590934
  601339
  609933
  619458
  621034
  622625
  634613
  668451
  691221
  694194
  793294
  804677
]

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 (381767, 382018, 383734, 384461, 386323, 390207, 394376, 395511, 415554, 420069, 420230, 421198, 422587, 422926, 428293, 429565, 435727, 443602, 449360, 458341, 458844, 459594, 460211, 465194, 468666, 469549, 471973, 472567, 472959, 496569, 497447, 499065, 500686, 503043, 510590, 512215, 524492, 528777, 535002, 538674, 541215, 541885, 550618, 550997, 551960, 552040, 556405, 557494, 559883, 559885, 564213, 564601, 565997, 566002, 566013, 572732, 572736, 586886, 590127, 590919, 590934, 601339, 609933, 619458, 621034, 622625, 634613, 668451, 691221, 694194, 793294, 804677);

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
  381767
  382018
  383734
  384461
  386323
  390207
  394376
  395511
  415554
  420069
  420230
  421198
  422587
  422926
  428293
  429565
  435727
  443602
  449360
  458341
  458844
  459594
  460211
  465194
  468666
  469549
  471973
  472567
  472959
  496569
  497447
  499065
  500686
  503043
  510590
  512215
  524492
  528777
  535002
  538674
  541215
  541885
  550618
  550997
  551960
  552040
  556405
  557494
  559883
  559885
  564213
  564601
  565997
  566002
  566013
  572732
  572736
  586886
  590127
  590919
  590934
  601339
  609933
  619458
  621034
  622625
  634613
  668451
  691221
  694194
  793294
  804677
]

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 (381767, 382018, 383734, 384461, 386323, 390207, 394376, 395511, 415554, 420069, 420230, 421198, 422587, 422926, 428293, 429565, 435727, 443602, 449360, 458341, 458844, 459594, 460211, 465194, 468666, 469549, 471973, 472567, 472959, 496569, 497447, 499065, 500686, 503043, 510590, 512215, 524492, 528777, 535002, 538674, 541215, 541885, 550618, 550997, 551960, 552040, 556405, 557494, 559883, 559885, 564213, 564601, 565997, 566002, 566013, 572732, 572736, 586886, 590127, 590919, 590934, 601339, 609933, 619458, 621034, 622625, 634613, 668451, 691221, 694194, 793294, 804677);

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 ?

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