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

[
  "sleep morning"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sleep morning' 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
  439644
  421821
  441728
  446863
  397109
  422319
  428716
  437204
  447054
  459476
  502118
  513872
  522710
  523786
  514118
  525377
  502976
  527192
  496820
  516230
  525823
  433694
  442669
  448440
  519046
  499657
  504229
  556000
  560512
  568454
  545072
  563166
  565975
  606017
  418574
  464699
  470019
  428814
  429885
  439906
  460007
  475404
  446455
  450766
  465312
  502477
  508245
  523584
  524688
  525241
  484484
  521414
  521907
  482570
  492531
  503752
  557196
  558515
  439214
  481650
  502594
  510341
  391643
  576013
  606567
  526775
  650291
  523260
  608111
  620024
  555854
  485462
]

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 (439644, 421821, 441728, 446863, 397109, 422319, 428716, 437204, 447054, 459476, 502118, 513872, 522710, 523786, 514118, 525377, 502976, 527192, 496820, 516230, 525823, 433694, 442669, 448440, 519046, 499657, 504229, 556000, 560512, 568454, 545072, 563166, 565975, 606017, 418574, 464699, 470019, 428814, 429885, 439906, 460007, 475404, 446455, 450766, 465312, 502477, 508245, 523584, 524688, 525241, 484484, 521414, 521907, 482570, 492531, 503752, 557196, 558515, 439214, 481650, 502594, 510341, 391643, 576013, 606567, 526775, 650291, 523260, 608111, 620024, 555854, 485462);

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
  391643
  397109
  418574
  421821
  422319
  428716
  428814
  429885
  433694
  437204
  439214
  439644
  439906
  441728
  442669
  446455
  446863
  447054
  448440
  450766
  459476
  460007
  464699
  465312
  470019
  475404
  481650
  482570
  484484
  485462
  492531
  496820
  499657
  502118
  502477
  502594
  502976
  503752
  504229
  508245
  510341
  513872
  514118
  516230
  519046
  521414
  521907
  522710
  523260
  523584
  523786
  524688
  525241
  525377
  525823
  526775
  527192
  545072
  555854
  556000
  557196
  558515
  560512
  563166
  565975
  568454
  576013
  606017
  606567
  608111
  620024
  650291
]

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 (391643, 397109, 418574, 421821, 422319, 428716, 428814, 429885, 433694, 437204, 439214, 439644, 439906, 441728, 442669, 446455, 446863, 447054, 448440, 450766, 459476, 460007, 464699, 465312, 470019, 475404, 481650, 482570, 484484, 485462, 492531, 496820, 499657, 502118, 502477, 502594, 502976, 503752, 504229, 508245, 510341, 513872, 514118, 516230, 519046, 521414, 521907, 522710, 523260, 523584, 523786, 524688, 525241, 525377, 525823, 526775, 527192, 545072, 555854, 556000, 557196, 558515, 560512, 563166, 565975, 568454, 576013, 606017, 606567, 608111, 620024, 650291);

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
  391643
  397109
  418574
  421821
  422319
  428716
  428814
  429885
  433694
  437204
  439214
  439644
  439906
  441728
  442669
  446455
  446863
  447054
  448440
  450766
  459476
  460007
  464699
  465312
  470019
  475404
  481650
  482570
  484484
  485462
  492531
  496820
  499657
  502118
  502477
  502594
  502976
  503752
  504229
  508245
  510341
  513872
  514118
  516230
  519046
  521414
  521907
  522710
  523260
  523584
  523786
  524688
  525241
  525377
  525823
  526775
  527192
  545072
  555854
  556000
  557196
  558515
  560512
  563166
  565975
  568454
  576013
  606017
  606567
  608111
  620024
  650291
]

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 (391643, 397109, 418574, 421821, 422319, 428716, 428814, 429885, 433694, 437204, 439214, 439644, 439906, 441728, 442669, 446455, 446863, 447054, 448440, 450766, 459476, 460007, 464699, 465312, 470019, 475404, 481650, 482570, 484484, 485462, 492531, 496820, 499657, 502118, 502477, 502594, 502976, 503752, 504229, 508245, 510341, 513872, 514118, 516230, 519046, 521414, 521907, 522710, 523260, 523584, 523786, 524688, 525241, 525377, 525823, 526775, 527192, 545072, 555854, 556000, 557196, 558515, 560512, 563166, 565975, 568454, 576013, 606017, 606567, 608111, 620024, 650291);

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

[
  "спящ morning"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'спящ morning';

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

[
  "спящ morning"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'спящ morning';