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

[
  "teen anal vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen anal vintage' 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
  619409
  566697
  580253
  670113
  674117
  614441
  578952
  589761
  670955
  694058
  628315
  628292
  790392
  652587
  522899
  546747
  562841
  576650
  562826
  562837
  565102
  572544
  620130
  622953
  592530
  626732
  622381
  577366
  563537
  541884
  615746
  560387
  709748
  573914
  605345
  605338
  580256
  727812
  566502
  576673
  543471
  583897
  622331
  544627
  652544
  541699
  581349
  628327
  582179
  576720
  541830
  559120
  541874
  544529
  577350
  671726
  571244
  541587
  577362
  574244
  636268
  571198
  541643
  576717
  541639
  542189
  541650
  564519
  542192
  559127
  562825
  652539
  541611
  567416
]

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 (619409, 566697, 580253, 670113, 674117, 614441, 578952, 589761, 670955, 694058, 628315, 628292, 790392, 652587, 522899, 546747, 562841, 576650, 562826, 562837, 565102, 572544, 620130, 622953, 592530, 626732, 622381, 577366, 563537, 541884, 615746, 560387, 709748, 573914, 605345, 605338, 580256, 727812, 566502, 576673, 543471, 583897, 622331, 544627, 652544, 541699, 581349, 628327, 582179, 576720, 541830, 559120, 541874, 544529, 577350, 671726, 571244, 541587, 577362, 574244, 636268, 571198, 541643, 576717, 541639, 542189, 541650, 564519, 542192, 559127, 562825, 652539, 541611, 567416);

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
  522899
  541587
  541611
  541639
  541643
  541650
  541699
  541830
  541874
  541884
  542189
  542192
  543471
  544529
  544627
  546747
  559120
  559127
  560387
  562825
  562826
  562837
  562841
  563537
  564519
  565102
  566502
  566697
  567416
  571198
  571244
  572544
  573914
  574244
  576650
  576673
  576717
  576720
  577350
  577362
  577366
  578952
  580253
  580256
  581349
  582179
  583897
  589761
  592530
  605338
  605345
  614441
  615746
  619409
  620130
  622331
  622381
  622953
  626732
  628292
  628315
  628327
  636268
  652539
  652544
  652587
  670113
  670955
  671726
  674117
  694058
  709748
  727812
  790392
]

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 (522899, 541587, 541611, 541639, 541643, 541650, 541699, 541830, 541874, 541884, 542189, 542192, 543471, 544529, 544627, 546747, 559120, 559127, 560387, 562825, 562826, 562837, 562841, 563537, 564519, 565102, 566502, 566697, 567416, 571198, 571244, 572544, 573914, 574244, 576650, 576673, 576717, 576720, 577350, 577362, 577366, 578952, 580253, 580256, 581349, 582179, 583897, 589761, 592530, 605338, 605345, 614441, 615746, 619409, 620130, 622331, 622381, 622953, 626732, 628292, 628315, 628327, 636268, 652539, 652544, 652587, 670113, 670955, 671726, 674117, 694058, 709748, 727812, 790392);

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
  522899
  541587
  541611
  541639
  541643
  541650
  541699
  541830
  541874
  541884
  542189
  542192
  543471
  544529
  544627
  546747
  559120
  559127
  560387
  562825
  562826
  562837
  562841
  563537
  564519
  565102
  566502
  566697
  567416
  571198
  571244
  572544
  573914
  574244
  576650
  576673
  576717
  576720
  577350
  577362
  577366
  578952
  580253
  580256
  581349
  582179
  583897
  589761
  592530
  605338
  605345
  614441
  615746
  619409
  620130
  622331
  622381
  622953
  626732
  628292
  628315
  628327
  636268
  652539
  652544
  652587
  670113
  670955
  671726
  674117
  694058
  709748
  727812
  790392
]

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 (522899, 541587, 541611, 541639, 541643, 541650, 541699, 541830, 541874, 541884, 542189, 542192, 543471, 544529, 544627, 546747, 559120, 559127, 560387, 562825, 562826, 562837, 562841, 563537, 564519, 565102, 566502, 566697, 567416, 571198, 571244, 572544, 573914, 574244, 576650, 576673, 576717, 576720, 577350, 577362, 577366, 578952, 580253, 580256, 581349, 582179, 583897, 589761, 592530, 605338, 605345, 614441, 615746, 619409, 620130, 622331, 622381, 622953, 626732, 628292, 628315, 628327, 636268, 652539, 652544, 652587, 670113, 670955, 671726, 674117, 694058, 709748, 727812, 790392);

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

[
  "teen анал vintage"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen анал vintage';

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

[
  "teen анал vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen анал vintage';