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

[
  "real amateur couple"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real amateur couple' 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
  446081
  509437
  494963
  679657
  622856
  614954
  635050
  485420
  716675
  589110
  609838
  463360
  507456
  558582
  581228
  631503
  518329
  509401
  482774
  545848
  455377
  482906
  444601
  522963
  577553
  440857
  552234
  537815
  609709
  593785
  641059
  518155
  557718
  624838
  624990
  418883
  498909
  564132
  415834
  490968
  502868
  521377
  494938
  556149
  557267
  792599
  446181
  460562
  609197
  591214
  419956
  481772
  624142
  442356
  622218
  421991
  498656
  504250
  478020
  511176
  512410
  527706
  557725
  536481
  728946
  515578
  427246
  509622
  652756
  486862
  506133
  594353
  535282
  552217
  599370
  564918
  528040
  588650
  601982
  597148
  527608
]

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 (446081, 509437, 494963, 679657, 622856, 614954, 635050, 485420, 716675, 589110, 609838, 463360, 507456, 558582, 581228, 631503, 518329, 509401, 482774, 545848, 455377, 482906, 444601, 522963, 577553, 440857, 552234, 537815, 609709, 593785, 641059, 518155, 557718, 624838, 624990, 418883, 498909, 564132, 415834, 490968, 502868, 521377, 494938, 556149, 557267, 792599, 446181, 460562, 609197, 591214, 419956, 481772, 624142, 442356, 622218, 421991, 498656, 504250, 478020, 511176, 512410, 527706, 557725, 536481, 728946, 515578, 427246, 509622, 652756, 486862, 506133, 594353, 535282, 552217, 599370, 564918, 528040, 588650, 601982, 597148, 527608);

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
  415834
  418883
  419956
  421991
  427246
  440857
  442356
  444601
  446081
  446181
  455377
  460562
  463360
  478020
  481772
  482774
  482906
  485420
  486862
  490968
  494938
  494963
  498656
  498909
  502868
  504250
  506133
  507456
  509401
  509437
  509622
  511176
  512410
  515578
  518155
  518329
  521377
  522963
  527608
  527706
  528040
  535282
  536481
  537815
  545848
  552217
  552234
  556149
  557267
  557718
  557725
  558582
  564132
  564918
  577553
  581228
  588650
  589110
  591214
  593785
  594353
  597148
  599370
  601982
  609197
  609709
  609838
  614954
  622218
  622856
  624142
  624838
  624990
  631503
  635050
  641059
  652756
  679657
  716675
  728946
  792599
]

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 (415834, 418883, 419956, 421991, 427246, 440857, 442356, 444601, 446081, 446181, 455377, 460562, 463360, 478020, 481772, 482774, 482906, 485420, 486862, 490968, 494938, 494963, 498656, 498909, 502868, 504250, 506133, 507456, 509401, 509437, 509622, 511176, 512410, 515578, 518155, 518329, 521377, 522963, 527608, 527706, 528040, 535282, 536481, 537815, 545848, 552217, 552234, 556149, 557267, 557718, 557725, 558582, 564132, 564918, 577553, 581228, 588650, 589110, 591214, 593785, 594353, 597148, 599370, 601982, 609197, 609709, 609838, 614954, 622218, 622856, 624142, 624838, 624990, 631503, 635050, 641059, 652756, 679657, 716675, 728946, 792599);

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
  415834
  418883
  419956
  421991
  427246
  440857
  442356
  444601
  446081
  446181
  455377
  460562
  463360
  478020
  481772
  482774
  482906
  485420
  486862
  490968
  494938
  494963
  498656
  498909
  502868
  504250
  506133
  507456
  509401
  509437
  509622
  511176
  512410
  515578
  518155
  518329
  521377
  522963
  527608
  527706
  528040
  535282
  536481
  537815
  545848
  552217
  552234
  556149
  557267
  557718
  557725
  558582
  564132
  564918
  577553
  581228
  588650
  589110
  591214
  593785
  594353
  597148
  599370
  601982
  609197
  609709
  609838
  614954
  622218
  622856
  624142
  624838
  624990
  631503
  635050
  641059
  652756
  679657
  716675
  728946
  792599
]

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 (415834, 418883, 419956, 421991, 427246, 440857, 442356, 444601, 446081, 446181, 455377, 460562, 463360, 478020, 481772, 482774, 482906, 485420, 486862, 490968, 494938, 494963, 498656, 498909, 502868, 504250, 506133, 507456, 509401, 509437, 509622, 511176, 512410, 515578, 518155, 518329, 521377, 522963, 527608, 527706, 528040, 535282, 536481, 537815, 545848, 552217, 552234, 556149, 557267, 557718, 557725, 558582, 564132, 564918, 577553, 581228, 588650, 589110, 591214, 593785, 594353, 597148, 599370, 601982, 609197, 609709, 609838, 614954, 622218, 622856, 624142, 624838, 624990, 631503, 635050, 641059, 652756, 679657, 716675, 728946, 792599);

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

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

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

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

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

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

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

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