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

[
  "порно мамочек"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'порно мамочек' 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
  81565
  790903
  323581
  126637
  81526
  556025
  337134
  466728
  567042
  807650
  70167
  475789
  452402
  399563
  452426
  391694
  406645
  497389
  470649
  415503
  114730
  382530
  388782
  408014
  492246
  446795
  457387
  529394
  684064
  475656
  469983
  486961
  533351
  475662
  491516
  612996
  434277
  447785
  123610
  417837
  426616
  385970
  389499
  471699
  536728
  513156
  491986
  400753
  457983
  593294
  813244
  511418
  487632
  428116
  455919
  501226
  486785
  629882
  448810
  533966
  467611
  459171
  430700
  513949
  534376
  578395
  588286
  472750
  528398
  652539
]

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 (81565, 790903, 323581, 126637, 81526, 556025, 337134, 466728, 567042, 807650, 70167, 475789, 452402, 399563, 452426, 391694, 406645, 497389, 470649, 415503, 114730, 382530, 388782, 408014, 492246, 446795, 457387, 529394, 684064, 475656, 469983, 486961, 533351, 475662, 491516, 612996, 434277, 447785, 123610, 417837, 426616, 385970, 389499, 471699, 536728, 513156, 491986, 400753, 457983, 593294, 813244, 511418, 487632, 428116, 455919, 501226, 486785, 629882, 448810, 533966, 467611, 459171, 430700, 513949, 534376, 578395, 588286, 472750, 528398, 652539);

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
  70167
  81526
  81565
  114730
  123610
  126637
  323581
  337134
  382530
  385970
  388782
  389499
  391694
  399563
  400753
  406645
  408014
  415503
  417837
  426616
  428116
  430700
  434277
  446795
  447785
  448810
  452402
  452426
  455919
  457387
  457983
  459171
  466728
  467611
  469983
  470649
  471699
  472750
  475656
  475662
  475789
  486785
  486961
  487632
  491516
  491986
  492246
  497389
  501226
  511418
  513156
  513949
  528398
  529394
  533351
  533966
  534376
  536728
  556025
  567042
  578395
  588286
  593294
  612996
  629882
  652539
  684064
  790903
  807650
  813244
]

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 (70167, 81526, 81565, 114730, 123610, 126637, 323581, 337134, 382530, 385970, 388782, 389499, 391694, 399563, 400753, 406645, 408014, 415503, 417837, 426616, 428116, 430700, 434277, 446795, 447785, 448810, 452402, 452426, 455919, 457387, 457983, 459171, 466728, 467611, 469983, 470649, 471699, 472750, 475656, 475662, 475789, 486785, 486961, 487632, 491516, 491986, 492246, 497389, 501226, 511418, 513156, 513949, 528398, 529394, 533351, 533966, 534376, 536728, 556025, 567042, 578395, 588286, 593294, 612996, 629882, 652539, 684064, 790903, 807650, 813244);

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
  70167
  81526
  81565
  114730
  123610
  126637
  323581
  337134
  382530
  385970
  388782
  389499
  391694
  399563
  400753
  406645
  408014
  415503
  417837
  426616
  428116
  430700
  434277
  446795
  447785
  448810
  452402
  452426
  455919
  457387
  457983
  459171
  466728
  467611
  469983
  470649
  471699
  472750
  475656
  475662
  475789
  486785
  486961
  487632
  491516
  491986
  492246
  497389
  501226
  511418
  513156
  513949
  528398
  529394
  533351
  533966
  534376
  536728
  556025
  567042
  578395
  588286
  593294
  612996
  629882
  652539
  684064
  790903
  807650
  813244
]

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 (70167, 81526, 81565, 114730, 123610, 126637, 323581, 337134, 382530, 385970, 388782, 389499, 391694, 399563, 400753, 406645, 408014, 415503, 417837, 426616, 428116, 430700, 434277, 446795, 447785, 448810, 452402, 452426, 455919, 457387, 457983, 459171, 466728, 467611, 469983, 470649, 471699, 472750, 475656, 475662, 475789, 486785, 486961, 487632, 491516, 491986, 492246, 497389, 501226, 511418, 513156, 513949, 528398, 529394, 533351, 533966, 534376, 536728, 556025, 567042, 578395, 588286, 593294, 612996, 629882, 652539, 684064, 790903, 807650, 813244);

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

[
  "порн мамочек"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'порн мамочек';

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

[
  "порн мамочек"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'порн мамочек';