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

[
  "blowjob bbw mature"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blowjob bbw mature' 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
  425503
  443105
  507643
  398949
  517689
  568989
  568365
  366354
  426296
  527426
  470432
  663427
  420178
  483448
  524903
  453574
  531541
  582317
  696513
  621787
  523169
  664837
  445935
  496017
  511086
  527424
  454428
  506260
  489272
  496554
  549754
  564244
  453190
  536481
  502841
  603264
  448860
  589671
  476260
  459189
  464336
  675515
  651609
  600401
  603217
  509842
  447942
  453242
  491771
  713176
  453155
  666776
  544834
  599631
  468165
  445607
  495873
  663490
  667554
  537098
  527415
  566787
  603205
  587833
  554182
  530745
  464985
  446964
  524895
  562030
  554770
  427543
  520413
  650806
  472943
  514582
  529390
  698124
  584049
  603672
]

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 (425503, 443105, 507643, 398949, 517689, 568989, 568365, 366354, 426296, 527426, 470432, 663427, 420178, 483448, 524903, 453574, 531541, 582317, 696513, 621787, 523169, 664837, 445935, 496017, 511086, 527424, 454428, 506260, 489272, 496554, 549754, 564244, 453190, 536481, 502841, 603264, 448860, 589671, 476260, 459189, 464336, 675515, 651609, 600401, 603217, 509842, 447942, 453242, 491771, 713176, 453155, 666776, 544834, 599631, 468165, 445607, 495873, 663490, 667554, 537098, 527415, 566787, 603205, 587833, 554182, 530745, 464985, 446964, 524895, 562030, 554770, 427543, 520413, 650806, 472943, 514582, 529390, 698124, 584049, 603672);

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
  366354
  398949
  420178
  425503
  426296
  427543
  443105
  445607
  445935
  446964
  447942
  448860
  453155
  453190
  453242
  453574
  454428
  459189
  464336
  464985
  468165
  470432
  472943
  476260
  483448
  489272
  491771
  495873
  496017
  496554
  502841
  506260
  507643
  509842
  511086
  514582
  517689
  520413
  523169
  524895
  524903
  527415
  527424
  527426
  529390
  530745
  531541
  536481
  537098
  544834
  549754
  554182
  554770
  562030
  564244
  566787
  568365
  568989
  582317
  584049
  587833
  589671
  599631
  600401
  603205
  603217
  603264
  603672
  621787
  650806
  651609
  663427
  663490
  664837
  666776
  667554
  675515
  696513
  698124
  713176
]

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 (366354, 398949, 420178, 425503, 426296, 427543, 443105, 445607, 445935, 446964, 447942, 448860, 453155, 453190, 453242, 453574, 454428, 459189, 464336, 464985, 468165, 470432, 472943, 476260, 483448, 489272, 491771, 495873, 496017, 496554, 502841, 506260, 507643, 509842, 511086, 514582, 517689, 520413, 523169, 524895, 524903, 527415, 527424, 527426, 529390, 530745, 531541, 536481, 537098, 544834, 549754, 554182, 554770, 562030, 564244, 566787, 568365, 568989, 582317, 584049, 587833, 589671, 599631, 600401, 603205, 603217, 603264, 603672, 621787, 650806, 651609, 663427, 663490, 664837, 666776, 667554, 675515, 696513, 698124, 713176);

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
  366354
  398949
  420178
  425503
  426296
  427543
  443105
  445607
  445935
  446964
  447942
  448860
  453155
  453190
  453242
  453574
  454428
  459189
  464336
  464985
  468165
  470432
  472943
  476260
  483448
  489272
  491771
  495873
  496017
  496554
  502841
  506260
  507643
  509842
  511086
  514582
  517689
  520413
  523169
  524895
  524903
  527415
  527424
  527426
  529390
  530745
  531541
  536481
  537098
  544834
  549754
  554182
  554770
  562030
  564244
  566787
  568365
  568989
  582317
  584049
  587833
  589671
  599631
  600401
  603205
  603217
  603264
  603672
  621787
  650806
  651609
  663427
  663490
  664837
  666776
  667554
  675515
  696513
  698124
  713176
]

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 (366354, 398949, 420178, 425503, 426296, 427543, 443105, 445607, 445935, 446964, 447942, 448860, 453155, 453190, 453242, 453574, 454428, 459189, 464336, 464985, 468165, 470432, 472943, 476260, 483448, 489272, 491771, 495873, 496017, 496554, 502841, 506260, 507643, 509842, 511086, 514582, 517689, 520413, 523169, 524895, 524903, 527415, 527424, 527426, 529390, 530745, 531541, 536481, 537098, 544834, 549754, 554182, 554770, 562030, 564244, 566787, 568365, 568989, 582317, 584049, 587833, 589671, 599631, 600401, 603205, 603217, 603264, 603672, 621787, 650806, 651609, 663427, 663490, 664837, 666776, 667554, 675515, 696513, 698124, 713176);

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

[
  "минет оральн секс bbw mature"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'минет оральн секс bbw mature';

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

[
  "минет оральн секс bbw mature"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'минет оральн секс bbw mature';