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

[
  "amateur wife friends"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur wife friends' 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
  694166
  466493
  579317
  517075
  620648
  627701
  460540
  462886
  428028
  488608
  487872
  446191
  464540
  516455
  508421
  525030
  528879
  640154
  787344
  452768
  462250
  593835
  474632
  473952
  455507
  450533
  509707
  515361
  595808
  514097
  578017
  474635
  448224
  492689
  506050
  587661
  470546
  421015
  470501
  552699
  432883
  472119
  467599
  454527
  733204
  543425
  462310
  519169
  615714
  460731
  520701
  505460
  445668
  463074
  565095
  542753
  420726
  506820
  557937
  595757
  504213
  468965
  517567
  524527
  465449
  501209
  463511
  550484
  572711
  581433
  454521
  462092
  640136
  484463
  474633
  474639
  466094
  615703
  550667
  577392
  583723
  464566
  601976
]

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 (694166, 466493, 579317, 517075, 620648, 627701, 460540, 462886, 428028, 488608, 487872, 446191, 464540, 516455, 508421, 525030, 528879, 640154, 787344, 452768, 462250, 593835, 474632, 473952, 455507, 450533, 509707, 515361, 595808, 514097, 578017, 474635, 448224, 492689, 506050, 587661, 470546, 421015, 470501, 552699, 432883, 472119, 467599, 454527, 733204, 543425, 462310, 519169, 615714, 460731, 520701, 505460, 445668, 463074, 565095, 542753, 420726, 506820, 557937, 595757, 504213, 468965, 517567, 524527, 465449, 501209, 463511, 550484, 572711, 581433, 454521, 462092, 640136, 484463, 474633, 474639, 466094, 615703, 550667, 577392, 583723, 464566, 601976);

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
  420726
  421015
  428028
  432883
  445668
  446191
  448224
  450533
  452768
  454521
  454527
  455507
  460540
  460731
  462092
  462250
  462310
  462886
  463074
  463511
  464540
  464566
  465449
  466094
  466493
  467599
  468965
  470501
  470546
  472119
  473952
  474632
  474633
  474635
  474639
  484463
  487872
  488608
  492689
  501209
  504213
  505460
  506050
  506820
  508421
  509707
  514097
  515361
  516455
  517075
  517567
  519169
  520701
  524527
  525030
  528879
  542753
  543425
  550484
  550667
  552699
  557937
  565095
  572711
  577392
  578017
  579317
  581433
  583723
  587661
  593835
  595757
  595808
  601976
  615703
  615714
  620648
  627701
  640136
  640154
  694166
  733204
  787344
]

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 (420726, 421015, 428028, 432883, 445668, 446191, 448224, 450533, 452768, 454521, 454527, 455507, 460540, 460731, 462092, 462250, 462310, 462886, 463074, 463511, 464540, 464566, 465449, 466094, 466493, 467599, 468965, 470501, 470546, 472119, 473952, 474632, 474633, 474635, 474639, 484463, 487872, 488608, 492689, 501209, 504213, 505460, 506050, 506820, 508421, 509707, 514097, 515361, 516455, 517075, 517567, 519169, 520701, 524527, 525030, 528879, 542753, 543425, 550484, 550667, 552699, 557937, 565095, 572711, 577392, 578017, 579317, 581433, 583723, 587661, 593835, 595757, 595808, 601976, 615703, 615714, 620648, 627701, 640136, 640154, 694166, 733204, 787344);

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
  420726
  421015
  428028
  432883
  445668
  446191
  448224
  450533
  452768
  454521
  454527
  455507
  460540
  460731
  462092
  462250
  462310
  462886
  463074
  463511
  464540
  464566
  465449
  466094
  466493
  467599
  468965
  470501
  470546
  472119
  473952
  474632
  474633
  474635
  474639
  484463
  487872
  488608
  492689
  501209
  504213
  505460
  506050
  506820
  508421
  509707
  514097
  515361
  516455
  517075
  517567
  519169
  520701
  524527
  525030
  528879
  542753
  543425
  550484
  550667
  552699
  557937
  565095
  572711
  577392
  578017
  579317
  581433
  583723
  587661
  593835
  595757
  595808
  601976
  615703
  615714
  620648
  627701
  640136
  640154
  694166
  733204
  787344
]

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 (420726, 421015, 428028, 432883, 445668, 446191, 448224, 450533, 452768, 454521, 454527, 455507, 460540, 460731, 462092, 462250, 462310, 462886, 463074, 463511, 464540, 464566, 465449, 466094, 466493, 467599, 468965, 470501, 470546, 472119, 473952, 474632, 474633, 474635, 474639, 484463, 487872, 488608, 492689, 501209, 504213, 505460, 506050, 506820, 508421, 509707, 514097, 515361, 516455, 517075, 517567, 519169, 520701, 524527, 525030, 528879, 542753, 543425, 550484, 550667, 552699, 557937, 565095, 572711, 577392, 578017, 579317, 581433, 583723, 587661, 593835, 595757, 595808, 601976, 615703, 615714, 620648, 627701, 640136, 640154, 694166, 733204, 787344);

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

[
  "любительск жен friends"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск жен friends';

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

[
  "любительск жен friends"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск жен friends';