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

[
  "кружевн"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'кружевн' 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
  514417
  522037
  526358
  528552
  490701
  498989
  482997
  483436
  516354
  524254
  383538
  405947
  490218
  489323
  450829
  507288
  526963
  503496
  472194
  569663
  570748
  574768
  582926
  603384
  473561
  473400
  437462
  471143
  450953
  456726
  477656
  514149
  422511
  428262
  488073
  475247
  584325
  606036
  432531
  450724
  442523
  503561
  509672
  511497
  520570
  494015
  518255
  501178
  514600
  480370
  571199
  396087
  420472
  457446
  472299
  522975
  507669
  521192
  516025
  655471
  480312
  440833
  483474
  528931
  551539
  572711
  594819
  622971
  595217
  586623
  613210
  455207
  689382
  552570
  624150
  598199
  524013
  573754
  621858
  605996
  603033
]

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 (514417, 522037, 526358, 528552, 490701, 498989, 482997, 483436, 516354, 524254, 383538, 405947, 490218, 489323, 450829, 507288, 526963, 503496, 472194, 569663, 570748, 574768, 582926, 603384, 473561, 473400, 437462, 471143, 450953, 456726, 477656, 514149, 422511, 428262, 488073, 475247, 584325, 606036, 432531, 450724, 442523, 503561, 509672, 511497, 520570, 494015, 518255, 501178, 514600, 480370, 571199, 396087, 420472, 457446, 472299, 522975, 507669, 521192, 516025, 655471, 480312, 440833, 483474, 528931, 551539, 572711, 594819, 622971, 595217, 586623, 613210, 455207, 689382, 552570, 624150, 598199, 524013, 573754, 621858, 605996, 603033);

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
  383538
  396087
  405947
  420472
  422511
  428262
  432531
  437462
  440833
  442523
  450724
  450829
  450953
  455207
  456726
  457446
  471143
  472194
  472299
  473400
  473561
  475247
  477656
  480312
  480370
  482997
  483436
  483474
  488073
  489323
  490218
  490701
  494015
  498989
  501178
  503496
  503561
  507288
  507669
  509672
  511497
  514149
  514417
  514600
  516025
  516354
  518255
  520570
  521192
  522037
  522975
  524013
  524254
  526358
  526963
  528552
  528931
  551539
  552570
  569663
  570748
  571199
  572711
  573754
  574768
  582926
  584325
  586623
  594819
  595217
  598199
  603033
  603384
  605996
  606036
  613210
  621858
  622971
  624150
  655471
  689382
]

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 (383538, 396087, 405947, 420472, 422511, 428262, 432531, 437462, 440833, 442523, 450724, 450829, 450953, 455207, 456726, 457446, 471143, 472194, 472299, 473400, 473561, 475247, 477656, 480312, 480370, 482997, 483436, 483474, 488073, 489323, 490218, 490701, 494015, 498989, 501178, 503496, 503561, 507288, 507669, 509672, 511497, 514149, 514417, 514600, 516025, 516354, 518255, 520570, 521192, 522037, 522975, 524013, 524254, 526358, 526963, 528552, 528931, 551539, 552570, 569663, 570748, 571199, 572711, 573754, 574768, 582926, 584325, 586623, 594819, 595217, 598199, 603033, 603384, 605996, 606036, 613210, 621858, 622971, 624150, 655471, 689382);

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
  383538
  396087
  405947
  420472
  422511
  428262
  432531
  437462
  440833
  442523
  450724
  450829
  450953
  455207
  456726
  457446
  471143
  472194
  472299
  473400
  473561
  475247
  477656
  480312
  480370
  482997
  483436
  483474
  488073
  489323
  490218
  490701
  494015
  498989
  501178
  503496
  503561
  507288
  507669
  509672
  511497
  514149
  514417
  514600
  516025
  516354
  518255
  520570
  521192
  522037
  522975
  524013
  524254
  526358
  526963
  528552
  528931
  551539
  552570
  569663
  570748
  571199
  572711
  573754
  574768
  582926
  584325
  586623
  594819
  595217
  598199
  603033
  603384
  605996
  606036
  613210
  621858
  622971
  624150
  655471
  689382
]

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 (383538, 396087, 405947, 420472, 422511, 428262, 432531, 437462, 440833, 442523, 450724, 450829, 450953, 455207, 456726, 457446, 471143, 472194, 472299, 473400, 473561, 475247, 477656, 480312, 480370, 482997, 483436, 483474, 488073, 489323, 490218, 490701, 494015, 498989, 501178, 503496, 503561, 507288, 507669, 509672, 511497, 514149, 514417, 514600, 516025, 516354, 518255, 520570, 521192, 522037, 522975, 524013, 524254, 526358, 526963, 528552, 528931, 551539, 552570, 569663, 570748, 571199, 572711, 573754, 574768, 582926, 584325, 586623, 594819, 595217, 598199, 603033, 603384, 605996, 606036, 613210, 621858, 622971, 624150, 655471, 689382);

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

[
  "кружевн"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'кружевн';

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

[
  "кружевн"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'кружевн';