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

[
  "tina anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tina 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
  714604
  636269
  716787
  545384
  740605
  404192
  625541
  570160
  675021
  396086
  431093
  674770
  7015
  805941
  800426
  743278
  685955
  771164
  815078
  815128
  733874
  743309
  778069
  771161
  505024
  625521
  532958
  649904
  587578
  625526
  402673
  495895
  635988
  676624
  666549
  632561
  602183
  525464
  625519
  674988
  540570
  411951
  765632
  674983
  676636
  559959
  600006
  632642
  825318
  401946
  815480
  823589
  43564
  513028
  408009
  396018
  705913
  665328
  489871
  820578
  406563
  410817
  452156
  815598
  468672
  456736
  689614
  482519
  559951
  644273
  482575
  242589
  416365
  391400
  478108
]

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 (714604, 636269, 716787, 545384, 740605, 404192, 625541, 570160, 675021, 396086, 431093, 674770, 7015, 805941, 800426, 743278, 685955, 771164, 815078, 815128, 733874, 743309, 778069, 771161, 505024, 625521, 532958, 649904, 587578, 625526, 402673, 495895, 635988, 676624, 666549, 632561, 602183, 525464, 625519, 674988, 540570, 411951, 765632, 674983, 676636, 559959, 600006, 632642, 825318, 401946, 815480, 823589, 43564, 513028, 408009, 396018, 705913, 665328, 489871, 820578, 406563, 410817, 452156, 815598, 468672, 456736, 689614, 482519, 559951, 644273, 482575, 242589, 416365, 391400, 478108);

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
  7015
  43564
  242589
  391400
  396018
  396086
  401946
  402673
  404192
  406563
  408009
  410817
  411951
  416365
  431093
  452156
  456736
  468672
  478108
  482519
  482575
  489871
  495895
  505024
  513028
  525464
  532958
  540570
  545384
  559951
  559959
  570160
  587578
  600006
  602183
  625519
  625521
  625526
  625541
  632561
  632642
  635988
  636269
  644273
  649904
  665328
  666549
  674770
  674983
  674988
  675021
  676624
  676636
  685955
  689614
  705913
  714604
  716787
  733874
  740605
  743278
  743309
  765632
  771161
  771164
  778069
  800426
  805941
  815078
  815128
  815480
  815598
  820578
  823589
  825318
]

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 (7015, 43564, 242589, 391400, 396018, 396086, 401946, 402673, 404192, 406563, 408009, 410817, 411951, 416365, 431093, 452156, 456736, 468672, 478108, 482519, 482575, 489871, 495895, 505024, 513028, 525464, 532958, 540570, 545384, 559951, 559959, 570160, 587578, 600006, 602183, 625519, 625521, 625526, 625541, 632561, 632642, 635988, 636269, 644273, 649904, 665328, 666549, 674770, 674983, 674988, 675021, 676624, 676636, 685955, 689614, 705913, 714604, 716787, 733874, 740605, 743278, 743309, 765632, 771161, 771164, 778069, 800426, 805941, 815078, 815128, 815480, 815598, 820578, 823589, 825318);

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
  7015
  43564
  242589
  391400
  396018
  396086
  401946
  402673
  404192
  406563
  408009
  410817
  411951
  416365
  431093
  452156
  456736
  468672
  478108
  482519
  482575
  489871
  495895
  505024
  513028
  525464
  532958
  540570
  545384
  559951
  559959
  570160
  587578
  600006
  602183
  625519
  625521
  625526
  625541
  632561
  632642
  635988
  636269
  644273
  649904
  665328
  666549
  674770
  674983
  674988
  675021
  676624
  676636
  685955
  689614
  705913
  714604
  716787
  733874
  740605
  743278
  743309
  765632
  771161
  771164
  778069
  800426
  805941
  815078
  815128
  815480
  815598
  820578
  823589
  825318
]

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 (7015, 43564, 242589, 391400, 396018, 396086, 401946, 402673, 404192, 406563, 408009, 410817, 411951, 416365, 431093, 452156, 456736, 468672, 478108, 482519, 482575, 489871, 495895, 505024, 513028, 525464, 532958, 540570, 545384, 559951, 559959, 570160, 587578, 600006, 602183, 625519, 625521, 625526, 625541, 632561, 632642, 635988, 636269, 644273, 649904, 665328, 666549, 674770, 674983, 674988, 675021, 676624, 676636, 685955, 689614, 705913, 714604, 716787, 733874, 740605, 743278, 743309, 765632, 771161, 771164, 778069, 800426, 805941, 815078, 815128, 815480, 815598, 820578, 823589, 825318);

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

[
  "tina анал"
]

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

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

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

[
  "tina анал"
]

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

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

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 ?

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