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

[
  "front sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'front sex' 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
  443792
  444664
  519929
  496935
  575791
  627338
  436235
  471319
  603623
  498033
  542062
  571682
  514699
  542753
  610060
  510251
  515808
  511791
  445735
  720288
  446875
  516313
  389195
  482289
  622978
  439695
  476985
  447036
  619692
  521127
  558414
  585960
  526228
  532097
  539755
  588693
  418591
  500758
  512385
  495403
  580368
  500578
  446394
  453340
  517455
  427435
  484157
  447031
  522110
  565691
  496097
  623306
  557558
  620330
  603218
  529345
  491753
  593269
  634856
  602754
  611791
  605461
  479709
  442697
  602672
  439676
  524018
  590482
  591585
  518592
  587651
  567053
  619725
  610694
  520008
  606799
  519617
  522382
  482525
  517775
  438896
  554392
]

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 (443792, 444664, 519929, 496935, 575791, 627338, 436235, 471319, 603623, 498033, 542062, 571682, 514699, 542753, 610060, 510251, 515808, 511791, 445735, 720288, 446875, 516313, 389195, 482289, 622978, 439695, 476985, 447036, 619692, 521127, 558414, 585960, 526228, 532097, 539755, 588693, 418591, 500758, 512385, 495403, 580368, 500578, 446394, 453340, 517455, 427435, 484157, 447031, 522110, 565691, 496097, 623306, 557558, 620330, 603218, 529345, 491753, 593269, 634856, 602754, 611791, 605461, 479709, 442697, 602672, 439676, 524018, 590482, 591585, 518592, 587651, 567053, 619725, 610694, 520008, 606799, 519617, 522382, 482525, 517775, 438896, 554392);

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
  389195
  418591
  427435
  436235
  438896
  439676
  439695
  442697
  443792
  444664
  445735
  446394
  446875
  447031
  447036
  453340
  471319
  476985
  479709
  482289
  482525
  484157
  491753
  495403
  496097
  496935
  498033
  500578
  500758
  510251
  511791
  512385
  514699
  515808
  516313
  517455
  517775
  518592
  519617
  519929
  520008
  521127
  522110
  522382
  524018
  526228
  529345
  532097
  539755
  542062
  542753
  554392
  557558
  558414
  565691
  567053
  571682
  575791
  580368
  585960
  587651
  588693
  590482
  591585
  593269
  602672
  602754
  603218
  603623
  605461
  606799
  610060
  610694
  611791
  619692
  619725
  620330
  622978
  623306
  627338
  634856
  720288
]

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 (389195, 418591, 427435, 436235, 438896, 439676, 439695, 442697, 443792, 444664, 445735, 446394, 446875, 447031, 447036, 453340, 471319, 476985, 479709, 482289, 482525, 484157, 491753, 495403, 496097, 496935, 498033, 500578, 500758, 510251, 511791, 512385, 514699, 515808, 516313, 517455, 517775, 518592, 519617, 519929, 520008, 521127, 522110, 522382, 524018, 526228, 529345, 532097, 539755, 542062, 542753, 554392, 557558, 558414, 565691, 567053, 571682, 575791, 580368, 585960, 587651, 588693, 590482, 591585, 593269, 602672, 602754, 603218, 603623, 605461, 606799, 610060, 610694, 611791, 619692, 619725, 620330, 622978, 623306, 627338, 634856, 720288);

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
  389195
  418591
  427435
  436235
  438896
  439676
  439695
  442697
  443792
  444664
  445735
  446394
  446875
  447031
  447036
  453340
  471319
  476985
  479709
  482289
  482525
  484157
  491753
  495403
  496097
  496935
  498033
  500578
  500758
  510251
  511791
  512385
  514699
  515808
  516313
  517455
  517775
  518592
  519617
  519929
  520008
  521127
  522110
  522382
  524018
  526228
  529345
  532097
  539755
  542062
  542753
  554392
  557558
  558414
  565691
  567053
  571682
  575791
  580368
  585960
  587651
  588693
  590482
  591585
  593269
  602672
  602754
  603218
  603623
  605461
  606799
  610060
  610694
  611791
  619692
  619725
  620330
  622978
  623306
  627338
  634856
  720288
]

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 (389195, 418591, 427435, 436235, 438896, 439676, 439695, 442697, 443792, 444664, 445735, 446394, 446875, 447031, 447036, 453340, 471319, 476985, 479709, 482289, 482525, 484157, 491753, 495403, 496097, 496935, 498033, 500578, 500758, 510251, 511791, 512385, 514699, 515808, 516313, 517455, 517775, 518592, 519617, 519929, 520008, 521127, 522110, 522382, 524018, 526228, 529345, 532097, 539755, 542062, 542753, 554392, 557558, 558414, 565691, 567053, 571682, 575791, 580368, 585960, 587651, 588693, 590482, 591585, 593269, 602672, 602754, 603218, 603623, 605461, 606799, 610060, 610694, 611791, 619692, 619725, 620330, 622978, 623306, 627338, 634856, 720288);

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

[
  "front секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'front секс';

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

[
  "front секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'front секс';