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

[
  "sperm japanese"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sperm japanese' 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
  604844
  417960
  582863
  558372
  565976
  593396
  446476
  539942
  550637
  550741
  591592
  463750
  445879
  536647
  596785
  557205
  673051
  551121
  565988
  589684
  619457
  590967
  581705
  623502
  497935
  526090
  646219
  623522
  590695
  471137
  510581
  408601
  422582
  503026
  512212
  525401
  503043
  801048
  382971
  570759
  550781
  601160
  493298
  559921
  623574
  623183
  457275
  554420
  552198
  424328
  557503
  575715
  740771
  801043
  546040
  551989
  652572
  565983
  619439
  547651
  536214
  575716
  446816
  688371
  519911
  482139
  471092
  761289
  663537
  489026
  502511
  548012
  502533
]

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 (604844, 417960, 582863, 558372, 565976, 593396, 446476, 539942, 550637, 550741, 591592, 463750, 445879, 536647, 596785, 557205, 673051, 551121, 565988, 589684, 619457, 590967, 581705, 623502, 497935, 526090, 646219, 623522, 590695, 471137, 510581, 408601, 422582, 503026, 512212, 525401, 503043, 801048, 382971, 570759, 550781, 601160, 493298, 559921, 623574, 623183, 457275, 554420, 552198, 424328, 557503, 575715, 740771, 801043, 546040, 551989, 652572, 565983, 619439, 547651, 536214, 575716, 446816, 688371, 519911, 482139, 471092, 761289, 663537, 489026, 502511, 548012, 502533);

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
  382971
  408601
  417960
  422582
  424328
  445879
  446476
  446816
  457275
  463750
  471092
  471137
  482139
  489026
  493298
  497935
  502511
  502533
  503026
  503043
  510581
  512212
  519911
  525401
  526090
  536214
  536647
  539942
  546040
  547651
  548012
  550637
  550741
  550781
  551121
  551989
  552198
  554420
  557205
  557503
  558372
  559921
  565976
  565983
  565988
  570759
  575715
  575716
  581705
  582863
  589684
  590695
  590967
  591592
  593396
  596785
  601160
  604844
  619439
  619457
  623183
  623502
  623522
  623574
  646219
  652572
  663537
  673051
  688371
  740771
  761289
  801043
  801048
]

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 (382971, 408601, 417960, 422582, 424328, 445879, 446476, 446816, 457275, 463750, 471092, 471137, 482139, 489026, 493298, 497935, 502511, 502533, 503026, 503043, 510581, 512212, 519911, 525401, 526090, 536214, 536647, 539942, 546040, 547651, 548012, 550637, 550741, 550781, 551121, 551989, 552198, 554420, 557205, 557503, 558372, 559921, 565976, 565983, 565988, 570759, 575715, 575716, 581705, 582863, 589684, 590695, 590967, 591592, 593396, 596785, 601160, 604844, 619439, 619457, 623183, 623502, 623522, 623574, 646219, 652572, 663537, 673051, 688371, 740771, 761289, 801043, 801048);

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
  382971
  408601
  417960
  422582
  424328
  445879
  446476
  446816
  457275
  463750
  471092
  471137
  482139
  489026
  493298
  497935
  502511
  502533
  503026
  503043
  510581
  512212
  519911
  525401
  526090
  536214
  536647
  539942
  546040
  547651
  548012
  550637
  550741
  550781
  551121
  551989
  552198
  554420
  557205
  557503
  558372
  559921
  565976
  565983
  565988
  570759
  575715
  575716
  581705
  582863
  589684
  590695
  590967
  591592
  593396
  596785
  601160
  604844
  619439
  619457
  623183
  623502
  623522
  623574
  646219
  652572
  663537
  673051
  688371
  740771
  761289
  801043
  801048
]

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 (382971, 408601, 417960, 422582, 424328, 445879, 446476, 446816, 457275, 463750, 471092, 471137, 482139, 489026, 493298, 497935, 502511, 502533, 503026, 503043, 510581, 512212, 519911, 525401, 526090, 536214, 536647, 539942, 546040, 547651, 548012, 550637, 550741, 550781, 551121, 551989, 552198, 554420, 557205, 557503, 558372, 559921, 565976, 565983, 565988, 570759, 575715, 575716, 581705, 582863, 589684, 590695, 590967, 591592, 593396, 596785, 601160, 604844, 619439, 619457, 623183, 623502, 623522, 623574, 646219, 652572, 663537, 673051, 688371, 740771, 761289, 801043, 801048);

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

[
  "сперм японк азиатк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'сперм японк азиатк';

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

[
  "сперм японк азиатк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'сперм японк азиатк';