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

[
  "chubby step mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'chubby step mom' 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
  401214
  450814
  519480
  523832
  506131
  538002
  490427
  498492
  582269
  425967
  450794
  450829
  464866
  521365
  515956
  519895
  539346
  561505
  562598
  549825
  556806
  560400
  562604
  563225
  549840
  608437
  437314
  471780
  392754
  517075
  519151
  490414
  503154
  506044
  498491
  518864
  519512
  430313
  539744
  512541
  501529
  539951
  490916
  541239
  554445
  557124
  610660
  444703
  397369
  519346
  485037
  507245
  428756
  460281
  489979
  539351
  563450
  401916
  451492
  506278
  518852
  528083
  535109
  577290
  566110
  558176
  602672
  604419
  490409
  543579
  610588
  518040
  504693
  574384
]

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 (401214, 450814, 519480, 523832, 506131, 538002, 490427, 498492, 582269, 425967, 450794, 450829, 464866, 521365, 515956, 519895, 539346, 561505, 562598, 549825, 556806, 560400, 562604, 563225, 549840, 608437, 437314, 471780, 392754, 517075, 519151, 490414, 503154, 506044, 498491, 518864, 519512, 430313, 539744, 512541, 501529, 539951, 490916, 541239, 554445, 557124, 610660, 444703, 397369, 519346, 485037, 507245, 428756, 460281, 489979, 539351, 563450, 401916, 451492, 506278, 518852, 528083, 535109, 577290, 566110, 558176, 602672, 604419, 490409, 543579, 610588, 518040, 504693, 574384);

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
  392754
  397369
  401214
  401916
  425967
  428756
  430313
  437314
  444703
  450794
  450814
  450829
  451492
  460281
  464866
  471780
  485037
  489979
  490409
  490414
  490427
  490916
  498491
  498492
  501529
  503154
  504693
  506044
  506131
  506278
  507245
  512541
  515956
  517075
  518040
  518852
  518864
  519151
  519346
  519480
  519512
  519895
  521365
  523832
  528083
  535109
  538002
  539346
  539351
  539744
  539951
  541239
  543579
  549825
  549840
  554445
  556806
  557124
  558176
  560400
  561505
  562598
  562604
  563225
  563450
  566110
  574384
  577290
  582269
  602672
  604419
  608437
  610588
  610660
]

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 (392754, 397369, 401214, 401916, 425967, 428756, 430313, 437314, 444703, 450794, 450814, 450829, 451492, 460281, 464866, 471780, 485037, 489979, 490409, 490414, 490427, 490916, 498491, 498492, 501529, 503154, 504693, 506044, 506131, 506278, 507245, 512541, 515956, 517075, 518040, 518852, 518864, 519151, 519346, 519480, 519512, 519895, 521365, 523832, 528083, 535109, 538002, 539346, 539351, 539744, 539951, 541239, 543579, 549825, 549840, 554445, 556806, 557124, 558176, 560400, 561505, 562598, 562604, 563225, 563450, 566110, 574384, 577290, 582269, 602672, 604419, 608437, 610588, 610660);

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
  392754
  397369
  401214
  401916
  425967
  428756
  430313
  437314
  444703
  450794
  450814
  450829
  451492
  460281
  464866
  471780
  485037
  489979
  490409
  490414
  490427
  490916
  498491
  498492
  501529
  503154
  504693
  506044
  506131
  506278
  507245
  512541
  515956
  517075
  518040
  518852
  518864
  519151
  519346
  519480
  519512
  519895
  521365
  523832
  528083
  535109
  538002
  539346
  539351
  539744
  539951
  541239
  543579
  549825
  549840
  554445
  556806
  557124
  558176
  560400
  561505
  562598
  562604
  563225
  563450
  566110
  574384
  577290
  582269
  602672
  604419
  608437
  610588
  610660
]

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 (392754, 397369, 401214, 401916, 425967, 428756, 430313, 437314, 444703, 450794, 450814, 450829, 451492, 460281, 464866, 471780, 485037, 489979, 490409, 490414, 490427, 490916, 498491, 498492, 501529, 503154, 504693, 506044, 506131, 506278, 507245, 512541, 515956, 517075, 518040, 518852, 518864, 519151, 519346, 519480, 519512, 519895, 521365, 523832, 528083, 535109, 538002, 539346, 539351, 539744, 539951, 541239, 543579, 549825, 549840, 554445, 556806, 557124, 558176, 560400, 561505, 562598, 562604, 563225, 563450, 566110, 574384, 577290, 582269, 602672, 604419, 608437, 610588, 610660);

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

[
  "chubby step mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'chubby step mom';

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

[
  "chubby step mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'chubby step mom';