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

[
  "anal stockings home"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal stockings home' 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
  258915
  536888
  673345
  750498
  817556
  670727
  765322
  485073
  464240
  456520
  440898
  792432
  464837
  418519
  766702
  725197
  496061
  521664
  452264
  685832
  447095
  400506
  440889
  468070
  483908
  790926
  762277
  788860
  770882
  439577
  437558
  794101
  537232
  411561
  509566
  526101
  497480
  491943
  679659
  791809
  498468
  726881
  788580
  429441
  465947
  498474
  440893
  443085
  549782
  693278
  694715
  725568
  748695
  494833
  485420
  439586
  473950
  443858
  484821
  397901
  512023
  403588
  535445
  462526
  575076
  440956
  405699
  476861
  426361
  428229
  528143
  439710
  516320
  807326
  548226
  461061
  720245
  775819
  435027
  462840
  509970
  601848
  517833
  643933
  446682
  457165
  645920
  451866
  493300
]

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 (258915, 536888, 673345, 750498, 817556, 670727, 765322, 485073, 464240, 456520, 440898, 792432, 464837, 418519, 766702, 725197, 496061, 521664, 452264, 685832, 447095, 400506, 440889, 468070, 483908, 790926, 762277, 788860, 770882, 439577, 437558, 794101, 537232, 411561, 509566, 526101, 497480, 491943, 679659, 791809, 498468, 726881, 788580, 429441, 465947, 498474, 440893, 443085, 549782, 693278, 694715, 725568, 748695, 494833, 485420, 439586, 473950, 443858, 484821, 397901, 512023, 403588, 535445, 462526, 575076, 440956, 405699, 476861, 426361, 428229, 528143, 439710, 516320, 807326, 548226, 461061, 720245, 775819, 435027, 462840, 509970, 601848, 517833, 643933, 446682, 457165, 645920, 451866, 493300);

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
  258915
  397901
  400506
  403588
  405699
  411561
  418519
  426361
  428229
  429441
  435027
  437558
  439577
  439586
  439710
  440889
  440893
  440898
  440956
  443085
  443858
  446682
  447095
  451866
  452264
  457165
  461061
  462526
  462840
  464240
  464837
  465947
  468070
  473950
  476861
  483908
  484821
  485073
  485420
  491943
  493300
  494833
  496061
  497480
  498468
  498474
  509566
  509970
  512023
  516320
  517833
  521664
  526101
  528143
  535445
  536888
  537232
  548226
  549782
  575076
  601848
  643933
  645920
  670727
  673345
  679659
  685832
  693278
  694715
  720245
  725197
  725568
  726881
  748695
  750498
  762277
  765322
  766702
  770882
  775819
  788580
  788860
  790926
  791809
  792432
  794101
  807326
  817556
]

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 (258915, 397901, 400506, 403588, 405699, 411561, 418519, 426361, 428229, 429441, 435027, 437558, 439577, 439586, 439710, 440889, 440893, 440898, 440956, 443085, 443858, 446682, 447095, 451866, 452264, 457165, 461061, 462526, 462840, 464240, 464837, 465947, 468070, 473950, 476861, 483908, 484821, 485073, 485420, 491943, 493300, 494833, 496061, 497480, 498468, 498474, 509566, 509970, 512023, 516320, 517833, 521664, 526101, 528143, 535445, 536888, 537232, 548226, 549782, 575076, 601848, 643933, 645920, 670727, 673345, 679659, 685832, 693278, 694715, 720245, 725197, 725568, 726881, 748695, 750498, 762277, 765322, 766702, 770882, 775819, 788580, 788860, 790926, 791809, 792432, 794101, 807326, 817556);

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
  258915
  397901
  400506
  403588
  405699
  411561
  418519
  426361
  428229
  429441
  435027
  437558
  439577
  439586
  439710
  440889
  440893
  440898
  440956
  443085
  443858
  446682
  447095
  451866
  452264
  457165
  461061
  462526
  462840
  464240
  464837
  465947
  468070
  473950
  476861
  483908
  484821
  485073
  485420
  491943
  493300
  494833
  496061
  497480
  498468
  498474
  509566
  509970
  512023
  516320
  517833
  521664
  526101
  528143
  535445
  536888
  537232
  548226
  549782
  575076
  601848
  643933
  645920
  670727
  673345
  679659
  685832
  693278
  694715
  720245
  725197
  725568
  726881
  748695
  750498
  762277
  765322
  766702
  770882
  775819
  788580
  788860
  790926
  791809
  792432
  794101
  807326
  817556
]

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 (258915, 397901, 400506, 403588, 405699, 411561, 418519, 426361, 428229, 429441, 435027, 437558, 439577, 439586, 439710, 440889, 440893, 440898, 440956, 443085, 443858, 446682, 447095, 451866, 452264, 457165, 461061, 462526, 462840, 464240, 464837, 465947, 468070, 473950, 476861, 483908, 484821, 485073, 485420, 491943, 493300, 494833, 496061, 497480, 498468, 498474, 509566, 509970, 512023, 516320, 517833, 521664, 526101, 528143, 535445, 536888, 537232, 548226, 549782, 575076, 601848, 643933, 645920, 670727, 673345, 679659, 685832, 693278, 694715, 720245, 725197, 725568, 726881, 748695, 750498, 762277, 765322, 766702, 770882, 775819, 788580, 788860, 790926, 791809, 792432, 794101, 807326, 817556);

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

[
  "анал чулк нижн бел home"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал чулк нижн бел home';

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

[
  "анал чулк нижн бел home"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал чулк нижн бел home';