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

[
  "taxi russian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'taxi russian' 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
  458199
  621278
  810920
  545867
  662429
  788440
  580871
  525471
  809895
  706476
  779334
  785978
  597172
  778200
  499414
  738957
  504355
  663341
  487155
  520949
  461891
  566491
  687854
  614694
  520281
  729441
  518787
  799005
  462576
  463101
  382212
  793202
  491394
  520522
  483854
  719471
  487758
  788120
  497284
  459583
  479481
  568847
  470288
  518109
  477738
  584661
  727018
  487710
  519415
  459222
  794091
  526433
  602774
  472107
  569587
  555977
  723933
  457069
  443892
  502989
  526350
  555895
  558505
  456039
  475009
  457349
  527609
  610629
  620836
  510042
  550475
  618941
  600035
]

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 (458199, 621278, 810920, 545867, 662429, 788440, 580871, 525471, 809895, 706476, 779334, 785978, 597172, 778200, 499414, 738957, 504355, 663341, 487155, 520949, 461891, 566491, 687854, 614694, 520281, 729441, 518787, 799005, 462576, 463101, 382212, 793202, 491394, 520522, 483854, 719471, 487758, 788120, 497284, 459583, 479481, 568847, 470288, 518109, 477738, 584661, 727018, 487710, 519415, 459222, 794091, 526433, 602774, 472107, 569587, 555977, 723933, 457069, 443892, 502989, 526350, 555895, 558505, 456039, 475009, 457349, 527609, 610629, 620836, 510042, 550475, 618941, 600035);

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
  382212
  443892
  456039
  457069
  457349
  458199
  459222
  459583
  461891
  462576
  463101
  470288
  472107
  475009
  477738
  479481
  483854
  487155
  487710
  487758
  491394
  497284
  499414
  502989
  504355
  510042
  518109
  518787
  519415
  520281
  520522
  520949
  525471
  526350
  526433
  527609
  545867
  550475
  555895
  555977
  558505
  566491
  568847
  569587
  580871
  584661
  597172
  600035
  602774
  610629
  614694
  618941
  620836
  621278
  662429
  663341
  687854
  706476
  719471
  723933
  727018
  729441
  738957
  778200
  779334
  785978
  788120
  788440
  793202
  794091
  799005
  809895
  810920
]

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 (382212, 443892, 456039, 457069, 457349, 458199, 459222, 459583, 461891, 462576, 463101, 470288, 472107, 475009, 477738, 479481, 483854, 487155, 487710, 487758, 491394, 497284, 499414, 502989, 504355, 510042, 518109, 518787, 519415, 520281, 520522, 520949, 525471, 526350, 526433, 527609, 545867, 550475, 555895, 555977, 558505, 566491, 568847, 569587, 580871, 584661, 597172, 600035, 602774, 610629, 614694, 618941, 620836, 621278, 662429, 663341, 687854, 706476, 719471, 723933, 727018, 729441, 738957, 778200, 779334, 785978, 788120, 788440, 793202, 794091, 799005, 809895, 810920);

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
  382212
  443892
  456039
  457069
  457349
  458199
  459222
  459583
  461891
  462576
  463101
  470288
  472107
  475009
  477738
  479481
  483854
  487155
  487710
  487758
  491394
  497284
  499414
  502989
  504355
  510042
  518109
  518787
  519415
  520281
  520522
  520949
  525471
  526350
  526433
  527609
  545867
  550475
  555895
  555977
  558505
  566491
  568847
  569587
  580871
  584661
  597172
  600035
  602774
  610629
  614694
  618941
  620836
  621278
  662429
  663341
  687854
  706476
  719471
  723933
  727018
  729441
  738957
  778200
  779334
  785978
  788120
  788440
  793202
  794091
  799005
  809895
  810920
]

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 (382212, 443892, 456039, 457069, 457349, 458199, 459222, 459583, 461891, 462576, 463101, 470288, 472107, 475009, 477738, 479481, 483854, 487155, 487710, 487758, 491394, 497284, 499414, 502989, 504355, 510042, 518109, 518787, 519415, 520281, 520522, 520949, 525471, 526350, 526433, 527609, 545867, 550475, 555895, 555977, 558505, 566491, 568847, 569587, 580871, 584661, 597172, 600035, 602774, 610629, 614694, 618941, 620836, 621278, 662429, 663341, 687854, 706476, 719471, 723933, 727018, 729441, 738957, 778200, 779334, 785978, 788120, 788440, 793202, 794091, 799005, 809895, 810920);

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` = 'в такс машин русск';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "taxi russian"
  "taxi russian"
  "taxi russian"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('taxi russian') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('taxi russian')
              AND `query` <> 'taxi russian'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;