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

[
  "car panties"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'car panties' 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
  390810
  423963
  487096
  503059
  514281
  494658
  565765
  575424
  584570
  561260
  675280
  555203
  455733
  445708
  531608
  457645
  467142
  594887
  492153
  617431
  581571
  657775
  555977
  564481
  453321
  590789
  417811
  417904
  443892
  459856
  502024
  525415
  544855
  568717
  668382
  593506
  592605
  613777
  612044
  599758
  568506
  580148
  634794
  539447
  498899
  529222
  553765
  682136
  560138
  601213
  605936
  605941
  615182
  443639
  587933
  480394
  563527
  477170
  689149
  625968
  614434
  525104
  553446
  612472
  455808
  515894
  476613
  462785
  569047
  599826
  420472
  555986
  576304
  435962
  528031
  458324
  537224
  453340
  623692
  396168
]

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 (390810, 423963, 487096, 503059, 514281, 494658, 565765, 575424, 584570, 561260, 675280, 555203, 455733, 445708, 531608, 457645, 467142, 594887, 492153, 617431, 581571, 657775, 555977, 564481, 453321, 590789, 417811, 417904, 443892, 459856, 502024, 525415, 544855, 568717, 668382, 593506, 592605, 613777, 612044, 599758, 568506, 580148, 634794, 539447, 498899, 529222, 553765, 682136, 560138, 601213, 605936, 605941, 615182, 443639, 587933, 480394, 563527, 477170, 689149, 625968, 614434, 525104, 553446, 612472, 455808, 515894, 476613, 462785, 569047, 599826, 420472, 555986, 576304, 435962, 528031, 458324, 537224, 453340, 623692, 396168);

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
  390810
  396168
  417811
  417904
  420472
  423963
  435962
  443639
  443892
  445708
  453321
  453340
  455733
  455808
  457645
  458324
  459856
  462785
  467142
  476613
  477170
  480394
  487096
  492153
  494658
  498899
  502024
  503059
  514281
  515894
  525104
  525415
  528031
  529222
  531608
  537224
  539447
  544855
  553446
  553765
  555203
  555977
  555986
  560138
  561260
  563527
  564481
  565765
  568506
  568717
  569047
  575424
  576304
  580148
  581571
  584570
  587933
  590789
  592605
  593506
  594887
  599758
  599826
  601213
  605936
  605941
  612044
  612472
  613777
  614434
  615182
  617431
  623692
  625968
  634794
  657775
  668382
  675280
  682136
  689149
]

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 (390810, 396168, 417811, 417904, 420472, 423963, 435962, 443639, 443892, 445708, 453321, 453340, 455733, 455808, 457645, 458324, 459856, 462785, 467142, 476613, 477170, 480394, 487096, 492153, 494658, 498899, 502024, 503059, 514281, 515894, 525104, 525415, 528031, 529222, 531608, 537224, 539447, 544855, 553446, 553765, 555203, 555977, 555986, 560138, 561260, 563527, 564481, 565765, 568506, 568717, 569047, 575424, 576304, 580148, 581571, 584570, 587933, 590789, 592605, 593506, 594887, 599758, 599826, 601213, 605936, 605941, 612044, 612472, 613777, 614434, 615182, 617431, 623692, 625968, 634794, 657775, 668382, 675280, 682136, 689149);

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
  390810
  396168
  417811
  417904
  420472
  423963
  435962
  443639
  443892
  445708
  453321
  453340
  455733
  455808
  457645
  458324
  459856
  462785
  467142
  476613
  477170
  480394
  487096
  492153
  494658
  498899
  502024
  503059
  514281
  515894
  525104
  525415
  528031
  529222
  531608
  537224
  539447
  544855
  553446
  553765
  555203
  555977
  555986
  560138
  561260
  563527
  564481
  565765
  568506
  568717
  569047
  575424
  576304
  580148
  581571
  584570
  587933
  590789
  592605
  593506
  594887
  599758
  599826
  601213
  605936
  605941
  612044
  612472
  613777
  614434
  615182
  617431
  623692
  625968
  634794
  657775
  668382
  675280
  682136
  689149
]

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 (390810, 396168, 417811, 417904, 420472, 423963, 435962, 443639, 443892, 445708, 453321, 453340, 455733, 455808, 457645, 458324, 459856, 462785, 467142, 476613, 477170, 480394, 487096, 492153, 494658, 498899, 502024, 503059, 514281, 515894, 525104, 525415, 528031, 529222, 531608, 537224, 539447, 544855, 553446, 553765, 555203, 555977, 555986, 560138, 561260, 563527, 564481, 565765, 568506, 568717, 569047, 575424, 576304, 580148, 581571, 584570, 587933, 590789, 592605, 593506, 594887, 599758, 599826, 601213, 605936, 605941, 612044, 612472, 613777, 614434, 615182, 617431, 623692, 625968, 634794, 657775, 668382, 675280, 682136, 689149);

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