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

[
  "natural busty teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'natural busty teen' 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
  517547
  529187
  537307
  426197
  418832
  692887
  565185
  424360
  507651
  424321
  501461
  444884
  485481
  532982
  536610
  555864
  564772
  647847
  669577
  676624
  587133
  587152
  632561
  409682
  433040
  442965
  509229
  563362
  524773
  506619
  565191
  678089
  683831
  567605
  586504
  613489
  428476
  527942
  525243
  524388
  413929
  491790
  590866
  620882
  454954
  446738
  561970
  674988
  594239
  595498
  613177
  514599
  613055
  538745
  486871
  576308
  654374
  536802
  585181
  604873
  609906
  492267
  559959
  634134
  598604
  603364
  654422
  522562
  538669
  513951
  463757
  578454
  565186
  559233
]

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 (517547, 529187, 537307, 426197, 418832, 692887, 565185, 424360, 507651, 424321, 501461, 444884, 485481, 532982, 536610, 555864, 564772, 647847, 669577, 676624, 587133, 587152, 632561, 409682, 433040, 442965, 509229, 563362, 524773, 506619, 565191, 678089, 683831, 567605, 586504, 613489, 428476, 527942, 525243, 524388, 413929, 491790, 590866, 620882, 454954, 446738, 561970, 674988, 594239, 595498, 613177, 514599, 613055, 538745, 486871, 576308, 654374, 536802, 585181, 604873, 609906, 492267, 559959, 634134, 598604, 603364, 654422, 522562, 538669, 513951, 463757, 578454, 565186, 559233);

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
  409682
  413929
  418832
  424321
  424360
  426197
  428476
  433040
  442965
  444884
  446738
  454954
  463757
  485481
  486871
  491790
  492267
  501461
  506619
  507651
  509229
  513951
  514599
  517547
  522562
  524388
  524773
  525243
  527942
  529187
  532982
  536610
  536802
  537307
  538669
  538745
  555864
  559233
  559959
  561970
  563362
  564772
  565185
  565186
  565191
  567605
  576308
  578454
  585181
  586504
  587133
  587152
  590866
  594239
  595498
  598604
  603364
  604873
  609906
  613055
  613177
  613489
  620882
  632561
  634134
  647847
  654374
  654422
  669577
  674988
  676624
  678089
  683831
  692887
]

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 (409682, 413929, 418832, 424321, 424360, 426197, 428476, 433040, 442965, 444884, 446738, 454954, 463757, 485481, 486871, 491790, 492267, 501461, 506619, 507651, 509229, 513951, 514599, 517547, 522562, 524388, 524773, 525243, 527942, 529187, 532982, 536610, 536802, 537307, 538669, 538745, 555864, 559233, 559959, 561970, 563362, 564772, 565185, 565186, 565191, 567605, 576308, 578454, 585181, 586504, 587133, 587152, 590866, 594239, 595498, 598604, 603364, 604873, 609906, 613055, 613177, 613489, 620882, 632561, 634134, 647847, 654374, 654422, 669577, 674988, 676624, 678089, 683831, 692887);

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
  409682
  413929
  418832
  424321
  424360
  426197
  428476
  433040
  442965
  444884
  446738
  454954
  463757
  485481
  486871
  491790
  492267
  501461
  506619
  507651
  509229
  513951
  514599
  517547
  522562
  524388
  524773
  525243
  527942
  529187
  532982
  536610
  536802
  537307
  538669
  538745
  555864
  559233
  559959
  561970
  563362
  564772
  565185
  565186
  565191
  567605
  576308
  578454
  585181
  586504
  587133
  587152
  590866
  594239
  595498
  598604
  603364
  604873
  609906
  613055
  613177
  613489
  620882
  632561
  634134
  647847
  654374
  654422
  669577
  674988
  676624
  678089
  683831
  692887
]

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 (409682, 413929, 418832, 424321, 424360, 426197, 428476, 433040, 442965, 444884, 446738, 454954, 463757, 485481, 486871, 491790, 492267, 501461, 506619, 507651, 509229, 513951, 514599, 517547, 522562, 524388, 524773, 525243, 527942, 529187, 532982, 536610, 536802, 537307, 538669, 538745, 555864, 559233, 559959, 561970, 563362, 564772, 565185, 565186, 565191, 567605, 576308, 578454, 585181, 586504, 587133, 587152, 590866, 594239, 595498, 598604, 603364, 604873, 609906, 613055, 613177, 613489, 620882, 632561, 634134, 647847, 654374, 654422, 669577, 674988, 676624, 678089, 683831, 692887);

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

[
  "натуральная натуральные busty teen"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'натуральная натуральные busty teen';

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

[
  "натуральная натуральные busty teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'натуральная натуральные busty teen';