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

[
  "very teen girls"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very teen girls' 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
  492273
  541393
  699586
  693945
  763540
  427437
  443236
  449019
  461930
  414138
  489583
  492198
  539445
  462379
  554475
  568363
  634545
  588014
  451433
  456229
  470067
  478076
  492161
  814553
  453176
  528960
  521085
  536606
  415964
  514383
  446942
  500207
  525439
  663527
  644056
  519694
  404366
  461454
  496060
  479555
  508185
  642359
  447337
  516336
  489361
  428701
  540595
  617026
  590813
  454998
  456240
  415963
  518917
  446657
  439854
  518289
  696203
  435959
  475508
  602829
  453698
  556017
  614058
  443971
  569830
  476223
  570708
  429805
  672710
  469552
  525441
  597170
  416989
  648560
  598199
  467553
  698124
  632632
  630536
]

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 (492273, 541393, 699586, 693945, 763540, 427437, 443236, 449019, 461930, 414138, 489583, 492198, 539445, 462379, 554475, 568363, 634545, 588014, 451433, 456229, 470067, 478076, 492161, 814553, 453176, 528960, 521085, 536606, 415964, 514383, 446942, 500207, 525439, 663527, 644056, 519694, 404366, 461454, 496060, 479555, 508185, 642359, 447337, 516336, 489361, 428701, 540595, 617026, 590813, 454998, 456240, 415963, 518917, 446657, 439854, 518289, 696203, 435959, 475508, 602829, 453698, 556017, 614058, 443971, 569830, 476223, 570708, 429805, 672710, 469552, 525441, 597170, 416989, 648560, 598199, 467553, 698124, 632632, 630536);

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
  404366
  414138
  415963
  415964
  416989
  427437
  428701
  429805
  435959
  439854
  443236
  443971
  446657
  446942
  447337
  449019
  451433
  453176
  453698
  454998
  456229
  456240
  461454
  461930
  462379
  467553
  469552
  470067
  475508
  476223
  478076
  479555
  489361
  489583
  492161
  492198
  492273
  496060
  500207
  508185
  514383
  516336
  518289
  518917
  519694
  521085
  525439
  525441
  528960
  536606
  539445
  540595
  541393
  554475
  556017
  568363
  569830
  570708
  588014
  590813
  597170
  598199
  602829
  614058
  617026
  630536
  632632
  634545
  642359
  644056
  648560
  663527
  672710
  693945
  696203
  698124
  699586
  763540
  814553
]

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 (404366, 414138, 415963, 415964, 416989, 427437, 428701, 429805, 435959, 439854, 443236, 443971, 446657, 446942, 447337, 449019, 451433, 453176, 453698, 454998, 456229, 456240, 461454, 461930, 462379, 467553, 469552, 470067, 475508, 476223, 478076, 479555, 489361, 489583, 492161, 492198, 492273, 496060, 500207, 508185, 514383, 516336, 518289, 518917, 519694, 521085, 525439, 525441, 528960, 536606, 539445, 540595, 541393, 554475, 556017, 568363, 569830, 570708, 588014, 590813, 597170, 598199, 602829, 614058, 617026, 630536, 632632, 634545, 642359, 644056, 648560, 663527, 672710, 693945, 696203, 698124, 699586, 763540, 814553);

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
  404366
  414138
  415963
  415964
  416989
  427437
  428701
  429805
  435959
  439854
  443236
  443971
  446657
  446942
  447337
  449019
  451433
  453176
  453698
  454998
  456229
  456240
  461454
  461930
  462379
  467553
  469552
  470067
  475508
  476223
  478076
  479555
  489361
  489583
  492161
  492198
  492273
  496060
  500207
  508185
  514383
  516336
  518289
  518917
  519694
  521085
  525439
  525441
  528960
  536606
  539445
  540595
  541393
  554475
  556017
  568363
  569830
  570708
  588014
  590813
  597170
  598199
  602829
  614058
  617026
  630536
  632632
  634545
  642359
  644056
  648560
  663527
  672710
  693945
  696203
  698124
  699586
  763540
  814553
]

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 (404366, 414138, 415963, 415964, 416989, 427437, 428701, 429805, 435959, 439854, 443236, 443971, 446657, 446942, 447337, 449019, 451433, 453176, 453698, 454998, 456229, 456240, 461454, 461930, 462379, 467553, 469552, 470067, 475508, 476223, 478076, 479555, 489361, 489583, 492161, 492198, 492273, 496060, 500207, 508185, 514383, 516336, 518289, 518917, 519694, 521085, 525439, 525441, 528960, 536606, 539445, 540595, 541393, 554475, 556017, 568363, 569830, 570708, 588014, 590813, 597170, 598199, 602829, 614058, 617026, 630536, 632632, 634545, 642359, 644056, 648560, 663527, 672710, 693945, 696203, 698124, 699586, 763540, 814553);

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

[
  "very teen девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'very teen девушк';

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

[
  "very teen девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very teen девушк';