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

[
  "skinny secretary"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny secretary' 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
  681452
  423172
  512182
  523280
  600837
  631179
  421346
  495173
  477210
  581663
  576044
  429544
  498664
  420621
  815062
  447908
  472080
  473767
  561632
  574557
  569058
  581652
  585747
  585517
  590748
  775793
  478721
  464600
  501835
  513688
  505216
  484058
  513299
  426482
  475873
  542027
  555542
  574867
  568638
  555825
  807708
  448706
  450529
  421471
  446481
  484420
  429272
  423000
  556574
  581184
  552053
  600793
  591172
  473047
  493015
  416288
  446872
  580518
  586474
  395715
  438929
  503146
  528221
  531581
  515604
  524501
  576051
  564443
  553720
  469764
  486093
  495403
  561814
  528181
  483963
  654466
  563884
  597474
  611892
  561853
  622778
  589127
  541646
]

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 (681452, 423172, 512182, 523280, 600837, 631179, 421346, 495173, 477210, 581663, 576044, 429544, 498664, 420621, 815062, 447908, 472080, 473767, 561632, 574557, 569058, 581652, 585747, 585517, 590748, 775793, 478721, 464600, 501835, 513688, 505216, 484058, 513299, 426482, 475873, 542027, 555542, 574867, 568638, 555825, 807708, 448706, 450529, 421471, 446481, 484420, 429272, 423000, 556574, 581184, 552053, 600793, 591172, 473047, 493015, 416288, 446872, 580518, 586474, 395715, 438929, 503146, 528221, 531581, 515604, 524501, 576051, 564443, 553720, 469764, 486093, 495403, 561814, 528181, 483963, 654466, 563884, 597474, 611892, 561853, 622778, 589127, 541646);

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
  395715
  416288
  420621
  421346
  421471
  423000
  423172
  426482
  429272
  429544
  438929
  446481
  446872
  447908
  448706
  450529
  464600
  469764
  472080
  473047
  473767
  475873
  477210
  478721
  483963
  484058
  484420
  486093
  493015
  495173
  495403
  498664
  501835
  503146
  505216
  512182
  513299
  513688
  515604
  523280
  524501
  528181
  528221
  531581
  541646
  542027
  552053
  553720
  555542
  555825
  556574
  561632
  561814
  561853
  563884
  564443
  568638
  569058
  574557
  574867
  576044
  576051
  580518
  581184
  581652
  581663
  585517
  585747
  586474
  589127
  590748
  591172
  597474
  600793
  600837
  611892
  622778
  631179
  654466
  681452
  775793
  807708
  815062
]

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 (395715, 416288, 420621, 421346, 421471, 423000, 423172, 426482, 429272, 429544, 438929, 446481, 446872, 447908, 448706, 450529, 464600, 469764, 472080, 473047, 473767, 475873, 477210, 478721, 483963, 484058, 484420, 486093, 493015, 495173, 495403, 498664, 501835, 503146, 505216, 512182, 513299, 513688, 515604, 523280, 524501, 528181, 528221, 531581, 541646, 542027, 552053, 553720, 555542, 555825, 556574, 561632, 561814, 561853, 563884, 564443, 568638, 569058, 574557, 574867, 576044, 576051, 580518, 581184, 581652, 581663, 585517, 585747, 586474, 589127, 590748, 591172, 597474, 600793, 600837, 611892, 622778, 631179, 654466, 681452, 775793, 807708, 815062);

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
  395715
  416288
  420621
  421346
  421471
  423000
  423172
  426482
  429272
  429544
  438929
  446481
  446872
  447908
  448706
  450529
  464600
  469764
  472080
  473047
  473767
  475873
  477210
  478721
  483963
  484058
  484420
  486093
  493015
  495173
  495403
  498664
  501835
  503146
  505216
  512182
  513299
  513688
  515604
  523280
  524501
  528181
  528221
  531581
  541646
  542027
  552053
  553720
  555542
  555825
  556574
  561632
  561814
  561853
  563884
  564443
  568638
  569058
  574557
  574867
  576044
  576051
  580518
  581184
  581652
  581663
  585517
  585747
  586474
  589127
  590748
  591172
  597474
  600793
  600837
  611892
  622778
  631179
  654466
  681452
  775793
  807708
  815062
]

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 (395715, 416288, 420621, 421346, 421471, 423000, 423172, 426482, 429272, 429544, 438929, 446481, 446872, 447908, 448706, 450529, 464600, 469764, 472080, 473047, 473767, 475873, 477210, 478721, 483963, 484058, 484420, 486093, 493015, 495173, 495403, 498664, 501835, 503146, 505216, 512182, 513299, 513688, 515604, 523280, 524501, 528181, 528221, 531581, 541646, 542027, 552053, 553720, 555542, 555825, 556574, 561632, 561814, 561853, 563884, 564443, 568638, 569058, 574557, 574867, 576044, 576051, 580518, 581184, 581652, 581663, 585517, 585747, 586474, 589127, 590748, 591172, 597474, 600793, 600837, 611892, 622778, 631179, 654466, 681452, 775793, 807708, 815062);

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` = 'худые секретарш';