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

[
  "blonde massage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blonde massage' 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
  494202
  648876
  390209
  415893
  454727
  400148
  462812
  568349
  491458
  689584
  395136
  576285
  600379
  601599
  803067
  601524
  430441
  817771
  653244
  622329
  817826
  406206
  392772
  672084
  386070
  402906
  815016
  390898
  437875
  490456
  572014
  421000
  383326
  828417
  511564
  407958
  577320
  495772
  423946
  395564
  406232
  421201
  815288
  457847
  665386
  485455
  489370
  472247
  596423
  414946
  393431
  446004
  399178
  487887
  556049
  525116
  464107
  383483
  577326
  546107
  561666
  563234
  579534
  607079
  438288
  385390
  415188
  533851
  358942
  461108
  520008
  429084
  452100
  559389
  564007
  418686
]

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 (494202, 648876, 390209, 415893, 454727, 400148, 462812, 568349, 491458, 689584, 395136, 576285, 600379, 601599, 803067, 601524, 430441, 817771, 653244, 622329, 817826, 406206, 392772, 672084, 386070, 402906, 815016, 390898, 437875, 490456, 572014, 421000, 383326, 828417, 511564, 407958, 577320, 495772, 423946, 395564, 406232, 421201, 815288, 457847, 665386, 485455, 489370, 472247, 596423, 414946, 393431, 446004, 399178, 487887, 556049, 525116, 464107, 383483, 577326, 546107, 561666, 563234, 579534, 607079, 438288, 385390, 415188, 533851, 358942, 461108, 520008, 429084, 452100, 559389, 564007, 418686);

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
  358942
  383326
  383483
  385390
  386070
  390209
  390898
  392772
  393431
  395136
  395564
  399178
  400148
  402906
  406206
  406232
  407958
  414946
  415188
  415893
  418686
  421000
  421201
  423946
  429084
  430441
  437875
  438288
  446004
  452100
  454727
  457847
  461108
  462812
  464107
  472247
  485455
  487887
  489370
  490456
  491458
  494202
  495772
  511564
  520008
  525116
  533851
  546107
  556049
  559389
  561666
  563234
  564007
  568349
  572014
  576285
  577320
  577326
  579534
  596423
  600379
  601524
  601599
  607079
  622329
  648876
  653244
  665386
  672084
  689584
  803067
  815016
  815288
  817771
  817826
  828417
]

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 (358942, 383326, 383483, 385390, 386070, 390209, 390898, 392772, 393431, 395136, 395564, 399178, 400148, 402906, 406206, 406232, 407958, 414946, 415188, 415893, 418686, 421000, 421201, 423946, 429084, 430441, 437875, 438288, 446004, 452100, 454727, 457847, 461108, 462812, 464107, 472247, 485455, 487887, 489370, 490456, 491458, 494202, 495772, 511564, 520008, 525116, 533851, 546107, 556049, 559389, 561666, 563234, 564007, 568349, 572014, 576285, 577320, 577326, 579534, 596423, 600379, 601524, 601599, 607079, 622329, 648876, 653244, 665386, 672084, 689584, 803067, 815016, 815288, 817771, 817826, 828417);

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
  358942
  383326
  383483
  385390
  386070
  390209
  390898
  392772
  393431
  395136
  395564
  399178
  400148
  402906
  406206
  406232
  407958
  414946
  415188
  415893
  418686
  421000
  421201
  423946
  429084
  430441
  437875
  438288
  446004
  452100
  454727
  457847
  461108
  462812
  464107
  472247
  485455
  487887
  489370
  490456
  491458
  494202
  495772
  511564
  520008
  525116
  533851
  546107
  556049
  559389
  561666
  563234
  564007
  568349
  572014
  576285
  577320
  577326
  579534
  596423
  600379
  601524
  601599
  607079
  622329
  648876
  653244
  665386
  672084
  689584
  803067
  815016
  815288
  817771
  817826
  828417
]

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 (358942, 383326, 383483, 385390, 386070, 390209, 390898, 392772, 393431, 395136, 395564, 399178, 400148, 402906, 406206, 406232, 407958, 414946, 415188, 415893, 418686, 421000, 421201, 423946, 429084, 430441, 437875, 438288, 446004, 452100, 454727, 457847, 461108, 462812, 464107, 472247, 485455, 487887, 489370, 490456, 491458, 494202, 495772, 511564, 520008, 525116, 533851, 546107, 556049, 559389, 561666, 563234, 564007, 568349, 572014, 576285, 577320, 577326, 579534, 596423, 600379, 601524, 601599, 607079, 622329, 648876, 653244, 665386, 672084, 689584, 803067, 815016, 815288, 817771, 817826, 828417);

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` = 'беловолосая массаж';