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

[
  "teen girls nude"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen girls nude' 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
  825403
  671102
  758943
  660269
  820806
  538599
  790384
  408842
  724206
  527499
  671098
  528985
  692001
  515524
  814160
  527550
  389205
  527504
  737908
  528945
  528951
  527523
  528990
  597825
  527516
  534361
  582348
  516035
  528950
  677338
  528970
  560757
  596255
  549999
  542029
  457043
  669668
  534335
  564771
  527490
  459496
  529011
  527538
  622346
  383159
  524704
  534344
  527522
  542002
  597590
  449687
  679378
  532550
  671817
  597284
  445680
  429155
  679355
  505033
  387480
  458302
  529934
  492533
  463619
  527560
  490608
  687158
  523280
  598040
  563388
  680100
  573212
]

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 (825403, 671102, 758943, 660269, 820806, 538599, 790384, 408842, 724206, 527499, 671098, 528985, 692001, 515524, 814160, 527550, 389205, 527504, 737908, 528945, 528951, 527523, 528990, 597825, 527516, 534361, 582348, 516035, 528950, 677338, 528970, 560757, 596255, 549999, 542029, 457043, 669668, 534335, 564771, 527490, 459496, 529011, 527538, 622346, 383159, 524704, 534344, 527522, 542002, 597590, 449687, 679378, 532550, 671817, 597284, 445680, 429155, 679355, 505033, 387480, 458302, 529934, 492533, 463619, 527560, 490608, 687158, 523280, 598040, 563388, 680100, 573212);

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
  383159
  387480
  389205
  408842
  429155
  445680
  449687
  457043
  458302
  459496
  463619
  490608
  492533
  505033
  515524
  516035
  523280
  524704
  527490
  527499
  527504
  527516
  527522
  527523
  527538
  527550
  527560
  528945
  528950
  528951
  528970
  528985
  528990
  529011
  529934
  532550
  534335
  534344
  534361
  538599
  542002
  542029
  549999
  560757
  563388
  564771
  573212
  582348
  596255
  597284
  597590
  597825
  598040
  622346
  660269
  669668
  671098
  671102
  671817
  677338
  679355
  679378
  680100
  687158
  692001
  724206
  737908
  758943
  790384
  814160
  820806
  825403
]

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 (383159, 387480, 389205, 408842, 429155, 445680, 449687, 457043, 458302, 459496, 463619, 490608, 492533, 505033, 515524, 516035, 523280, 524704, 527490, 527499, 527504, 527516, 527522, 527523, 527538, 527550, 527560, 528945, 528950, 528951, 528970, 528985, 528990, 529011, 529934, 532550, 534335, 534344, 534361, 538599, 542002, 542029, 549999, 560757, 563388, 564771, 573212, 582348, 596255, 597284, 597590, 597825, 598040, 622346, 660269, 669668, 671098, 671102, 671817, 677338, 679355, 679378, 680100, 687158, 692001, 724206, 737908, 758943, 790384, 814160, 820806, 825403);

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
  383159
  387480
  389205
  408842
  429155
  445680
  449687
  457043
  458302
  459496
  463619
  490608
  492533
  505033
  515524
  516035
  523280
  524704
  527490
  527499
  527504
  527516
  527522
  527523
  527538
  527550
  527560
  528945
  528950
  528951
  528970
  528985
  528990
  529011
  529934
  532550
  534335
  534344
  534361
  538599
  542002
  542029
  549999
  560757
  563388
  564771
  573212
  582348
  596255
  597284
  597590
  597825
  598040
  622346
  660269
  669668
  671098
  671102
  671817
  677338
  679355
  679378
  680100
  687158
  692001
  724206
  737908
  758943
  790384
  814160
  820806
  825403
]

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 (383159, 387480, 389205, 408842, 429155, 445680, 449687, 457043, 458302, 459496, 463619, 490608, 492533, 505033, 515524, 516035, 523280, 524704, 527490, 527499, 527504, 527516, 527522, 527523, 527538, 527550, 527560, 528945, 528950, 528951, 528970, 528985, 528990, 529011, 529934, 532550, 534335, 534344, 534361, 538599, 542002, 542029, 549999, 560757, 563388, 564771, 573212, 582348, 596255, 597284, 597590, 597825, 598040, 622346, 660269, 669668, 671098, 671102, 671817, 677338, 679355, 679378, 680100, 687158, 692001, 724206, 737908, 758943, 790384, 814160, 820806, 825403);

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

[
  "teen девушк nude"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen девушк nude';

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

[
  "teen девушк nude"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen девушк nude';

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 ?

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