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

[
  "cumshot anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cumshot anal' 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
  531136
  780873
  427261
  567166
  695124
  418067
  439815
  454584
  452965
  436095
  413791
  424332
  600350
  605503
  450724
  632143
  532995
  531251
  533726
  537114
  626136
  640793
  439641
  427543
  698124
  556797
  424530
  500241
  633225
  531155
  486589
  439667
  464366
  507512
  531144
  531126
  417198
  534021
  712561
  632140
  558574
  670197
  577903
  531247
  540437
  647979
  513338
  708905
  525686
  562758
  600531
  608037
  642407
  612434
  637001
  527931
  456028
  521232
  554495
  588264
  773963
  565541
  593596
  527426
  608414
  501538
  497953
  456705
  498440
  574519
  601101
  514129
  608364
  604743
]

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 (531136, 780873, 427261, 567166, 695124, 418067, 439815, 454584, 452965, 436095, 413791, 424332, 600350, 605503, 450724, 632143, 532995, 531251, 533726, 537114, 626136, 640793, 439641, 427543, 698124, 556797, 424530, 500241, 633225, 531155, 486589, 439667, 464366, 507512, 531144, 531126, 417198, 534021, 712561, 632140, 558574, 670197, 577903, 531247, 540437, 647979, 513338, 708905, 525686, 562758, 600531, 608037, 642407, 612434, 637001, 527931, 456028, 521232, 554495, 588264, 773963, 565541, 593596, 527426, 608414, 501538, 497953, 456705, 498440, 574519, 601101, 514129, 608364, 604743);

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
  413791
  417198
  418067
  424332
  424530
  427261
  427543
  436095
  439641
  439667
  439815
  450724
  452965
  454584
  456028
  456705
  464366
  486589
  497953
  498440
  500241
  501538
  507512
  513338
  514129
  521232
  525686
  527426
  527931
  531126
  531136
  531144
  531155
  531247
  531251
  532995
  533726
  534021
  537114
  540437
  554495
  556797
  558574
  562758
  565541
  567166
  574519
  577903
  588264
  593596
  600350
  600531
  601101
  604743
  605503
  608037
  608364
  608414
  612434
  626136
  632140
  632143
  633225
  637001
  640793
  642407
  647979
  670197
  695124
  698124
  708905
  712561
  773963
  780873
]

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 (413791, 417198, 418067, 424332, 424530, 427261, 427543, 436095, 439641, 439667, 439815, 450724, 452965, 454584, 456028, 456705, 464366, 486589, 497953, 498440, 500241, 501538, 507512, 513338, 514129, 521232, 525686, 527426, 527931, 531126, 531136, 531144, 531155, 531247, 531251, 532995, 533726, 534021, 537114, 540437, 554495, 556797, 558574, 562758, 565541, 567166, 574519, 577903, 588264, 593596, 600350, 600531, 601101, 604743, 605503, 608037, 608364, 608414, 612434, 626136, 632140, 632143, 633225, 637001, 640793, 642407, 647979, 670197, 695124, 698124, 708905, 712561, 773963, 780873);

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
  413791
  417198
  418067
  424332
  424530
  427261
  427543
  436095
  439641
  439667
  439815
  450724
  452965
  454584
  456028
  456705
  464366
  486589
  497953
  498440
  500241
  501538
  507512
  513338
  514129
  521232
  525686
  527426
  527931
  531126
  531136
  531144
  531155
  531247
  531251
  532995
  533726
  534021
  537114
  540437
  554495
  556797
  558574
  562758
  565541
  567166
  574519
  577903
  588264
  593596
  600350
  600531
  601101
  604743
  605503
  608037
  608364
  608414
  612434
  626136
  632140
  632143
  633225
  637001
  640793
  642407
  647979
  670197
  695124
  698124
  708905
  712561
  773963
  780873
]

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 (413791, 417198, 418067, 424332, 424530, 427261, 427543, 436095, 439641, 439667, 439815, 450724, 452965, 454584, 456028, 456705, 464366, 486589, 497953, 498440, 500241, 501538, 507512, 513338, 514129, 521232, 525686, 527426, 527931, 531126, 531136, 531144, 531155, 531247, 531251, 532995, 533726, 534021, 537114, 540437, 554495, 556797, 558574, 562758, 565541, 567166, 574519, 577903, 588264, 593596, 600350, 600531, 601101, 604743, 605503, 608037, 608364, 608414, 612434, 626136, 632140, 632143, 633225, 637001, 640793, 642407, 647979, 670197, 695124, 698124, 708905, 712561, 773963, 780873);

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

[
  "cumshot анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cumshot анал';

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

[
  "cumshot анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cumshot анал';

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 ?

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