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

[
  "mom wet panties"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mom wet 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
  778781
  535346
  749074
  594998
  808675
  815910
  812116
  744183
  770009
  752194
  480379
  782618
  760536
  636426
  815839
  816356
  682735
  549356
  582955
  816535
  786176
  795501
  759116
  535335
  816270
  593316
  816952
  816506
  815521
  815375
  816516
  718022
  784221
  528572
  569575
  819759
  815674
  816255
  594821
  816067
  761127
  437389
  815149
  815619
  816441
  802458
  792147
  602063
  556320
  609855
  773799
  800876
  481451
  522978
  521485
  419989
  525884
  569418
  549548
  642665
  605521
  493402
  419455
  478991
  533443
  611032
  425795
  524100
  550128
  600352
  465198
  599976
  523045
  480400
  606197
  581897
  666894
  642006
  430444
  484870
  637413
  518552
  639741
  430018
]

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 (778781, 535346, 749074, 594998, 808675, 815910, 812116, 744183, 770009, 752194, 480379, 782618, 760536, 636426, 815839, 816356, 682735, 549356, 582955, 816535, 786176, 795501, 759116, 535335, 816270, 593316, 816952, 816506, 815521, 815375, 816516, 718022, 784221, 528572, 569575, 819759, 815674, 816255, 594821, 816067, 761127, 437389, 815149, 815619, 816441, 802458, 792147, 602063, 556320, 609855, 773799, 800876, 481451, 522978, 521485, 419989, 525884, 569418, 549548, 642665, 605521, 493402, 419455, 478991, 533443, 611032, 425795, 524100, 550128, 600352, 465198, 599976, 523045, 480400, 606197, 581897, 666894, 642006, 430444, 484870, 637413, 518552, 639741, 430018);

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
  419455
  419989
  425795
  430018
  430444
  437389
  465198
  478991
  480379
  480400
  481451
  484870
  493402
  518552
  521485
  522978
  523045
  524100
  525884
  528572
  533443
  535335
  535346
  549356
  549548
  550128
  556320
  569418
  569575
  581897
  582955
  593316
  594821
  594998
  599976
  600352
  602063
  605521
  606197
  609855
  611032
  636426
  637413
  639741
  642006
  642665
  666894
  682735
  718022
  744183
  749074
  752194
  759116
  760536
  761127
  770009
  773799
  778781
  782618
  784221
  786176
  792147
  795501
  800876
  802458
  808675
  812116
  815149
  815375
  815521
  815619
  815674
  815839
  815910
  816067
  816255
  816270
  816356
  816441
  816506
  816516
  816535
  816952
  819759
]

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 (419455, 419989, 425795, 430018, 430444, 437389, 465198, 478991, 480379, 480400, 481451, 484870, 493402, 518552, 521485, 522978, 523045, 524100, 525884, 528572, 533443, 535335, 535346, 549356, 549548, 550128, 556320, 569418, 569575, 581897, 582955, 593316, 594821, 594998, 599976, 600352, 602063, 605521, 606197, 609855, 611032, 636426, 637413, 639741, 642006, 642665, 666894, 682735, 718022, 744183, 749074, 752194, 759116, 760536, 761127, 770009, 773799, 778781, 782618, 784221, 786176, 792147, 795501, 800876, 802458, 808675, 812116, 815149, 815375, 815521, 815619, 815674, 815839, 815910, 816067, 816255, 816270, 816356, 816441, 816506, 816516, 816535, 816952, 819759);

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
  419455
  419989
  425795
  430018
  430444
  437389
  465198
  478991
  480379
  480400
  481451
  484870
  493402
  518552
  521485
  522978
  523045
  524100
  525884
  528572
  533443
  535335
  535346
  549356
  549548
  550128
  556320
  569418
  569575
  581897
  582955
  593316
  594821
  594998
  599976
  600352
  602063
  605521
  606197
  609855
  611032
  636426
  637413
  639741
  642006
  642665
  666894
  682735
  718022
  744183
  749074
  752194
  759116
  760536
  761127
  770009
  773799
  778781
  782618
  784221
  786176
  792147
  795501
  800876
  802458
  808675
  812116
  815149
  815375
  815521
  815619
  815674
  815839
  815910
  816067
  816255
  816270
  816356
  816441
  816506
  816516
  816535
  816952
  819759
]

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 (419455, 419989, 425795, 430018, 430444, 437389, 465198, 478991, 480379, 480400, 481451, 484870, 493402, 518552, 521485, 522978, 523045, 524100, 525884, 528572, 533443, 535335, 535346, 549356, 549548, 550128, 556320, 569418, 569575, 581897, 582955, 593316, 594821, 594998, 599976, 600352, 602063, 605521, 606197, 609855, 611032, 636426, 637413, 639741, 642006, 642665, 666894, 682735, 718022, 744183, 749074, 752194, 759116, 760536, 761127, 770009, 773799, 778781, 782618, 784221, 786176, 792147, 795501, 800876, 802458, 808675, 812116, 815149, 815375, 815521, 815619, 815674, 815839, 815910, 816067, 816255, 816270, 816356, 816441, 816506, 816516, 816535, 816952, 819759);

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

[
  "mom мокрые трусик нижн бел"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mom мокрые трусик нижн бел';

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

[
  "mom мокрые трусик нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mom мокрые трусик нижн бел';