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

[
  "white bra"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'white bra' 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
  472597
  417513
  410094
  424884
  445895
  460082
  460592
  454992
  472783
  490324
  504572
  502618
  522600
  469560
  548046
  463663
  463673
  434793
  445646
  423979
  473944
  409995
  437671
  501713
  483323
  484587
  497961
  484580
  500854
  517128
  489391
  497837
  498212
  525064
  526361
  502283
  511991
  501119
  383272
  390147
  407566
  424302
  452566
  452642
  513155
  512085
  447104
  455041
  515908
  484690
  525693
  526727
  523360
  428756
  519908
  447508
  429934
  482131
  466133
  523109
  486341
  496269
  501548
  482388
  502738
  510498
  485700
  489280
  467553
  531461
  504610
  526811
  486298
  522382
  466791
]

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 (472597, 417513, 410094, 424884, 445895, 460082, 460592, 454992, 472783, 490324, 504572, 502618, 522600, 469560, 548046, 463663, 463673, 434793, 445646, 423979, 473944, 409995, 437671, 501713, 483323, 484587, 497961, 484580, 500854, 517128, 489391, 497837, 498212, 525064, 526361, 502283, 511991, 501119, 383272, 390147, 407566, 424302, 452566, 452642, 513155, 512085, 447104, 455041, 515908, 484690, 525693, 526727, 523360, 428756, 519908, 447508, 429934, 482131, 466133, 523109, 486341, 496269, 501548, 482388, 502738, 510498, 485700, 489280, 467553, 531461, 504610, 526811, 486298, 522382, 466791);

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
  383272
  390147
  407566
  409995
  410094
  417513
  423979
  424302
  424884
  428756
  429934
  434793
  437671
  445646
  445895
  447104
  447508
  452566
  452642
  454992
  455041
  460082
  460592
  463663
  463673
  466133
  466791
  467553
  469560
  472597
  472783
  473944
  482131
  482388
  483323
  484580
  484587
  484690
  485700
  486298
  486341
  489280
  489391
  490324
  496269
  497837
  497961
  498212
  500854
  501119
  501548
  501713
  502283
  502618
  502738
  504572
  504610
  510498
  511991
  512085
  513155
  515908
  517128
  519908
  522382
  522600
  523109
  523360
  525064
  525693
  526361
  526727
  526811
  531461
  548046
]

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 (383272, 390147, 407566, 409995, 410094, 417513, 423979, 424302, 424884, 428756, 429934, 434793, 437671, 445646, 445895, 447104, 447508, 452566, 452642, 454992, 455041, 460082, 460592, 463663, 463673, 466133, 466791, 467553, 469560, 472597, 472783, 473944, 482131, 482388, 483323, 484580, 484587, 484690, 485700, 486298, 486341, 489280, 489391, 490324, 496269, 497837, 497961, 498212, 500854, 501119, 501548, 501713, 502283, 502618, 502738, 504572, 504610, 510498, 511991, 512085, 513155, 515908, 517128, 519908, 522382, 522600, 523109, 523360, 525064, 525693, 526361, 526727, 526811, 531461, 548046);

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
  383272
  390147
  407566
  409995
  410094
  417513
  423979
  424302
  424884
  428756
  429934
  434793
  437671
  445646
  445895
  447104
  447508
  452566
  452642
  454992
  455041
  460082
  460592
  463663
  463673
  466133
  466791
  467553
  469560
  472597
  472783
  473944
  482131
  482388
  483323
  484580
  484587
  484690
  485700
  486298
  486341
  489280
  489391
  490324
  496269
  497837
  497961
  498212
  500854
  501119
  501548
  501713
  502283
  502618
  502738
  504572
  504610
  510498
  511991
  512085
  513155
  515908
  517128
  519908
  522382
  522600
  523109
  523360
  525064
  525693
  526361
  526727
  526811
  531461
  548046
]

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 (383272, 390147, 407566, 409995, 410094, 417513, 423979, 424302, 424884, 428756, 429934, 434793, 437671, 445646, 445895, 447104, 447508, 452566, 452642, 454992, 455041, 460082, 460592, 463663, 463673, 466133, 466791, 467553, 469560, 472597, 472783, 473944, 482131, 482388, 483323, 484580, 484587, 484690, 485700, 486298, 486341, 489280, 489391, 490324, 496269, 497837, 497961, 498212, 500854, 501119, 501548, 501713, 502283, 502618, 502738, 504572, 504610, 510498, 511991, 512085, 513155, 515908, 517128, 519908, 522382, 522600, 523109, 523360, 525064, 525693, 526361, 526727, 526811, 531461, 548046);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "white бюстгалтер нижн бел"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'white бюстгалтер нижн бел';

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

[
  "white бюстгалтер нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'white бюстгалтер нижн бел';