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

[
  "licking clitoris"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'licking clitoris' 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
  524682
  514311
  542199
  614745
  430018
  493163
  444795
  464368
  500477
  527245
  529213
  531943
  562007
  586429
  588068
  618442
  613275
  622831
  459388
  515659
  526773
  524879
  537888
  538963
  554386
  560851
  543844
  559155
  569667
  569686
  541244
  542148
  564646
  573482
  574546
  682530
  558440
  581797
  583982
  589683
  598807
  600531
  604776
  611558
  619065
  626385
  599827
  603503
  607329
  614906
  615800
  623011
  586633
  603227
  609105
  617039
  621273
  622229
  622241
  614729
  405804
  462415
  465394
  512094
  495024
  511802
  524490
  525651
  536910
  599940
  590878
  521815
  613014
  593125
  489438
  513775
  525287
  612792
  626944
  395696
  580215
]

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 (524682, 514311, 542199, 614745, 430018, 493163, 444795, 464368, 500477, 527245, 529213, 531943, 562007, 586429, 588068, 618442, 613275, 622831, 459388, 515659, 526773, 524879, 537888, 538963, 554386, 560851, 543844, 559155, 569667, 569686, 541244, 542148, 564646, 573482, 574546, 682530, 558440, 581797, 583982, 589683, 598807, 600531, 604776, 611558, 619065, 626385, 599827, 603503, 607329, 614906, 615800, 623011, 586633, 603227, 609105, 617039, 621273, 622229, 622241, 614729, 405804, 462415, 465394, 512094, 495024, 511802, 524490, 525651, 536910, 599940, 590878, 521815, 613014, 593125, 489438, 513775, 525287, 612792, 626944, 395696, 580215);

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
  395696
  405804
  430018
  444795
  459388
  462415
  464368
  465394
  489438
  493163
  495024
  500477
  511802
  512094
  513775
  514311
  515659
  521815
  524490
  524682
  524879
  525287
  525651
  526773
  527245
  529213
  531943
  536910
  537888
  538963
  541244
  542148
  542199
  543844
  554386
  558440
  559155
  560851
  562007
  564646
  569667
  569686
  573482
  574546
  580215
  581797
  583982
  586429
  586633
  588068
  589683
  590878
  593125
  598807
  599827
  599940
  600531
  603227
  603503
  604776
  607329
  609105
  611558
  612792
  613014
  613275
  614729
  614745
  614906
  615800
  617039
  618442
  619065
  621273
  622229
  622241
  622831
  623011
  626385
  626944
  682530
]

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 (395696, 405804, 430018, 444795, 459388, 462415, 464368, 465394, 489438, 493163, 495024, 500477, 511802, 512094, 513775, 514311, 515659, 521815, 524490, 524682, 524879, 525287, 525651, 526773, 527245, 529213, 531943, 536910, 537888, 538963, 541244, 542148, 542199, 543844, 554386, 558440, 559155, 560851, 562007, 564646, 569667, 569686, 573482, 574546, 580215, 581797, 583982, 586429, 586633, 588068, 589683, 590878, 593125, 598807, 599827, 599940, 600531, 603227, 603503, 604776, 607329, 609105, 611558, 612792, 613014, 613275, 614729, 614745, 614906, 615800, 617039, 618442, 619065, 621273, 622229, 622241, 622831, 623011, 626385, 626944, 682530);

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
  395696
  405804
  430018
  444795
  459388
  462415
  464368
  465394
  489438
  493163
  495024
  500477
  511802
  512094
  513775
  514311
  515659
  521815
  524490
  524682
  524879
  525287
  525651
  526773
  527245
  529213
  531943
  536910
  537888
  538963
  541244
  542148
  542199
  543844
  554386
  558440
  559155
  560851
  562007
  564646
  569667
  569686
  573482
  574546
  580215
  581797
  583982
  586429
  586633
  588068
  589683
  590878
  593125
  598807
  599827
  599940
  600531
  603227
  603503
  604776
  607329
  609105
  611558
  612792
  613014
  613275
  614729
  614745
  614906
  615800
  617039
  618442
  619065
  621273
  622229
  622241
  622831
  623011
  626385
  626944
  682530
]

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 (395696, 405804, 430018, 444795, 459388, 462415, 464368, 465394, 489438, 493163, 495024, 500477, 511802, 512094, 513775, 514311, 515659, 521815, 524490, 524682, 524879, 525287, 525651, 526773, 527245, 529213, 531943, 536910, 537888, 538963, 541244, 542148, 542199, 543844, 554386, 558440, 559155, 560851, 562007, 564646, 569667, 569686, 573482, 574546, 580215, 581797, 583982, 586429, 586633, 588068, 589683, 590878, 593125, 598807, 599827, 599940, 600531, 603227, 603503, 604776, 607329, 609105, 611558, 612792, 613014, 613275, 614729, 614745, 614906, 615800, 617039, 618442, 619065, 621273, 622229, 622241, 622831, 623011, 626385, 626944, 682530);

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` = 'лиза клитор';