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
  448211
  465395
  422187
  502596
  484462
  484625
  502882
  520599
  525317
  526057
  484441
  528380
  493177
  500441
  415722
  462734
  511075
  444185
  453242
  552783
  488249
  480702
  555123
  565751
  577612
  591966
  474076
  465807
  519547
  522999
  527377
  489176
  516852
  519512
  571956
  490250
  533600
  527713
  456427
  453723
  474896
  524235
  621222
  625321
  602063
  466836
  526520
  503388
  513517
  484711
  496934
  513474
  492587
  574912
  575451
  528384
  465360
  511875
  472328
  466069
  624150
  566870
  476797
  563695
  620216
  620674
  514577
  584636
  603756
  622184
  500562
  563440
  653544
  464564
  455195
  623357
]

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 (448211, 465395, 422187, 502596, 484462, 484625, 502882, 520599, 525317, 526057, 484441, 528380, 493177, 500441, 415722, 462734, 511075, 444185, 453242, 552783, 488249, 480702, 555123, 565751, 577612, 591966, 474076, 465807, 519547, 522999, 527377, 489176, 516852, 519512, 571956, 490250, 533600, 527713, 456427, 453723, 474896, 524235, 621222, 625321, 602063, 466836, 526520, 503388, 513517, 484711, 496934, 513474, 492587, 574912, 575451, 528384, 465360, 511875, 472328, 466069, 624150, 566870, 476797, 563695, 620216, 620674, 514577, 584636, 603756, 622184, 500562, 563440, 653544, 464564, 455195, 623357);

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
  415722
  422187
  444185
  448211
  453242
  453723
  455195
  456427
  462734
  464564
  465360
  465395
  465807
  466069
  466836
  472328
  474076
  474896
  476797
  480702
  484441
  484462
  484625
  484711
  488249
  489176
  490250
  492587
  493177
  496934
  500441
  500562
  502596
  502882
  503388
  511075
  511875
  513474
  513517
  514577
  516852
  519512
  519547
  520599
  522999
  524235
  525317
  526057
  526520
  527377
  527713
  528380
  528384
  533600
  552783
  555123
  563440
  563695
  565751
  566870
  571956
  574912
  575451
  577612
  584636
  591966
  602063
  603756
  620216
  620674
  621222
  622184
  623357
  624150
  625321
  653544
]

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 (415722, 422187, 444185, 448211, 453242, 453723, 455195, 456427, 462734, 464564, 465360, 465395, 465807, 466069, 466836, 472328, 474076, 474896, 476797, 480702, 484441, 484462, 484625, 484711, 488249, 489176, 490250, 492587, 493177, 496934, 500441, 500562, 502596, 502882, 503388, 511075, 511875, 513474, 513517, 514577, 516852, 519512, 519547, 520599, 522999, 524235, 525317, 526057, 526520, 527377, 527713, 528380, 528384, 533600, 552783, 555123, 563440, 563695, 565751, 566870, 571956, 574912, 575451, 577612, 584636, 591966, 602063, 603756, 620216, 620674, 621222, 622184, 623357, 624150, 625321, 653544);

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
  415722
  422187
  444185
  448211
  453242
  453723
  455195
  456427
  462734
  464564
  465360
  465395
  465807
  466069
  466836
  472328
  474076
  474896
  476797
  480702
  484441
  484462
  484625
  484711
  488249
  489176
  490250
  492587
  493177
  496934
  500441
  500562
  502596
  502882
  503388
  511075
  511875
  513474
  513517
  514577
  516852
  519512
  519547
  520599
  522999
  524235
  525317
  526057
  526520
  527377
  527713
  528380
  528384
  533600
  552783
  555123
  563440
  563695
  565751
  566870
  571956
  574912
  575451
  577612
  584636
  591966
  602063
  603756
  620216
  620674
  621222
  622184
  623357
  624150
  625321
  653544
]

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 (415722, 422187, 444185, 448211, 453242, 453723, 455195, 456427, 462734, 464564, 465360, 465395, 465807, 466069, 466836, 472328, 474076, 474896, 476797, 480702, 484441, 484462, 484625, 484711, 488249, 489176, 490250, 492587, 493177, 496934, 500441, 500562, 502596, 502882, 503388, 511075, 511875, 513474, 513517, 514577, 516852, 519512, 519547, 520599, 522999, 524235, 525317, 526057, 526520, 527377, 527713, 528380, 528384, 533600, 552783, 555123, 563440, 563695, 565751, 566870, 571956, 574912, 575451, 577612, 584636, 591966, 602063, 603756, 620216, 620674, 621222, 622184, 623357, 624150, 625321, 653544);

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` = 'жен дава';