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

[
  "sucking pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sucking pussy' 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
  565376
  575133
  561364
  565947
  707280
  649991
  655456
  699611
  661286
  601213
  587506
  595639
  597666
  614065
  595863
  762400
  726475
  407687
  419625
  451813
  438364
  47606
  415834
  443801
  445475
  454917
  470443
  508140
  495469
  407136
  419587
  454649
  457045
  475183
  477831
  562362
  569312
  684704
  697006
  677020
  633818
  639253
  586622
  436776
  472792
  447935
  443107
  468836
  501713
  506436
  510079
  515137
  495682
  535960
  548606
  562106
  716882
  595011
  601027
  745042
  421580
  429162
  490198
  474509
  623150
  628399
  726589
  510588
  528003
  526353
  630771
  600837
  569686
  405272
  514997
  556524
  553056
  513047
]

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 (565376, 575133, 561364, 565947, 707280, 649991, 655456, 699611, 661286, 601213, 587506, 595639, 597666, 614065, 595863, 762400, 726475, 407687, 419625, 451813, 438364, 47606, 415834, 443801, 445475, 454917, 470443, 508140, 495469, 407136, 419587, 454649, 457045, 475183, 477831, 562362, 569312, 684704, 697006, 677020, 633818, 639253, 586622, 436776, 472792, 447935, 443107, 468836, 501713, 506436, 510079, 515137, 495682, 535960, 548606, 562106, 716882, 595011, 601027, 745042, 421580, 429162, 490198, 474509, 623150, 628399, 726589, 510588, 528003, 526353, 630771, 600837, 569686, 405272, 514997, 556524, 553056, 513047);

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
  47606
  405272
  407136
  407687
  415834
  419587
  419625
  421580
  429162
  436776
  438364
  443107
  443801
  445475
  447935
  451813
  454649
  454917
  457045
  468836
  470443
  472792
  474509
  475183
  477831
  490198
  495469
  495682
  501713
  506436
  508140
  510079
  510588
  513047
  514997
  515137
  526353
  528003
  535960
  548606
  553056
  556524
  561364
  562106
  562362
  565376
  565947
  569312
  569686
  575133
  586622
  587506
  595011
  595639
  595863
  597666
  600837
  601027
  601213
  614065
  623150
  628399
  630771
  633818
  639253
  649991
  655456
  661286
  677020
  684704
  697006
  699611
  707280
  716882
  726475
  726589
  745042
  762400
]

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 (47606, 405272, 407136, 407687, 415834, 419587, 419625, 421580, 429162, 436776, 438364, 443107, 443801, 445475, 447935, 451813, 454649, 454917, 457045, 468836, 470443, 472792, 474509, 475183, 477831, 490198, 495469, 495682, 501713, 506436, 508140, 510079, 510588, 513047, 514997, 515137, 526353, 528003, 535960, 548606, 553056, 556524, 561364, 562106, 562362, 565376, 565947, 569312, 569686, 575133, 586622, 587506, 595011, 595639, 595863, 597666, 600837, 601027, 601213, 614065, 623150, 628399, 630771, 633818, 639253, 649991, 655456, 661286, 677020, 684704, 697006, 699611, 707280, 716882, 726475, 726589, 745042, 762400);

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
  47606
  405272
  407136
  407687
  415834
  419587
  419625
  421580
  429162
  436776
  438364
  443107
  443801
  445475
  447935
  451813
  454649
  454917
  457045
  468836
  470443
  472792
  474509
  475183
  477831
  490198
  495469
  495682
  501713
  506436
  508140
  510079
  510588
  513047
  514997
  515137
  526353
  528003
  535960
  548606
  553056
  556524
  561364
  562106
  562362
  565376
  565947
  569312
  569686
  575133
  586622
  587506
  595011
  595639
  595863
  597666
  600837
  601027
  601213
  614065
  623150
  628399
  630771
  633818
  639253
  649991
  655456
  661286
  677020
  684704
  697006
  699611
  707280
  716882
  726475
  726589
  745042
  762400
]

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 (47606, 405272, 407136, 407687, 415834, 419587, 419625, 421580, 429162, 436776, 438364, 443107, 443801, 445475, 447935, 451813, 454649, 454917, 457045, 468836, 470443, 472792, 474509, 475183, 477831, 490198, 495469, 495682, 501713, 506436, 508140, 510079, 510588, 513047, 514997, 515137, 526353, 528003, 535960, 548606, 553056, 556524, 561364, 562106, 562362, 565376, 565947, 569312, 569686, 575133, 586622, 587506, 595011, 595639, 595863, 597666, 600837, 601027, 601213, 614065, 623150, 628399, 630771, 633818, 639253, 649991, 655456, 661286, 677020, 684704, 697006, 699611, 707280, 716882, 726475, 726589, 745042, 762400);

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

[
  "sucking pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'sucking pussy';

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

[
  "sucking pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sucking pussy';