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

[
  "anal chubby redhead"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal chubby redhead' 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
  443278
  446059
  457472
  483639
  549826
  423935
  442507
  470203
  421878
  465222
  474109
  487315
  514473
  400497
  522768
  187953
  588288
  473249
  439732
  444699
  421820
  625235
  422171
  422198
  444344
  457470
  454501
  506278
  485276
  516073
  668668
  444298
  482298
  444589
  521142
  483628
  541400
  623468
  554833
  478369
  443358
  445201
  467034
  537261
  493176
  700949
  422158
  483626
  549830
  608041
  421833
  470472
  421882
  634885
  444679
  400491
  444003
  519942
  629742
  400481
  466989
  484372
  428276
  633741
  634856
  524882
  637001
  419546
  549233
  578823
  464006
  428103
  637148
  445641
  506047
  421900
]

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 (443278, 446059, 457472, 483639, 549826, 423935, 442507, 470203, 421878, 465222, 474109, 487315, 514473, 400497, 522768, 187953, 588288, 473249, 439732, 444699, 421820, 625235, 422171, 422198, 444344, 457470, 454501, 506278, 485276, 516073, 668668, 444298, 482298, 444589, 521142, 483628, 541400, 623468, 554833, 478369, 443358, 445201, 467034, 537261, 493176, 700949, 422158, 483626, 549830, 608041, 421833, 470472, 421882, 634885, 444679, 400491, 444003, 519942, 629742, 400481, 466989, 484372, 428276, 633741, 634856, 524882, 637001, 419546, 549233, 578823, 464006, 428103, 637148, 445641, 506047, 421900);

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
  187953
  400481
  400491
  400497
  419546
  421820
  421833
  421878
  421882
  421900
  422158
  422171
  422198
  423935
  428103
  428276
  439732
  442507
  443278
  443358
  444003
  444298
  444344
  444589
  444679
  444699
  445201
  445641
  446059
  454501
  457470
  457472
  464006
  465222
  466989
  467034
  470203
  470472
  473249
  474109
  478369
  482298
  483626
  483628
  483639
  484372
  485276
  487315
  493176
  506047
  506278
  514473
  516073
  519942
  521142
  522768
  524882
  537261
  541400
  549233
  549826
  549830
  554833
  578823
  588288
  608041
  623468
  625235
  629742
  633741
  634856
  634885
  637001
  637148
  668668
  700949
]

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 (187953, 400481, 400491, 400497, 419546, 421820, 421833, 421878, 421882, 421900, 422158, 422171, 422198, 423935, 428103, 428276, 439732, 442507, 443278, 443358, 444003, 444298, 444344, 444589, 444679, 444699, 445201, 445641, 446059, 454501, 457470, 457472, 464006, 465222, 466989, 467034, 470203, 470472, 473249, 474109, 478369, 482298, 483626, 483628, 483639, 484372, 485276, 487315, 493176, 506047, 506278, 514473, 516073, 519942, 521142, 522768, 524882, 537261, 541400, 549233, 549826, 549830, 554833, 578823, 588288, 608041, 623468, 625235, 629742, 633741, 634856, 634885, 637001, 637148, 668668, 700949);

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
  187953
  400481
  400491
  400497
  419546
  421820
  421833
  421878
  421882
  421900
  422158
  422171
  422198
  423935
  428103
  428276
  439732
  442507
  443278
  443358
  444003
  444298
  444344
  444589
  444679
  444699
  445201
  445641
  446059
  454501
  457470
  457472
  464006
  465222
  466989
  467034
  470203
  470472
  473249
  474109
  478369
  482298
  483626
  483628
  483639
  484372
  485276
  487315
  493176
  506047
  506278
  514473
  516073
  519942
  521142
  522768
  524882
  537261
  541400
  549233
  549826
  549830
  554833
  578823
  588288
  608041
  623468
  625235
  629742
  633741
  634856
  634885
  637001
  637148
  668668
  700949
]

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 (187953, 400481, 400491, 400497, 419546, 421820, 421833, 421878, 421882, 421900, 422158, 422171, 422198, 423935, 428103, 428276, 439732, 442507, 443278, 443358, 444003, 444298, 444344, 444589, 444679, 444699, 445201, 445641, 446059, 454501, 457470, 457472, 464006, 465222, 466989, 467034, 470203, 470472, 473249, 474109, 478369, 482298, 483626, 483628, 483639, 484372, 485276, 487315, 493176, 506047, 506278, 514473, 516073, 519942, 521142, 522768, 524882, 537261, 541400, 549233, 549826, 549830, 554833, 578823, 588288, 608041, 623468, 625235, 629742, 633741, 634856, 634885, 637001, 637148, 668668, 700949);

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

[
  "анал chubby рыжая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал chubby рыжая';

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

[
  "анал chubby рыжая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал chubby рыжая';