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

[
  "hot boy mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot boy 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
  418967
  814859
  448687
  471171
  513901
  541239
  550841
  553013
  556006
  571241
  591306
  601103
  593534
  643523
  724493
  606888
  409506
  419475
  475984
  524560
  527232
  514768
  519346
  484398
  496903
  520851
  518304
  528157
  474147
  524141
  508860
  523335
  453313
  571016
  487717
  486678
  494764
  486870
  488724
  521381
  535369
  558762
  571434
  650849
  590288
  446173
  451259
  427832
  472829
  517564
  528181
  509033
  522759
  814901
  529212
  584703
  676088
  563787
  512927
  529271
  520354
  424527
  432751
  536584
  609953
  590993
  491804
  537789
  523027
  517092
  526104
  565783
  591135
  614745
  624226
  523360
]

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 (418967, 814859, 448687, 471171, 513901, 541239, 550841, 553013, 556006, 571241, 591306, 601103, 593534, 643523, 724493, 606888, 409506, 419475, 475984, 524560, 527232, 514768, 519346, 484398, 496903, 520851, 518304, 528157, 474147, 524141, 508860, 523335, 453313, 571016, 487717, 486678, 494764, 486870, 488724, 521381, 535369, 558762, 571434, 650849, 590288, 446173, 451259, 427832, 472829, 517564, 528181, 509033, 522759, 814901, 529212, 584703, 676088, 563787, 512927, 529271, 520354, 424527, 432751, 536584, 609953, 590993, 491804, 537789, 523027, 517092, 526104, 565783, 591135, 614745, 624226, 523360);

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
  409506
  418967
  419475
  424527
  427832
  432751
  446173
  448687
  451259
  453313
  471171
  472829
  474147
  475984
  484398
  486678
  486870
  487717
  488724
  491804
  494764
  496903
  508860
  509033
  512927
  513901
  514768
  517092
  517564
  518304
  519346
  520354
  520851
  521381
  522759
  523027
  523335
  523360
  524141
  524560
  526104
  527232
  528157
  528181
  529212
  529271
  535369
  536584
  537789
  541239
  550841
  553013
  556006
  558762
  563787
  565783
  571016
  571241
  571434
  584703
  590288
  590993
  591135
  591306
  593534
  601103
  606888
  609953
  614745
  624226
  643523
  650849
  676088
  724493
  814859
  814901
]

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 (409506, 418967, 419475, 424527, 427832, 432751, 446173, 448687, 451259, 453313, 471171, 472829, 474147, 475984, 484398, 486678, 486870, 487717, 488724, 491804, 494764, 496903, 508860, 509033, 512927, 513901, 514768, 517092, 517564, 518304, 519346, 520354, 520851, 521381, 522759, 523027, 523335, 523360, 524141, 524560, 526104, 527232, 528157, 528181, 529212, 529271, 535369, 536584, 537789, 541239, 550841, 553013, 556006, 558762, 563787, 565783, 571016, 571241, 571434, 584703, 590288, 590993, 591135, 591306, 593534, 601103, 606888, 609953, 614745, 624226, 643523, 650849, 676088, 724493, 814859, 814901);

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
  409506
  418967
  419475
  424527
  427832
  432751
  446173
  448687
  451259
  453313
  471171
  472829
  474147
  475984
  484398
  486678
  486870
  487717
  488724
  491804
  494764
  496903
  508860
  509033
  512927
  513901
  514768
  517092
  517564
  518304
  519346
  520354
  520851
  521381
  522759
  523027
  523335
  523360
  524141
  524560
  526104
  527232
  528157
  528181
  529212
  529271
  535369
  536584
  537789
  541239
  550841
  553013
  556006
  558762
  563787
  565783
  571016
  571241
  571434
  584703
  590288
  590993
  591135
  591306
  593534
  601103
  606888
  609953
  614745
  624226
  643523
  650849
  676088
  724493
  814859
  814901
]

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 (409506, 418967, 419475, 424527, 427832, 432751, 446173, 448687, 451259, 453313, 471171, 472829, 474147, 475984, 484398, 486678, 486870, 487717, 488724, 491804, 494764, 496903, 508860, 509033, 512927, 513901, 514768, 517092, 517564, 518304, 519346, 520354, 520851, 521381, 522759, 523027, 523335, 523360, 524141, 524560, 526104, 527232, 528157, 528181, 529212, 529271, 535369, 536584, 537789, 541239, 550841, 553013, 556006, 558762, 563787, 565783, 571016, 571241, 571434, 584703, 590288, 590993, 591135, 591306, 593534, 601103, 606888, 609953, 614745, 624226, 643523, 650849, 676088, 724493, 814859, 814901);

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

[
  "hot парен mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'hot парен mom';

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

[
  "hot парен mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot парен mom';