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
  725513
  725467
  740229
  725476
  727044
  758307
  365881
  390206
  474091
  610404
  473436
  503485
  605846
  795983
  725442
  731083
  761325
  725500
  755022
  731073
  623461
  715059
  808681
  494175
  494193
  559066
  400851
  423106
  517076
  400998
  427364
  421870
  483656
  495226
  495227
  549836
  725152
  725514
  392004
  428821
  476256
  388500
  475568
  513341
  411376
  442913
  487321
  424457
  447949
  526738
  491986
  544489
  678716
  627660
  725471
  746126
  758173
  428890
  421899
  433220
  423974
  522744
  483382
  486333
  489384
  493174
  493971
  454141
  485274
  530449
  516477
  466014
  520878
  490916
  470203
  484643
  466310
  440726
]

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 (725513, 725467, 740229, 725476, 727044, 758307, 365881, 390206, 474091, 610404, 473436, 503485, 605846, 795983, 725442, 731083, 761325, 725500, 755022, 731073, 623461, 715059, 808681, 494175, 494193, 559066, 400851, 423106, 517076, 400998, 427364, 421870, 483656, 495226, 495227, 549836, 725152, 725514, 392004, 428821, 476256, 388500, 475568, 513341, 411376, 442913, 487321, 424457, 447949, 526738, 491986, 544489, 678716, 627660, 725471, 746126, 758173, 428890, 421899, 433220, 423974, 522744, 483382, 486333, 489384, 493174, 493971, 454141, 485274, 530449, 516477, 466014, 520878, 490916, 470203, 484643, 466310, 440726);

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
  365881
  388500
  390206
  392004
  400851
  400998
  411376
  421870
  421899
  423106
  423974
  424457
  427364
  428821
  428890
  433220
  440726
  442913
  447949
  454141
  466014
  466310
  470203
  473436
  474091
  475568
  476256
  483382
  483656
  484643
  485274
  486333
  487321
  489384
  490916
  491986
  493174
  493971
  494175
  494193
  495226
  495227
  503485
  513341
  516477
  517076
  520878
  522744
  526738
  530449
  544489
  549836
  559066
  605846
  610404
  623461
  627660
  678716
  715059
  725152
  725442
  725467
  725471
  725476
  725500
  725513
  725514
  727044
  731073
  731083
  740229
  746126
  755022
  758173
  758307
  761325
  795983
  808681
]

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 (365881, 388500, 390206, 392004, 400851, 400998, 411376, 421870, 421899, 423106, 423974, 424457, 427364, 428821, 428890, 433220, 440726, 442913, 447949, 454141, 466014, 466310, 470203, 473436, 474091, 475568, 476256, 483382, 483656, 484643, 485274, 486333, 487321, 489384, 490916, 491986, 493174, 493971, 494175, 494193, 495226, 495227, 503485, 513341, 516477, 517076, 520878, 522744, 526738, 530449, 544489, 549836, 559066, 605846, 610404, 623461, 627660, 678716, 715059, 725152, 725442, 725467, 725471, 725476, 725500, 725513, 725514, 727044, 731073, 731083, 740229, 746126, 755022, 758173, 758307, 761325, 795983, 808681);

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
  365881
  388500
  390206
  392004
  400851
  400998
  411376
  421870
  421899
  423106
  423974
  424457
  427364
  428821
  428890
  433220
  440726
  442913
  447949
  454141
  466014
  466310
  470203
  473436
  474091
  475568
  476256
  483382
  483656
  484643
  485274
  486333
  487321
  489384
  490916
  491986
  493174
  493971
  494175
  494193
  495226
  495227
  503485
  513341
  516477
  517076
  520878
  522744
  526738
  530449
  544489
  549836
  559066
  605846
  610404
  623461
  627660
  678716
  715059
  725152
  725442
  725467
  725471
  725476
  725500
  725513
  725514
  727044
  731073
  731083
  740229
  746126
  755022
  758173
  758307
  761325
  795983
  808681
]

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 (365881, 388500, 390206, 392004, 400851, 400998, 411376, 421870, 421899, 423106, 423974, 424457, 427364, 428821, 428890, 433220, 440726, 442913, 447949, 454141, 466014, 466310, 470203, 473436, 474091, 475568, 476256, 483382, 483656, 484643, 485274, 486333, 487321, 489384, 490916, 491986, 493174, 493971, 494175, 494193, 495226, 495227, 503485, 513341, 516477, 517076, 520878, 522744, 526738, 530449, 544489, 549836, 559066, 605846, 610404, 623461, 627660, 678716, 715059, 725152, 725442, 725467, 725471, 725476, 725500, 725513, 725514, 727044, 731073, 731083, 740229, 746126, 755022, 758173, 758307, 761325, 795983, 808681);

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` = 'русск полная колготк';