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
  525430
  519091
  521047
  529238
  536774
  496872
  543576
  576636
  579431
  559291
  582777
  583221
  683952
  684211
  561456
  613018
  591109
  600965
  623619
  595284
  610293
  593544
  619396
  621318
  602000
  625655
  572026
  475781
  482552
  522794
  525265
  509591
  539783
  518588
  538660
  565095
  565983
  575387
  584085
  548848
  582407
  645883
  580863
  593238
  592495
  621222
  625244
  590865
  629888
  491392
  502740
  506619
  528695
  533073
  483709
  550265
  591177
  600506
  621756
  543772
  469552
  502468
  526359
  564327
  558441
  590749
  525113
  507651
  550315
  594802
  596856
  545015
  609140
  613867
  502533
  559392
]

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 (525430, 519091, 521047, 529238, 536774, 496872, 543576, 576636, 579431, 559291, 582777, 583221, 683952, 684211, 561456, 613018, 591109, 600965, 623619, 595284, 610293, 593544, 619396, 621318, 602000, 625655, 572026, 475781, 482552, 522794, 525265, 509591, 539783, 518588, 538660, 565095, 565983, 575387, 584085, 548848, 582407, 645883, 580863, 593238, 592495, 621222, 625244, 590865, 629888, 491392, 502740, 506619, 528695, 533073, 483709, 550265, 591177, 600506, 621756, 543772, 469552, 502468, 526359, 564327, 558441, 590749, 525113, 507651, 550315, 594802, 596856, 545015, 609140, 613867, 502533, 559392);

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
  469552
  475781
  482552
  483709
  491392
  496872
  502468
  502533
  502740
  506619
  507651
  509591
  518588
  519091
  521047
  522794
  525113
  525265
  525430
  526359
  528695
  529238
  533073
  536774
  538660
  539783
  543576
  543772
  545015
  548848
  550265
  550315
  558441
  559291
  559392
  561456
  564327
  565095
  565983
  572026
  575387
  576636
  579431
  580863
  582407
  582777
  583221
  584085
  590865
  591109
  591177
  592495
  593238
  593544
  594802
  595284
  596856
  600506
  600965
  602000
  609140
  610293
  613018
  613867
  619396
  621222
  621318
  621756
  623619
  625244
  625655
  629888
  645883
  683952
  684211
]

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 (469552, 475781, 482552, 483709, 491392, 496872, 502468, 502533, 502740, 506619, 507651, 509591, 518588, 519091, 521047, 522794, 525113, 525265, 525430, 526359, 528695, 529238, 533073, 536774, 538660, 539783, 543576, 543772, 545015, 548848, 550265, 550315, 558441, 559291, 559392, 561456, 564327, 565095, 565983, 572026, 575387, 576636, 579431, 580863, 582407, 582777, 583221, 584085, 590865, 591109, 591177, 592495, 593238, 593544, 594802, 595284, 596856, 600506, 600965, 602000, 609140, 610293, 613018, 613867, 619396, 621222, 621318, 621756, 623619, 625244, 625655, 629888, 645883, 683952, 684211);

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
  469552
  475781
  482552
  483709
  491392
  496872
  502468
  502533
  502740
  506619
  507651
  509591
  518588
  519091
  521047
  522794
  525113
  525265
  525430
  526359
  528695
  529238
  533073
  536774
  538660
  539783
  543576
  543772
  545015
  548848
  550265
  550315
  558441
  559291
  559392
  561456
  564327
  565095
  565983
  572026
  575387
  576636
  579431
  580863
  582407
  582777
  583221
  584085
  590865
  591109
  591177
  592495
  593238
  593544
  594802
  595284
  596856
  600506
  600965
  602000
  609140
  610293
  613018
  613867
  619396
  621222
  621318
  621756
  623619
  625244
  625655
  629888
  645883
  683952
  684211
]

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 (469552, 475781, 482552, 483709, 491392, 496872, 502468, 502533, 502740, 506619, 507651, 509591, 518588, 519091, 521047, 522794, 525113, 525265, 525430, 526359, 528695, 529238, 533073, 536774, 538660, 539783, 543576, 543772, 545015, 548848, 550265, 550315, 558441, 559291, 559392, 561456, 564327, 565095, 565983, 572026, 575387, 576636, 579431, 580863, 582407, 582777, 583221, 584085, 590865, 591109, 591177, 592495, 593238, 593544, 594802, 595284, 596856, 600506, 600965, 602000, 609140, 610293, 613018, 613867, 619396, 621222, 621318, 621756, 623619, 625244, 625655, 629888, 645883, 683952, 684211);

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` = 'кар волос';