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

[
  "milf amateur cumshot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf amateur cumshot' 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
  421880
  461066
  421593
  434741
  434792
  453499
  516490
  511079
  516496
  495326
  504908
  606377
  493402
  419979
  475780
  453342
  464372
  517752
  551579
  555968
  565013
  668668
  590720
  598420
  422176
  472559
  503385
  539955
  421603
  454397
  460744
  439691
  424214
  427166
  439706
  456028
  524371
  496903
  540794
  507682
  510877
  427543
  514459
  426458
  526330
  524926
  587229
  422154
  439815
  422205
  453683
  486870
  508425
  584013
  435917
  509983
  527295
  577711
  439641
  589290
  440990
  525129
  523816
  620757
  574416
  626136
  507512
  513338
  625441
  621160
  579754
  698124
  601485
  609795
  593596
  504693
]

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 (421880, 461066, 421593, 434741, 434792, 453499, 516490, 511079, 516496, 495326, 504908, 606377, 493402, 419979, 475780, 453342, 464372, 517752, 551579, 555968, 565013, 668668, 590720, 598420, 422176, 472559, 503385, 539955, 421603, 454397, 460744, 439691, 424214, 427166, 439706, 456028, 524371, 496903, 540794, 507682, 510877, 427543, 514459, 426458, 526330, 524926, 587229, 422154, 439815, 422205, 453683, 486870, 508425, 584013, 435917, 509983, 527295, 577711, 439641, 589290, 440990, 525129, 523816, 620757, 574416, 626136, 507512, 513338, 625441, 621160, 579754, 698124, 601485, 609795, 593596, 504693);

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
  419979
  421593
  421603
  421880
  422154
  422176
  422205
  424214
  426458
  427166
  427543
  434741
  434792
  435917
  439641
  439691
  439706
  439815
  440990
  453342
  453499
  453683
  454397
  456028
  460744
  461066
  464372
  472559
  475780
  486870
  493402
  495326
  496903
  503385
  504693
  504908
  507512
  507682
  508425
  509983
  510877
  511079
  513338
  514459
  516490
  516496
  517752
  523816
  524371
  524926
  525129
  526330
  527295
  539955
  540794
  551579
  555968
  565013
  574416
  577711
  579754
  584013
  587229
  589290
  590720
  593596
  598420
  601485
  606377
  609795
  620757
  621160
  625441
  626136
  668668
  698124
]

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 (419979, 421593, 421603, 421880, 422154, 422176, 422205, 424214, 426458, 427166, 427543, 434741, 434792, 435917, 439641, 439691, 439706, 439815, 440990, 453342, 453499, 453683, 454397, 456028, 460744, 461066, 464372, 472559, 475780, 486870, 493402, 495326, 496903, 503385, 504693, 504908, 507512, 507682, 508425, 509983, 510877, 511079, 513338, 514459, 516490, 516496, 517752, 523816, 524371, 524926, 525129, 526330, 527295, 539955, 540794, 551579, 555968, 565013, 574416, 577711, 579754, 584013, 587229, 589290, 590720, 593596, 598420, 601485, 606377, 609795, 620757, 621160, 625441, 626136, 668668, 698124);

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
  419979
  421593
  421603
  421880
  422154
  422176
  422205
  424214
  426458
  427166
  427543
  434741
  434792
  435917
  439641
  439691
  439706
  439815
  440990
  453342
  453499
  453683
  454397
  456028
  460744
  461066
  464372
  472559
  475780
  486870
  493402
  495326
  496903
  503385
  504693
  504908
  507512
  507682
  508425
  509983
  510877
  511079
  513338
  514459
  516490
  516496
  517752
  523816
  524371
  524926
  525129
  526330
  527295
  539955
  540794
  551579
  555968
  565013
  574416
  577711
  579754
  584013
  587229
  589290
  590720
  593596
  598420
  601485
  606377
  609795
  620757
  621160
  625441
  626136
  668668
  698124
]

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 (419979, 421593, 421603, 421880, 422154, 422176, 422205, 424214, 426458, 427166, 427543, 434741, 434792, 435917, 439641, 439691, 439706, 439815, 440990, 453342, 453499, 453683, 454397, 456028, 460744, 461066, 464372, 472559, 475780, 486870, 493402, 495326, 496903, 503385, 504693, 504908, 507512, 507682, 508425, 509983, 510877, 511079, 513338, 514459, 516490, 516496, 517752, 523816, 524371, 524926, 525129, 526330, 527295, 539955, 540794, 551579, 555968, 565013, 574416, 577711, 579754, 584013, 587229, 589290, 590720, 593596, 598420, 601485, 606377, 609795, 620757, 621160, 625441, 626136, 668668, 698124);

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

[
  "milf любительск cumshot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf любительск cumshot';

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

[
  "milf любительск cumshot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf любительск cumshot';