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

[
  "bbw cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbw cock' 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
  458974
  463152
  400849
  400993
  398949
  444940
  454563
  511086
  488439
  490467
  509842
  491164
  527424
  527885
  554770
  445792
  491771
  515555
  523169
  527415
  537098
  494282
  502841
  524903
  464359
  489868
  675515
  678764
  666784
  562030
  571823
  599631
  600401
  617659
  456720
  464985
  447942
  476015
  446964
  504864
  526746
  491878
  519469
  520666
  485690
  453203
  454968
  496554
  494291
  524895
  549754
  564244
  662896
  663421
  716811
  763136
  474923
  515986
  525701
  453183
  494285
  554182
  589290
  603205
  592979
  390204
  514582
  520413
  583371
  427543
  566787
  650806
  698124
  584049
  603672
  529390
]

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 (458974, 463152, 400849, 400993, 398949, 444940, 454563, 511086, 488439, 490467, 509842, 491164, 527424, 527885, 554770, 445792, 491771, 515555, 523169, 527415, 537098, 494282, 502841, 524903, 464359, 489868, 675515, 678764, 666784, 562030, 571823, 599631, 600401, 617659, 456720, 464985, 447942, 476015, 446964, 504864, 526746, 491878, 519469, 520666, 485690, 453203, 454968, 496554, 494291, 524895, 549754, 564244, 662896, 663421, 716811, 763136, 474923, 515986, 525701, 453183, 494285, 554182, 589290, 603205, 592979, 390204, 514582, 520413, 583371, 427543, 566787, 650806, 698124, 584049, 603672, 529390);

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
  390204
  398949
  400849
  400993
  427543
  444940
  445792
  446964
  447942
  453183
  453203
  454563
  454968
  456720
  458974
  463152
  464359
  464985
  474923
  476015
  485690
  488439
  489868
  490467
  491164
  491771
  491878
  494282
  494285
  494291
  496554
  502841
  504864
  509842
  511086
  514582
  515555
  515986
  519469
  520413
  520666
  523169
  524895
  524903
  525701
  526746
  527415
  527424
  527885
  529390
  537098
  549754
  554182
  554770
  562030
  564244
  566787
  571823
  583371
  584049
  589290
  592979
  599631
  600401
  603205
  603672
  617659
  650806
  662896
  663421
  666784
  675515
  678764
  698124
  716811
  763136
]

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 (390204, 398949, 400849, 400993, 427543, 444940, 445792, 446964, 447942, 453183, 453203, 454563, 454968, 456720, 458974, 463152, 464359, 464985, 474923, 476015, 485690, 488439, 489868, 490467, 491164, 491771, 491878, 494282, 494285, 494291, 496554, 502841, 504864, 509842, 511086, 514582, 515555, 515986, 519469, 520413, 520666, 523169, 524895, 524903, 525701, 526746, 527415, 527424, 527885, 529390, 537098, 549754, 554182, 554770, 562030, 564244, 566787, 571823, 583371, 584049, 589290, 592979, 599631, 600401, 603205, 603672, 617659, 650806, 662896, 663421, 666784, 675515, 678764, 698124, 716811, 763136);

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
  390204
  398949
  400849
  400993
  427543
  444940
  445792
  446964
  447942
  453183
  453203
  454563
  454968
  456720
  458974
  463152
  464359
  464985
  474923
  476015
  485690
  488439
  489868
  490467
  491164
  491771
  491878
  494282
  494285
  494291
  496554
  502841
  504864
  509842
  511086
  514582
  515555
  515986
  519469
  520413
  520666
  523169
  524895
  524903
  525701
  526746
  527415
  527424
  527885
  529390
  537098
  549754
  554182
  554770
  562030
  564244
  566787
  571823
  583371
  584049
  589290
  592979
  599631
  600401
  603205
  603672
  617659
  650806
  662896
  663421
  666784
  675515
  678764
  698124
  716811
  763136
]

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 (390204, 398949, 400849, 400993, 427543, 444940, 445792, 446964, 447942, 453183, 453203, 454563, 454968, 456720, 458974, 463152, 464359, 464985, 474923, 476015, 485690, 488439, 489868, 490467, 491164, 491771, 491878, 494282, 494285, 494291, 496554, 502841, 504864, 509842, 511086, 514582, 515555, 515986, 519469, 520413, 520666, 523169, 524895, 524903, 525701, 526746, 527415, 527424, 527885, 529390, 537098, 549754, 554182, 554770, 562030, 564244, 566787, 571823, 583371, 584049, 589290, 592979, 599631, 600401, 603205, 603672, 617659, 650806, 662896, 663421, 666784, 675515, 678764, 698124, 716811, 763136);

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

[
  "bbw cock"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbw cock';

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

[
  "bbw cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbw cock';