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

[
  "arab girl hardcore"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'arab girl hardcore' 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
  542813
  739087
  544636
  771251
  543013
  399061
  602485
  578319
  602293
  709562
  629806
  425207
  477581
  767197
  550241
  543097
  586473
  641094
  575031
  525777
  813831
  522088
  813858
  543275
  617111
  478985
  522398
  590176
  461086
  750229
  630594
  740863
  744091
  530666
  628506
  543061
  457383
  637437
  622912
  542345
  459836
  550688
  598310
  591669
  590182
  578288
  570740
  630081
  575011
  810569
  664452
  796732
  767076
  633440
  818709
  543022
  566563
  628631
  820690
  710903
  565969
  556936
  756301
  591870
  576995
  543182
  575009
  542999
  575709
  570176
  601101
]

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 (542813, 739087, 544636, 771251, 543013, 399061, 602485, 578319, 602293, 709562, 629806, 425207, 477581, 767197, 550241, 543097, 586473, 641094, 575031, 525777, 813831, 522088, 813858, 543275, 617111, 478985, 522398, 590176, 461086, 750229, 630594, 740863, 744091, 530666, 628506, 543061, 457383, 637437, 622912, 542345, 459836, 550688, 598310, 591669, 590182, 578288, 570740, 630081, 575011, 810569, 664452, 796732, 767076, 633440, 818709, 543022, 566563, 628631, 820690, 710903, 565969, 556936, 756301, 591870, 576995, 543182, 575009, 542999, 575709, 570176, 601101);

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
  399061
  425207
  457383
  459836
  461086
  477581
  478985
  522088
  522398
  525777
  530666
  542345
  542813
  542999
  543013
  543022
  543061
  543097
  543182
  543275
  544636
  550241
  550688
  556936
  565969
  566563
  570176
  570740
  575009
  575011
  575031
  575709
  576995
  578288
  578319
  586473
  590176
  590182
  591669
  591870
  598310
  601101
  602293
  602485
  617111
  622912
  628506
  628631
  629806
  630081
  630594
  633440
  637437
  641094
  664452
  709562
  710903
  739087
  740863
  744091
  750229
  756301
  767076
  767197
  771251
  796732
  810569
  813831
  813858
  818709
  820690
]

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 (399061, 425207, 457383, 459836, 461086, 477581, 478985, 522088, 522398, 525777, 530666, 542345, 542813, 542999, 543013, 543022, 543061, 543097, 543182, 543275, 544636, 550241, 550688, 556936, 565969, 566563, 570176, 570740, 575009, 575011, 575031, 575709, 576995, 578288, 578319, 586473, 590176, 590182, 591669, 591870, 598310, 601101, 602293, 602485, 617111, 622912, 628506, 628631, 629806, 630081, 630594, 633440, 637437, 641094, 664452, 709562, 710903, 739087, 740863, 744091, 750229, 756301, 767076, 767197, 771251, 796732, 810569, 813831, 813858, 818709, 820690);

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
  399061
  425207
  457383
  459836
  461086
  477581
  478985
  522088
  522398
  525777
  530666
  542345
  542813
  542999
  543013
  543022
  543061
  543097
  543182
  543275
  544636
  550241
  550688
  556936
  565969
  566563
  570176
  570740
  575009
  575011
  575031
  575709
  576995
  578288
  578319
  586473
  590176
  590182
  591669
  591870
  598310
  601101
  602293
  602485
  617111
  622912
  628506
  628631
  629806
  630081
  630594
  633440
  637437
  641094
  664452
  709562
  710903
  739087
  740863
  744091
  750229
  756301
  767076
  767197
  771251
  796732
  810569
  813831
  813858
  818709
  820690
]

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 (399061, 425207, 457383, 459836, 461086, 477581, 478985, 522088, 522398, 525777, 530666, 542345, 542813, 542999, 543013, 543022, 543061, 543097, 543182, 543275, 544636, 550241, 550688, 556936, 565969, 566563, 570176, 570740, 575009, 575011, 575031, 575709, 576995, 578288, 578319, 586473, 590176, 590182, 591669, 591870, 598310, 601101, 602293, 602485, 617111, 622912, 628506, 628631, 629806, 630081, 630594, 633440, 637437, 641094, 664452, 709562, 710903, 739087, 740863, 744091, 750229, 756301, 767076, 767197, 771251, 796732, 810569, 813831, 813858, 818709, 820690);

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` = 'араб девушк хардкор';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "arab girl hardcore"
  "arab girl hardcore"
  "arab girl hardcore"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('arab girl hardcore') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('arab girl hardcore')
              AND `query` <> 'arab girl hardcore'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;