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

[
  "daddy amateur"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'daddy amateur' 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
  490120
  513075
  513201
  519416
  663297
  540661
  467725
  449475
  482734
  460082
  459759
  495669
  495063
  436461
  453364
  454865
  486348
  519460
  419320
  435166
  456951
  446840
  489185
  502133
  508539
  473372
  432760
  510707
  503951
  524573
  526255
  510692
  515824
  519402
  520941
  555857
  621767
  413096
  463165
  511200
  489823
  444882
  476903
  579707
  463134
  500803
  485304
  497424
  509696
  412738
  446457
  613683
  453529
  521426
  444660
  568558
  446682
  454871
  525262
  482824
  590851
  567046
  404811
  395856
  523030
  399263
  577822
  603124
  659216
  564136
  424746
  613488
  609922
]

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 (490120, 513075, 513201, 519416, 663297, 540661, 467725, 449475, 482734, 460082, 459759, 495669, 495063, 436461, 453364, 454865, 486348, 519460, 419320, 435166, 456951, 446840, 489185, 502133, 508539, 473372, 432760, 510707, 503951, 524573, 526255, 510692, 515824, 519402, 520941, 555857, 621767, 413096, 463165, 511200, 489823, 444882, 476903, 579707, 463134, 500803, 485304, 497424, 509696, 412738, 446457, 613683, 453529, 521426, 444660, 568558, 446682, 454871, 525262, 482824, 590851, 567046, 404811, 395856, 523030, 399263, 577822, 603124, 659216, 564136, 424746, 613488, 609922);

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
  395856
  399263
  404811
  412738
  413096
  419320
  424746
  432760
  435166
  436461
  444660
  444882
  446457
  446682
  446840
  449475
  453364
  453529
  454865
  454871
  456951
  459759
  460082
  463134
  463165
  467725
  473372
  476903
  482734
  482824
  485304
  486348
  489185
  489823
  490120
  495063
  495669
  497424
  500803
  502133
  503951
  508539
  509696
  510692
  510707
  511200
  513075
  513201
  515824
  519402
  519416
  519460
  520941
  521426
  523030
  524573
  525262
  526255
  540661
  555857
  564136
  567046
  568558
  577822
  579707
  590851
  603124
  609922
  613488
  613683
  621767
  659216
  663297
]

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 (395856, 399263, 404811, 412738, 413096, 419320, 424746, 432760, 435166, 436461, 444660, 444882, 446457, 446682, 446840, 449475, 453364, 453529, 454865, 454871, 456951, 459759, 460082, 463134, 463165, 467725, 473372, 476903, 482734, 482824, 485304, 486348, 489185, 489823, 490120, 495063, 495669, 497424, 500803, 502133, 503951, 508539, 509696, 510692, 510707, 511200, 513075, 513201, 515824, 519402, 519416, 519460, 520941, 521426, 523030, 524573, 525262, 526255, 540661, 555857, 564136, 567046, 568558, 577822, 579707, 590851, 603124, 609922, 613488, 613683, 621767, 659216, 663297);

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
  395856
  399263
  404811
  412738
  413096
  419320
  424746
  432760
  435166
  436461
  444660
  444882
  446457
  446682
  446840
  449475
  453364
  453529
  454865
  454871
  456951
  459759
  460082
  463134
  463165
  467725
  473372
  476903
  482734
  482824
  485304
  486348
  489185
  489823
  490120
  495063
  495669
  497424
  500803
  502133
  503951
  508539
  509696
  510692
  510707
  511200
  513075
  513201
  515824
  519402
  519416
  519460
  520941
  521426
  523030
  524573
  525262
  526255
  540661
  555857
  564136
  567046
  568558
  577822
  579707
  590851
  603124
  609922
  613488
  613683
  621767
  659216
  663297
]

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 (395856, 399263, 404811, 412738, 413096, 419320, 424746, 432760, 435166, 436461, 444660, 444882, 446457, 446682, 446840, 449475, 453364, 453529, 454865, 454871, 456951, 459759, 460082, 463134, 463165, 467725, 473372, 476903, 482734, 482824, 485304, 486348, 489185, 489823, 490120, 495063, 495669, 497424, 500803, 502133, 503951, 508539, 509696, 510692, 510707, 511200, 513075, 513201, 515824, 519402, 519416, 519460, 520941, 521426, 523030, 524573, 525262, 526255, 540661, 555857, 564136, 567046, 568558, 577822, 579707, 590851, 603124, 609922, 613488, 613683, 621767, 659216, 663297);

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

[
  "daddy любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'daddy любительск';

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

[
  "daddy любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'daddy любительск';