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

[
  "perfect masturbation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'perfect 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
  567331
  589972
  626597
  596470
  589968
  600910
  598355
  604030
  726936
  796877
  459046
  390607
  421253
  435968
  470856
  431028
  442454
  514966
  515464
  523823
  498110
  589029
  600222
  524087
  507291
  405599
  423298
  516363
  525729
  523197
  479936
  480226
  548837
  671371
  700307
  590102
  752661
  437635
  513502
  539977
  621079
  807364
  465232
  564643
  607694
  629630
  613508
  811466
  463280
  487431
  516602
  511359
  571228
  588525
  653472
  486738
  614600
  454754
  637537
  428554
  545300
  530948
  596562
  750531
  654109
  416439
  526325
  586917
  515482
  483515
  467744
  482086
  448876
  616024
  618326
  479196
]

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 (567331, 589972, 626597, 596470, 589968, 600910, 598355, 604030, 726936, 796877, 459046, 390607, 421253, 435968, 470856, 431028, 442454, 514966, 515464, 523823, 498110, 589029, 600222, 524087, 507291, 405599, 423298, 516363, 525729, 523197, 479936, 480226, 548837, 671371, 700307, 590102, 752661, 437635, 513502, 539977, 621079, 807364, 465232, 564643, 607694, 629630, 613508, 811466, 463280, 487431, 516602, 511359, 571228, 588525, 653472, 486738, 614600, 454754, 637537, 428554, 545300, 530948, 596562, 750531, 654109, 416439, 526325, 586917, 515482, 483515, 467744, 482086, 448876, 616024, 618326, 479196);

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
  390607
  405599
  416439
  421253
  423298
  428554
  431028
  435968
  437635
  442454
  448876
  454754
  459046
  463280
  465232
  467744
  470856
  479196
  479936
  480226
  482086
  483515
  486738
  487431
  498110
  507291
  511359
  513502
  514966
  515464
  515482
  516363
  516602
  523197
  523823
  524087
  525729
  526325
  530948
  539977
  545300
  548837
  564643
  567331
  571228
  586917
  588525
  589029
  589968
  589972
  590102
  596470
  596562
  598355
  600222
  600910
  604030
  607694
  613508
  614600
  616024
  618326
  621079
  626597
  629630
  637537
  653472
  654109
  671371
  700307
  726936
  750531
  752661
  796877
  807364
  811466
]

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 (390607, 405599, 416439, 421253, 423298, 428554, 431028, 435968, 437635, 442454, 448876, 454754, 459046, 463280, 465232, 467744, 470856, 479196, 479936, 480226, 482086, 483515, 486738, 487431, 498110, 507291, 511359, 513502, 514966, 515464, 515482, 516363, 516602, 523197, 523823, 524087, 525729, 526325, 530948, 539977, 545300, 548837, 564643, 567331, 571228, 586917, 588525, 589029, 589968, 589972, 590102, 596470, 596562, 598355, 600222, 600910, 604030, 607694, 613508, 614600, 616024, 618326, 621079, 626597, 629630, 637537, 653472, 654109, 671371, 700307, 726936, 750531, 752661, 796877, 807364, 811466);

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
  390607
  405599
  416439
  421253
  423298
  428554
  431028
  435968
  437635
  442454
  448876
  454754
  459046
  463280
  465232
  467744
  470856
  479196
  479936
  480226
  482086
  483515
  486738
  487431
  498110
  507291
  511359
  513502
  514966
  515464
  515482
  516363
  516602
  523197
  523823
  524087
  525729
  526325
  530948
  539977
  545300
  548837
  564643
  567331
  571228
  586917
  588525
  589029
  589968
  589972
  590102
  596470
  596562
  598355
  600222
  600910
  604030
  607694
  613508
  614600
  616024
  618326
  621079
  626597
  629630
  637537
  653472
  654109
  671371
  700307
  726936
  750531
  752661
  796877
  807364
  811466
]

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 (390607, 405599, 416439, 421253, 423298, 428554, 431028, 435968, 437635, 442454, 448876, 454754, 459046, 463280, 465232, 467744, 470856, 479196, 479936, 480226, 482086, 483515, 486738, 487431, 498110, 507291, 511359, 513502, 514966, 515464, 515482, 516363, 516602, 523197, 523823, 524087, 525729, 526325, 530948, 539977, 545300, 548837, 564643, 567331, 571228, 586917, 588525, 589029, 589968, 589972, 590102, 596470, 596562, 598355, 600222, 600910, 604030, 607694, 613508, 614600, 616024, 618326, 621079, 626597, 629630, 637537, 653472, 654109, 671371, 700307, 726936, 750531, 752661, 796877, 807364, 811466);

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

[
  "perfect мастурбац"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'perfect мастурбац';

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

[
  "perfect мастурбац"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'perfect мастурбац';