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
  518541
  507221
  520014
  527151
  548569
  548545
  558235
  586468
  593541
  593368
  593625
  586474
  600258
  619180
  631923
  641130
  424644
  414375
  420604
  490864
  492515
  492002
  515281
  498222
  524016
  388449
  469852
  501465
  553720
  562030
  640690
  586472
  586494
  586503
  593470
  480461
  472616
  499814
  486399
  520313
  489097
  494768
  515226
  524511
  418953
  508335
  583677
  598853
  593487
  518275
  494695
  516442
  494770
  553703
  560408
  548538
  573315
  430437
  519194
  545695
  586429
  494778
  498039
  575194
  546794
  586440
  527451
  511009
  491854
  593372
  515119
  565186
  586484
]

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 (518541, 507221, 520014, 527151, 548569, 548545, 558235, 586468, 593541, 593368, 593625, 586474, 600258, 619180, 631923, 641130, 424644, 414375, 420604, 490864, 492515, 492002, 515281, 498222, 524016, 388449, 469852, 501465, 553720, 562030, 640690, 586472, 586494, 586503, 593470, 480461, 472616, 499814, 486399, 520313, 489097, 494768, 515226, 524511, 418953, 508335, 583677, 598853, 593487, 518275, 494695, 516442, 494770, 553703, 560408, 548538, 573315, 430437, 519194, 545695, 586429, 494778, 498039, 575194, 546794, 586440, 527451, 511009, 491854, 593372, 515119, 565186, 586484);

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
  388449
  414375
  418953
  420604
  424644
  430437
  469852
  472616
  480461
  486399
  489097
  490864
  491854
  492002
  492515
  494695
  494768
  494770
  494778
  498039
  498222
  499814
  501465
  507221
  508335
  511009
  515119
  515226
  515281
  516442
  518275
  518541
  519194
  520014
  520313
  524016
  524511
  527151
  527451
  545695
  546794
  548538
  548545
  548569
  553703
  553720
  558235
  560408
  562030
  565186
  573315
  575194
  583677
  586429
  586440
  586468
  586472
  586474
  586484
  586494
  586503
  593368
  593372
  593470
  593487
  593541
  593625
  598853
  600258
  619180
  631923
  640690
  641130
]

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 (388449, 414375, 418953, 420604, 424644, 430437, 469852, 472616, 480461, 486399, 489097, 490864, 491854, 492002, 492515, 494695, 494768, 494770, 494778, 498039, 498222, 499814, 501465, 507221, 508335, 511009, 515119, 515226, 515281, 516442, 518275, 518541, 519194, 520014, 520313, 524016, 524511, 527151, 527451, 545695, 546794, 548538, 548545, 548569, 553703, 553720, 558235, 560408, 562030, 565186, 573315, 575194, 583677, 586429, 586440, 586468, 586472, 586474, 586484, 586494, 586503, 593368, 593372, 593470, 593487, 593541, 593625, 598853, 600258, 619180, 631923, 640690, 641130);

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
  388449
  414375
  418953
  420604
  424644
  430437
  469852
  472616
  480461
  486399
  489097
  490864
  491854
  492002
  492515
  494695
  494768
  494770
  494778
  498039
  498222
  499814
  501465
  507221
  508335
  511009
  515119
  515226
  515281
  516442
  518275
  518541
  519194
  520014
  520313
  524016
  524511
  527151
  527451
  545695
  546794
  548538
  548545
  548569
  553703
  553720
  558235
  560408
  562030
  565186
  573315
  575194
  583677
  586429
  586440
  586468
  586472
  586474
  586484
  586494
  586503
  593368
  593372
  593470
  593487
  593541
  593625
  598853
  600258
  619180
  631923
  640690
  641130
]

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 (388449, 414375, 418953, 420604, 424644, 430437, 469852, 472616, 480461, 486399, 489097, 490864, 491854, 492002, 492515, 494695, 494768, 494770, 494778, 498039, 498222, 499814, 501465, 507221, 508335, 511009, 515119, 515226, 515281, 516442, 518275, 518541, 519194, 520014, 520313, 524016, 524511, 527151, 527451, 545695, 546794, 548538, 548545, 548569, 553703, 553720, 558235, 560408, 562030, 565186, 573315, 575194, 583677, 586429, 586440, 586468, 586472, 586474, 586484, 586494, 586503, 593368, 593372, 593470, 593487, 593541, 593625, 598853, 600258, 619180, 631923, 640690, 641130);

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 ?

[
  "врачу"
  "врачу"
  "врачу"
  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 ('врачу') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('врачу')
              AND `query` <> 'врачу'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;