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

[
  "доктор минет"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'доктор минет' 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
  515306
  515836
  557125
  524016
  452553
  401615
  498023
  519947
  515332
  519642
  524504
  563623
  498064
  480104
  506659
  472569
  553723
  481977
  503846
  531195
  691200
  586468
  599414
  490153
  557181
  498025
  564685
  519622
  485442
  408383
  560428
  491840
  593368
  489471
  518541
  562511
  586474
  498222
  512436
  515281
  501465
  524560
  424401
  531236
  515226
  458895
  515290
  563489
  474152
  475241
  554182
  553706
  534680
  548548
  447458
  545695
  506576
  691196
  604172
  469852
  468760
  553720
  562030
  489097
  616890
  560425
  593487
  583677
  498057
  498039
  641732
  593292
  593425
  632585
  578326
  603167
  575194
  546794
  586429
  625861
  515119
  508150
]

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 (515306, 515836, 557125, 524016, 452553, 401615, 498023, 519947, 515332, 519642, 524504, 563623, 498064, 480104, 506659, 472569, 553723, 481977, 503846, 531195, 691200, 586468, 599414, 490153, 557181, 498025, 564685, 519622, 485442, 408383, 560428, 491840, 593368, 489471, 518541, 562511, 586474, 498222, 512436, 515281, 501465, 524560, 424401, 531236, 515226, 458895, 515290, 563489, 474152, 475241, 554182, 553706, 534680, 548548, 447458, 545695, 506576, 691196, 604172, 469852, 468760, 553720, 562030, 489097, 616890, 560425, 593487, 583677, 498057, 498039, 641732, 593292, 593425, 632585, 578326, 603167, 575194, 546794, 586429, 625861, 515119, 508150);

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
  401615
  408383
  424401
  447458
  452553
  458895
  468760
  469852
  472569
  474152
  475241
  480104
  481977
  485442
  489097
  489471
  490153
  491840
  498023
  498025
  498039
  498057
  498064
  498222
  501465
  503846
  506576
  506659
  508150
  512436
  515119
  515226
  515281
  515290
  515306
  515332
  515836
  518541
  519622
  519642
  519947
  524016
  524504
  524560
  531195
  531236
  534680
  545695
  546794
  548548
  553706
  553720
  553723
  554182
  557125
  557181
  560425
  560428
  562030
  562511
  563489
  563623
  564685
  575194
  578326
  583677
  586429
  586468
  586474
  593292
  593368
  593425
  593487
  599414
  603167
  604172
  616890
  625861
  632585
  641732
  691196
  691200
]

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 (401615, 408383, 424401, 447458, 452553, 458895, 468760, 469852, 472569, 474152, 475241, 480104, 481977, 485442, 489097, 489471, 490153, 491840, 498023, 498025, 498039, 498057, 498064, 498222, 501465, 503846, 506576, 506659, 508150, 512436, 515119, 515226, 515281, 515290, 515306, 515332, 515836, 518541, 519622, 519642, 519947, 524016, 524504, 524560, 531195, 531236, 534680, 545695, 546794, 548548, 553706, 553720, 553723, 554182, 557125, 557181, 560425, 560428, 562030, 562511, 563489, 563623, 564685, 575194, 578326, 583677, 586429, 586468, 586474, 593292, 593368, 593425, 593487, 599414, 603167, 604172, 616890, 625861, 632585, 641732, 691196, 691200);

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
  401615
  408383
  424401
  447458
  452553
  458895
  468760
  469852
  472569
  474152
  475241
  480104
  481977
  485442
  489097
  489471
  490153
  491840
  498023
  498025
  498039
  498057
  498064
  498222
  501465
  503846
  506576
  506659
  508150
  512436
  515119
  515226
  515281
  515290
  515306
  515332
  515836
  518541
  519622
  519642
  519947
  524016
  524504
  524560
  531195
  531236
  534680
  545695
  546794
  548548
  553706
  553720
  553723
  554182
  557125
  557181
  560425
  560428
  562030
  562511
  563489
  563623
  564685
  575194
  578326
  583677
  586429
  586468
  586474
  593292
  593368
  593425
  593487
  599414
  603167
  604172
  616890
  625861
  632585
  641732
  691196
  691200
]

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 (401615, 408383, 424401, 447458, 452553, 458895, 468760, 469852, 472569, 474152, 475241, 480104, 481977, 485442, 489097, 489471, 490153, 491840, 498023, 498025, 498039, 498057, 498064, 498222, 501465, 503846, 506576, 506659, 508150, 512436, 515119, 515226, 515281, 515290, 515306, 515332, 515836, 518541, 519622, 519642, 519947, 524016, 524504, 524560, 531195, 531236, 534680, 545695, 546794, 548548, 553706, 553720, 553723, 554182, 557125, 557181, 560425, 560428, 562030, 562511, 563489, 563623, 564685, 575194, 578326, 583677, 586429, 586468, 586474, 593292, 593368, 593425, 593487, 599414, 603167, 604172, 616890, 625861, 632585, 641732, 691196, 691200);

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` = 'доктор минет оральн секс';