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

[
  "wife cocks"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'wife cocks' 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
  693383
  502518
  583939
  591749
  403162
  420457
  459292
  467552
  482776
  648740
  650823
  775866
  807927
  747236
  469110
  450702
  452331
  466085
  506928
  500912
  486807
  605488
  788562
  696920
  462904
  526293
  781277
  418538
  470412
  457674
  532504
  478096
  618239
  598292
  477735
  419358
  466101
  500300
  436820
  814975
  714840
  605688
  514660
  562953
  632614
  506042
  511193
  586786
  407039
  554880
  590230
  472931
  458592
  574762
  462294
  556865
  470074
  453046
  607413
  462321
  429088
  469764
  522895
  417829
  423329
  460733
  506047
  570168
  556524
  543771
  562814
  572771
  587864
  516684
  549239
  478672
]

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 (693383, 502518, 583939, 591749, 403162, 420457, 459292, 467552, 482776, 648740, 650823, 775866, 807927, 747236, 469110, 450702, 452331, 466085, 506928, 500912, 486807, 605488, 788562, 696920, 462904, 526293, 781277, 418538, 470412, 457674, 532504, 478096, 618239, 598292, 477735, 419358, 466101, 500300, 436820, 814975, 714840, 605688, 514660, 562953, 632614, 506042, 511193, 586786, 407039, 554880, 590230, 472931, 458592, 574762, 462294, 556865, 470074, 453046, 607413, 462321, 429088, 469764, 522895, 417829, 423329, 460733, 506047, 570168, 556524, 543771, 562814, 572771, 587864, 516684, 549239, 478672);

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
  403162
  407039
  417829
  418538
  419358
  420457
  423329
  429088
  436820
  450702
  452331
  453046
  457674
  458592
  459292
  460733
  462294
  462321
  462904
  466085
  466101
  467552
  469110
  469764
  470074
  470412
  472931
  477735
  478096
  478672
  482776
  486807
  500300
  500912
  502518
  506042
  506047
  506928
  511193
  514660
  516684
  522895
  526293
  532504
  543771
  549239
  554880
  556524
  556865
  562814
  562953
  570168
  572771
  574762
  583939
  586786
  587864
  590230
  591749
  598292
  605488
  605688
  607413
  618239
  632614
  648740
  650823
  693383
  696920
  714840
  747236
  775866
  781277
  788562
  807927
  814975
]

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 (403162, 407039, 417829, 418538, 419358, 420457, 423329, 429088, 436820, 450702, 452331, 453046, 457674, 458592, 459292, 460733, 462294, 462321, 462904, 466085, 466101, 467552, 469110, 469764, 470074, 470412, 472931, 477735, 478096, 478672, 482776, 486807, 500300, 500912, 502518, 506042, 506047, 506928, 511193, 514660, 516684, 522895, 526293, 532504, 543771, 549239, 554880, 556524, 556865, 562814, 562953, 570168, 572771, 574762, 583939, 586786, 587864, 590230, 591749, 598292, 605488, 605688, 607413, 618239, 632614, 648740, 650823, 693383, 696920, 714840, 747236, 775866, 781277, 788562, 807927, 814975);

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
  403162
  407039
  417829
  418538
  419358
  420457
  423329
  429088
  436820
  450702
  452331
  453046
  457674
  458592
  459292
  460733
  462294
  462321
  462904
  466085
  466101
  467552
  469110
  469764
  470074
  470412
  472931
  477735
  478096
  478672
  482776
  486807
  500300
  500912
  502518
  506042
  506047
  506928
  511193
  514660
  516684
  522895
  526293
  532504
  543771
  549239
  554880
  556524
  556865
  562814
  562953
  570168
  572771
  574762
  583939
  586786
  587864
  590230
  591749
  598292
  605488
  605688
  607413
  618239
  632614
  648740
  650823
  693383
  696920
  714840
  747236
  775866
  781277
  788562
  807927
  814975
]

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 (403162, 407039, 417829, 418538, 419358, 420457, 423329, 429088, 436820, 450702, 452331, 453046, 457674, 458592, 459292, 460733, 462294, 462321, 462904, 466085, 466101, 467552, 469110, 469764, 470074, 470412, 472931, 477735, 478096, 478672, 482776, 486807, 500300, 500912, 502518, 506042, 506047, 506928, 511193, 514660, 516684, 522895, 526293, 532504, 543771, 549239, 554880, 556524, 556865, 562814, 562953, 570168, 572771, 574762, 583939, 586786, 587864, 590230, 591749, 598292, 605488, 605688, 607413, 618239, 632614, 648740, 650823, 693383, 696920, 714840, 747236, 775866, 781277, 788562, 807927, 814975);

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

[
  "жен cocks"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'жен cocks';

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

[
  "жен cocks"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'жен cocks';