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
  506619
  528695
  533073
  483709
  550265
  591177
  621756
  480382
  492097
  523408
  502147
  512928
  599533
  469552
  502468
  564327
  558441
  590749
  525113
  507651
  550315
  596856
  572026
  609140
  615304
  543772
  502533
  613867
  562565
  384511
  524047
  459291
  573454
  398018
  547993
  529378
  388915
  465246
  485508
  480258
  512674
  528540
  577121
  547585
  569219
  558757
  589165
  590456
  520677
  642409
  617649
  590352
  638885
  449829
  450896
  489709
  521334
  521337
  583056
  653383
  606812
  508146
  543576
  684211
  561456
  522794
  582407
  687225
  580863
  593238
  491392
  600506
  526359
  594802
  545015
  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 (506619, 528695, 533073, 483709, 550265, 591177, 621756, 480382, 492097, 523408, 502147, 512928, 599533, 469552, 502468, 564327, 558441, 590749, 525113, 507651, 550315, 596856, 572026, 609140, 615304, 543772, 502533, 613867, 562565, 384511, 524047, 459291, 573454, 398018, 547993, 529378, 388915, 465246, 485508, 480258, 512674, 528540, 577121, 547585, 569219, 558757, 589165, 590456, 520677, 642409, 617649, 590352, 638885, 449829, 450896, 489709, 521334, 521337, 583056, 653383, 606812, 508146, 543576, 684211, 561456, 522794, 582407, 687225, 580863, 593238, 491392, 600506, 526359, 594802, 545015, 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
  384511
  388915
  398018
  449829
  450896
  459291
  465246
  469552
  480258
  480382
  483709
  485508
  489709
  491392
  492097
  502147
  502468
  502533
  506619
  507651
  508146
  512674
  512928
  520677
  521334
  521337
  522794
  523408
  524047
  525113
  526359
  528540
  528695
  529378
  533073
  543576
  543772
  545015
  547585
  547993
  550265
  550315
  558441
  558757
  559392
  561456
  562565
  564327
  569219
  572026
  573454
  577121
  580863
  582407
  583056
  589165
  590352
  590456
  591177
  593238
  594802
  596856
  599533
  600506
  606812
  609140
  613867
  615304
  617649
  621756
  638885
  642409
  653383
  684211
  687225
]

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 (384511, 388915, 398018, 449829, 450896, 459291, 465246, 469552, 480258, 480382, 483709, 485508, 489709, 491392, 492097, 502147, 502468, 502533, 506619, 507651, 508146, 512674, 512928, 520677, 521334, 521337, 522794, 523408, 524047, 525113, 526359, 528540, 528695, 529378, 533073, 543576, 543772, 545015, 547585, 547993, 550265, 550315, 558441, 558757, 559392, 561456, 562565, 564327, 569219, 572026, 573454, 577121, 580863, 582407, 583056, 589165, 590352, 590456, 591177, 593238, 594802, 596856, 599533, 600506, 606812, 609140, 613867, 615304, 617649, 621756, 638885, 642409, 653383, 684211, 687225);

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
  384511
  388915
  398018
  449829
  450896
  459291
  465246
  469552
  480258
  480382
  483709
  485508
  489709
  491392
  492097
  502147
  502468
  502533
  506619
  507651
  508146
  512674
  512928
  520677
  521334
  521337
  522794
  523408
  524047
  525113
  526359
  528540
  528695
  529378
  533073
  543576
  543772
  545015
  547585
  547993
  550265
  550315
  558441
  558757
  559392
  561456
  562565
  564327
  569219
  572026
  573454
  577121
  580863
  582407
  583056
  589165
  590352
  590456
  591177
  593238
  594802
  596856
  599533
  600506
  606812
  609140
  613867
  615304
  617649
  621756
  638885
  642409
  653383
  684211
  687225
]

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 (384511, 388915, 398018, 449829, 450896, 459291, 465246, 469552, 480258, 480382, 483709, 485508, 489709, 491392, 492097, 502147, 502468, 502533, 506619, 507651, 508146, 512674, 512928, 520677, 521334, 521337, 522794, 523408, 524047, 525113, 526359, 528540, 528695, 529378, 533073, 543576, 543772, 545015, 547585, 547993, 550265, 550315, 558441, 558757, 559392, 561456, 562565, 564327, 569219, 572026, 573454, 577121, 580863, 582407, 583056, 589165, 590352, 590456, 591177, 593238, 594802, 596856, 599533, 600506, 606812, 609140, 613867, 615304, 617649, 621756, 638885, 642409, 653383, 684211, 687225);

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