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

[
  "big clit masturbation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big clit masturbation' 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
  806140
  724636
  787363
  426284
  479008
  541803
  569283
  584099
  557613
  557635
  586810
  610235
  630461
  802914
  445723
  545455
  583757
  550550
  547586
  556115
  710221
  586218
  636461
  617047
  730865
  784644
  728465
  605108
  472625
  694098
  619385
  513443
  721895
  580855
  604198
  555988
  579585
  578010
  593540
  803129
  616094
  444632
  496144
  576611
  589073
  761574
  497202
  521786
  444499
  583966
  594549
  661008
  592973
  629815
  498446
  580768
  583894
  628546
  615925
  554854
  541240
  680706
  595209
  441853
  510200
  448570
  623420
  581873
  521810
  609161
  382230
  576951
  513572
  603503
]

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 (806140, 724636, 787363, 426284, 479008, 541803, 569283, 584099, 557613, 557635, 586810, 610235, 630461, 802914, 445723, 545455, 583757, 550550, 547586, 556115, 710221, 586218, 636461, 617047, 730865, 784644, 728465, 605108, 472625, 694098, 619385, 513443, 721895, 580855, 604198, 555988, 579585, 578010, 593540, 803129, 616094, 444632, 496144, 576611, 589073, 761574, 497202, 521786, 444499, 583966, 594549, 661008, 592973, 629815, 498446, 580768, 583894, 628546, 615925, 554854, 541240, 680706, 595209, 441853, 510200, 448570, 623420, 581873, 521810, 609161, 382230, 576951, 513572, 603503);

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
  382230
  426284
  441853
  444499
  444632
  445723
  448570
  472625
  479008
  496144
  497202
  498446
  510200
  513443
  513572
  521786
  521810
  541240
  541803
  545455
  547586
  550550
  554854
  555988
  556115
  557613
  557635
  569283
  576611
  576951
  578010
  579585
  580768
  580855
  581873
  583757
  583894
  583966
  584099
  586218
  586810
  589073
  592973
  593540
  594549
  595209
  603503
  604198
  605108
  609161
  610235
  615925
  616094
  617047
  619385
  623420
  628546
  629815
  630461
  636461
  661008
  680706
  694098
  710221
  721895
  724636
  728465
  730865
  761574
  784644
  787363
  802914
  803129
  806140
]

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 (382230, 426284, 441853, 444499, 444632, 445723, 448570, 472625, 479008, 496144, 497202, 498446, 510200, 513443, 513572, 521786, 521810, 541240, 541803, 545455, 547586, 550550, 554854, 555988, 556115, 557613, 557635, 569283, 576611, 576951, 578010, 579585, 580768, 580855, 581873, 583757, 583894, 583966, 584099, 586218, 586810, 589073, 592973, 593540, 594549, 595209, 603503, 604198, 605108, 609161, 610235, 615925, 616094, 617047, 619385, 623420, 628546, 629815, 630461, 636461, 661008, 680706, 694098, 710221, 721895, 724636, 728465, 730865, 761574, 784644, 787363, 802914, 803129, 806140);

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
  382230
  426284
  441853
  444499
  444632
  445723
  448570
  472625
  479008
  496144
  497202
  498446
  510200
  513443
  513572
  521786
  521810
  541240
  541803
  545455
  547586
  550550
  554854
  555988
  556115
  557613
  557635
  569283
  576611
  576951
  578010
  579585
  580768
  580855
  581873
  583757
  583894
  583966
  584099
  586218
  586810
  589073
  592973
  593540
  594549
  595209
  603503
  604198
  605108
  609161
  610235
  615925
  616094
  617047
  619385
  623420
  628546
  629815
  630461
  636461
  661008
  680706
  694098
  710221
  721895
  724636
  728465
  730865
  761574
  784644
  787363
  802914
  803129
  806140
]

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 (382230, 426284, 441853, 444499, 444632, 445723, 448570, 472625, 479008, 496144, 497202, 498446, 510200, 513443, 513572, 521786, 521810, 541240, 541803, 545455, 547586, 550550, 554854, 555988, 556115, 557613, 557635, 569283, 576611, 576951, 578010, 579585, 580768, 580855, 581873, 583757, 583894, 583966, 584099, 586218, 586810, 589073, 592973, 593540, 594549, 595209, 603503, 604198, 605108, 609161, 610235, 615925, 616094, 617047, 619385, 623420, 628546, 629815, 630461, 636461, 661008, 680706, 694098, 710221, 721895, 724636, 728465, 730865, 761574, 784644, 787363, 802914, 803129, 806140);

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

[
  "большие clit мастурбац"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большие clit мастурбац';

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

[
  "большие clit мастурбац"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большие clit мастурбац';