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

[
  "hairy stockings solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy stockings solo' 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
  598416
  607218
  589670
  593034
  596050
  808166
  475678
  475680
  472421
  497831
  493961
  776212
  722373
  626885
  509983
  471128
  464978
  491102
  558176
  521798
  494206
  811112
  469737
  476671
  505356
  475667
  623610
  642403
  434365
  391992
  429916
  523762
  509218
  585386
  466643
  456516
  391911
  182206
  463976
  584301
  392676
  427147
  424198
  426295
  464971
  475683
  480226
  558172
  559350
  576128
  594549
  801610
  392007
  460208
  502467
  487758
  459388
  555055
  511272
  508807
  742636
  457292
  462840
  509970
  620754
  634071
  471976
  391945
  453409
  467878
  520138
  455381
  528452
  578198
  434352
  593921
  607276
  483474
  598649
  473391
  469198
  407442
]

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 (598416, 607218, 589670, 593034, 596050, 808166, 475678, 475680, 472421, 497831, 493961, 776212, 722373, 626885, 509983, 471128, 464978, 491102, 558176, 521798, 494206, 811112, 469737, 476671, 505356, 475667, 623610, 642403, 434365, 391992, 429916, 523762, 509218, 585386, 466643, 456516, 391911, 182206, 463976, 584301, 392676, 427147, 424198, 426295, 464971, 475683, 480226, 558172, 559350, 576128, 594549, 801610, 392007, 460208, 502467, 487758, 459388, 555055, 511272, 508807, 742636, 457292, 462840, 509970, 620754, 634071, 471976, 391945, 453409, 467878, 520138, 455381, 528452, 578198, 434352, 593921, 607276, 483474, 598649, 473391, 469198, 407442);

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
  182206
  391911
  391945
  391992
  392007
  392676
  407442
  424198
  426295
  427147
  429916
  434352
  434365
  453409
  455381
  456516
  457292
  459388
  460208
  462840
  463976
  464971
  464978
  466643
  467878
  469198
  469737
  471128
  471976
  472421
  473391
  475667
  475678
  475680
  475683
  476671
  480226
  483474
  487758
  491102
  493961
  494206
  497831
  502467
  505356
  508807
  509218
  509970
  509983
  511272
  520138
  521798
  523762
  528452
  555055
  558172
  558176
  559350
  576128
  578198
  584301
  585386
  589670
  593034
  593921
  594549
  596050
  598416
  598649
  607218
  607276
  620754
  623610
  626885
  634071
  642403
  722373
  742636
  776212
  801610
  808166
  811112
]

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 (182206, 391911, 391945, 391992, 392007, 392676, 407442, 424198, 426295, 427147, 429916, 434352, 434365, 453409, 455381, 456516, 457292, 459388, 460208, 462840, 463976, 464971, 464978, 466643, 467878, 469198, 469737, 471128, 471976, 472421, 473391, 475667, 475678, 475680, 475683, 476671, 480226, 483474, 487758, 491102, 493961, 494206, 497831, 502467, 505356, 508807, 509218, 509970, 509983, 511272, 520138, 521798, 523762, 528452, 555055, 558172, 558176, 559350, 576128, 578198, 584301, 585386, 589670, 593034, 593921, 594549, 596050, 598416, 598649, 607218, 607276, 620754, 623610, 626885, 634071, 642403, 722373, 742636, 776212, 801610, 808166, 811112);

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
  182206
  391911
  391945
  391992
  392007
  392676
  407442
  424198
  426295
  427147
  429916
  434352
  434365
  453409
  455381
  456516
  457292
  459388
  460208
  462840
  463976
  464971
  464978
  466643
  467878
  469198
  469737
  471128
  471976
  472421
  473391
  475667
  475678
  475680
  475683
  476671
  480226
  483474
  487758
  491102
  493961
  494206
  497831
  502467
  505356
  508807
  509218
  509970
  509983
  511272
  520138
  521798
  523762
  528452
  555055
  558172
  558176
  559350
  576128
  578198
  584301
  585386
  589670
  593034
  593921
  594549
  596050
  598416
  598649
  607218
  607276
  620754
  623610
  626885
  634071
  642403
  722373
  742636
  776212
  801610
  808166
  811112
]

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 (182206, 391911, 391945, 391992, 392007, 392676, 407442, 424198, 426295, 427147, 429916, 434352, 434365, 453409, 455381, 456516, 457292, 459388, 460208, 462840, 463976, 464971, 464978, 466643, 467878, 469198, 469737, 471128, 471976, 472421, 473391, 475667, 475678, 475680, 475683, 476671, 480226, 483474, 487758, 491102, 493961, 494206, 497831, 502467, 505356, 508807, 509218, 509970, 509983, 511272, 520138, 521798, 523762, 528452, 555055, 558172, 558176, 559350, 576128, 578198, 584301, 585386, 589670, 593034, 593921, 594549, 596050, 598416, 598649, 607218, 607276, 620754, 623610, 626885, 634071, 642403, 722373, 742636, 776212, 801610, 808166, 811112);

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