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

[
  "girls at work"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'girls at work' 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
  526926
  523159
  557894
  554104
  578139
  591239
  601322
  421398
  496900
  505040
  471498
  526963
  504575
  518603
  575361
  554315
  667417
  478525
  465769
  475543
  511664
  517831
  495781
  561334
  502657
  545833
  571046
  578784
  567593
  635074
  465745
  518824
  508414
  520666
  684566
  463298
  545839
  558543
  386218
  534791
  553315
  814842
  491166
  457959
  503322
  535014
  646199
  590664
  586615
  588722
  599164
  513471
  558128
  558904
  416098
  464702
  483964
  522768
  632599
  439653
  424220
  618740
  519988
  577450
  663569
  553329
  578467
  534168
  623026
  420391
  523045
  486968
  586962
  523033
  525648
  599177
  622693
  430553
  418686
  549736
  625440
]

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 (526926, 523159, 557894, 554104, 578139, 591239, 601322, 421398, 496900, 505040, 471498, 526963, 504575, 518603, 575361, 554315, 667417, 478525, 465769, 475543, 511664, 517831, 495781, 561334, 502657, 545833, 571046, 578784, 567593, 635074, 465745, 518824, 508414, 520666, 684566, 463298, 545839, 558543, 386218, 534791, 553315, 814842, 491166, 457959, 503322, 535014, 646199, 590664, 586615, 588722, 599164, 513471, 558128, 558904, 416098, 464702, 483964, 522768, 632599, 439653, 424220, 618740, 519988, 577450, 663569, 553329, 578467, 534168, 623026, 420391, 523045, 486968, 586962, 523033, 525648, 599177, 622693, 430553, 418686, 549736, 625440);

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
  386218
  416098
  418686
  420391
  421398
  424220
  430553
  439653
  457959
  463298
  464702
  465745
  465769
  471498
  475543
  478525
  483964
  486968
  491166
  495781
  496900
  502657
  503322
  504575
  505040
  508414
  511664
  513471
  517831
  518603
  518824
  519988
  520666
  522768
  523033
  523045
  523159
  525648
  526926
  526963
  534168
  534791
  535014
  545833
  545839
  549736
  553315
  553329
  554104
  554315
  557894
  558128
  558543
  558904
  561334
  567593
  571046
  575361
  577450
  578139
  578467
  578784
  586615
  586962
  588722
  590664
  591239
  599164
  599177
  601322
  618740
  622693
  623026
  625440
  632599
  635074
  646199
  663569
  667417
  684566
  814842
]

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 (386218, 416098, 418686, 420391, 421398, 424220, 430553, 439653, 457959, 463298, 464702, 465745, 465769, 471498, 475543, 478525, 483964, 486968, 491166, 495781, 496900, 502657, 503322, 504575, 505040, 508414, 511664, 513471, 517831, 518603, 518824, 519988, 520666, 522768, 523033, 523045, 523159, 525648, 526926, 526963, 534168, 534791, 535014, 545833, 545839, 549736, 553315, 553329, 554104, 554315, 557894, 558128, 558543, 558904, 561334, 567593, 571046, 575361, 577450, 578139, 578467, 578784, 586615, 586962, 588722, 590664, 591239, 599164, 599177, 601322, 618740, 622693, 623026, 625440, 632599, 635074, 646199, 663569, 667417, 684566, 814842);

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
  386218
  416098
  418686
  420391
  421398
  424220
  430553
  439653
  457959
  463298
  464702
  465745
  465769
  471498
  475543
  478525
  483964
  486968
  491166
  495781
  496900
  502657
  503322
  504575
  505040
  508414
  511664
  513471
  517831
  518603
  518824
  519988
  520666
  522768
  523033
  523045
  523159
  525648
  526926
  526963
  534168
  534791
  535014
  545833
  545839
  549736
  553315
  553329
  554104
  554315
  557894
  558128
  558543
  558904
  561334
  567593
  571046
  575361
  577450
  578139
  578467
  578784
  586615
  586962
  588722
  590664
  591239
  599164
  599177
  601322
  618740
  622693
  623026
  625440
  632599
  635074
  646199
  663569
  667417
  684566
  814842
]

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 (386218, 416098, 418686, 420391, 421398, 424220, 430553, 439653, 457959, 463298, 464702, 465745, 465769, 471498, 475543, 478525, 483964, 486968, 491166, 495781, 496900, 502657, 503322, 504575, 505040, 508414, 511664, 513471, 517831, 518603, 518824, 519988, 520666, 522768, 523033, 523045, 523159, 525648, 526926, 526963, 534168, 534791, 535014, 545833, 545839, 549736, 553315, 553329, 554104, 554315, 557894, 558128, 558543, 558904, 561334, 567593, 571046, 575361, 577450, 578139, 578467, 578784, 586615, 586962, 588722, 590664, 591239, 599164, 599177, 601322, 618740, 622693, 623026, 625440, 632599, 635074, 646199, 663569, 667417, 684566, 814842);

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

[
  "девушк work"
]

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

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

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

[
  "девушк work"
]

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

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