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

[
  "squirt teen amateur"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'squirt teen amateur' 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
  766939
  598786
  564049
  586121
  444853
  627442
  497030
  589886
  452729
  813207
  787506
  515548
  634029
  528496
  573212
  506692
  562585
  568707
  779996
  588071
  439240
  752648
  451254
  527927
  632095
  494081
  591604
  605367
  715790
  515444
  427174
  449946
  712633
  715812
  806931
  449531
  628553
  806173
  429445
  419646
  503576
  505317
  524320
  513098
  814434
  516666
  560969
  621765
  599412
  755079
  455549
  435916
  779840
  418601
  514090
  517572
  547496
  595209
  482283
  582631
  429844
  447004
  506082
  450323
  447077
  573461
  515761
  556505
  442673
  424385
  591680
  609892
  632304
]

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 (766939, 598786, 564049, 586121, 444853, 627442, 497030, 589886, 452729, 813207, 787506, 515548, 634029, 528496, 573212, 506692, 562585, 568707, 779996, 588071, 439240, 752648, 451254, 527927, 632095, 494081, 591604, 605367, 715790, 515444, 427174, 449946, 712633, 715812, 806931, 449531, 628553, 806173, 429445, 419646, 503576, 505317, 524320, 513098, 814434, 516666, 560969, 621765, 599412, 755079, 455549, 435916, 779840, 418601, 514090, 517572, 547496, 595209, 482283, 582631, 429844, 447004, 506082, 450323, 447077, 573461, 515761, 556505, 442673, 424385, 591680, 609892, 632304);

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
  418601
  419646
  424385
  427174
  429445
  429844
  435916
  439240
  442673
  444853
  447004
  447077
  449531
  449946
  450323
  451254
  452729
  455549
  482283
  494081
  497030
  503576
  505317
  506082
  506692
  513098
  514090
  515444
  515548
  515761
  516666
  517572
  524320
  527927
  528496
  547496
  556505
  560969
  562585
  564049
  568707
  573212
  573461
  582631
  586121
  588071
  589886
  591604
  591680
  595209
  598786
  599412
  605367
  609892
  621765
  627442
  628553
  632095
  632304
  634029
  712633
  715790
  715812
  752648
  755079
  766939
  779840
  779996
  787506
  806173
  806931
  813207
  814434
]

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 (418601, 419646, 424385, 427174, 429445, 429844, 435916, 439240, 442673, 444853, 447004, 447077, 449531, 449946, 450323, 451254, 452729, 455549, 482283, 494081, 497030, 503576, 505317, 506082, 506692, 513098, 514090, 515444, 515548, 515761, 516666, 517572, 524320, 527927, 528496, 547496, 556505, 560969, 562585, 564049, 568707, 573212, 573461, 582631, 586121, 588071, 589886, 591604, 591680, 595209, 598786, 599412, 605367, 609892, 621765, 627442, 628553, 632095, 632304, 634029, 712633, 715790, 715812, 752648, 755079, 766939, 779840, 779996, 787506, 806173, 806931, 813207, 814434);

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
  418601
  419646
  424385
  427174
  429445
  429844
  435916
  439240
  442673
  444853
  447004
  447077
  449531
  449946
  450323
  451254
  452729
  455549
  482283
  494081
  497030
  503576
  505317
  506082
  506692
  513098
  514090
  515444
  515548
  515761
  516666
  517572
  524320
  527927
  528496
  547496
  556505
  560969
  562585
  564049
  568707
  573212
  573461
  582631
  586121
  588071
  589886
  591604
  591680
  595209
  598786
  599412
  605367
  609892
  621765
  627442
  628553
  632095
  632304
  634029
  712633
  715790
  715812
  752648
  755079
  766939
  779840
  779996
  787506
  806173
  806931
  813207
  814434
]

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 (418601, 419646, 424385, 427174, 429445, 429844, 435916, 439240, 442673, 444853, 447004, 447077, 449531, 449946, 450323, 451254, 452729, 455549, 482283, 494081, 497030, 503576, 505317, 506082, 506692, 513098, 514090, 515444, 515548, 515761, 516666, 517572, 524320, 527927, 528496, 547496, 556505, 560969, 562585, 564049, 568707, 573212, 573461, 582631, 586121, 588071, 589886, 591604, 591680, 595209, 598786, 599412, 605367, 609892, 621765, 627442, 628553, 632095, 632304, 634029, 712633, 715790, 715812, 752648, 755079, 766939, 779840, 779996, 787506, 806173, 806931, 813207, 814434);

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

[
  "сквирт оргазм teen любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'сквирт оргазм teen любительск';

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

[
  "сквирт оргазм teen любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'сквирт оргазм teen любительск';