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

[
  "little russian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'little russian' 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
  499302
  484009
  487654
  499164
  534077
  490758
  528234
  559532
  425076
  512427
  462331
  482391
  488852
  575505
  546994
  576033
  581532
  573296
  552407
  595852
  601894
  784871
  465924
  455687
  504614
  511012
  487146
  502257
  535414
  499194
  514781
  571012
  527074
  558863
  571724
  558072
  567910
  606017
  620783
  634512
  467402
  463000
  539280
  513568
  540747
  491194
  499734
  535447
  539293
  628282
  434369
  500288
  552170
  597227
  639460
  423806
  456523
  402724
  462991
  486193
  520011
  514315
  524301
  497951
  457972
  485542
  610404
  474003
  662137
  509969
  651938
  603810
  632695
  499089
  606002
]

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 (499302, 484009, 487654, 499164, 534077, 490758, 528234, 559532, 425076, 512427, 462331, 482391, 488852, 575505, 546994, 576033, 581532, 573296, 552407, 595852, 601894, 784871, 465924, 455687, 504614, 511012, 487146, 502257, 535414, 499194, 514781, 571012, 527074, 558863, 571724, 558072, 567910, 606017, 620783, 634512, 467402, 463000, 539280, 513568, 540747, 491194, 499734, 535447, 539293, 628282, 434369, 500288, 552170, 597227, 639460, 423806, 456523, 402724, 462991, 486193, 520011, 514315, 524301, 497951, 457972, 485542, 610404, 474003, 662137, 509969, 651938, 603810, 632695, 499089, 606002);

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
  402724
  423806
  425076
  434369
  455687
  456523
  457972
  462331
  462991
  463000
  465924
  467402
  474003
  482391
  484009
  485542
  486193
  487146
  487654
  488852
  490758
  491194
  497951
  499089
  499164
  499194
  499302
  499734
  500288
  502257
  504614
  509969
  511012
  512427
  513568
  514315
  514781
  520011
  524301
  527074
  528234
  534077
  535414
  535447
  539280
  539293
  540747
  546994
  552170
  552407
  558072
  558863
  559532
  567910
  571012
  571724
  573296
  575505
  576033
  581532
  595852
  597227
  601894
  603810
  606002
  606017
  610404
  620783
  628282
  632695
  634512
  639460
  651938
  662137
  784871
]

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 (402724, 423806, 425076, 434369, 455687, 456523, 457972, 462331, 462991, 463000, 465924, 467402, 474003, 482391, 484009, 485542, 486193, 487146, 487654, 488852, 490758, 491194, 497951, 499089, 499164, 499194, 499302, 499734, 500288, 502257, 504614, 509969, 511012, 512427, 513568, 514315, 514781, 520011, 524301, 527074, 528234, 534077, 535414, 535447, 539280, 539293, 540747, 546994, 552170, 552407, 558072, 558863, 559532, 567910, 571012, 571724, 573296, 575505, 576033, 581532, 595852, 597227, 601894, 603810, 606002, 606017, 610404, 620783, 628282, 632695, 634512, 639460, 651938, 662137, 784871);

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
  402724
  423806
  425076
  434369
  455687
  456523
  457972
  462331
  462991
  463000
  465924
  467402
  474003
  482391
  484009
  485542
  486193
  487146
  487654
  488852
  490758
  491194
  497951
  499089
  499164
  499194
  499302
  499734
  500288
  502257
  504614
  509969
  511012
  512427
  513568
  514315
  514781
  520011
  524301
  527074
  528234
  534077
  535414
  535447
  539280
  539293
  540747
  546994
  552170
  552407
  558072
  558863
  559532
  567910
  571012
  571724
  573296
  575505
  576033
  581532
  595852
  597227
  601894
  603810
  606002
  606017
  610404
  620783
  628282
  632695
  634512
  639460
  651938
  662137
  784871
]

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 (402724, 423806, 425076, 434369, 455687, 456523, 457972, 462331, 462991, 463000, 465924, 467402, 474003, 482391, 484009, 485542, 486193, 487146, 487654, 488852, 490758, 491194, 497951, 499089, 499164, 499194, 499302, 499734, 500288, 502257, 504614, 509969, 511012, 512427, 513568, 514315, 514781, 520011, 524301, 527074, 528234, 534077, 535414, 535447, 539280, 539293, 540747, 546994, 552170, 552407, 558072, 558863, 559532, 567910, 571012, 571724, 573296, 575505, 576033, 581532, 595852, 597227, 601894, 603810, 606002, 606017, 610404, 620783, 628282, 632695, 634512, 639460, 651938, 662137, 784871);

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

[
  "little русск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'little русск';

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

[
  "little русск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'little русск';