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

[
  "extreme anal dildos"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'extreme anal dildos' 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
  782791
  537138
  770261
  740926
  597029
  392843
  544848
  722382
  752753
  401769
  666898
  642013
  547470
  750359
  634114
  749264
  382304
  386421
  444540
  817173
  453223
  583712
  545550
  571194
  669046
  752677
  752620
  416700
  448880
  788907
  452810
  738814
  432613
  416691
  515546
  700975
  660399
  547847
  642065
  751615
  808331
  513842
  416515
  671052
  402626
  416624
  447160
  534839
  595376
  415303
  449173
  416676
  475405
  458115
  805120
  573197
  665957
  660375
  640270
  825864
  500290
  641950
  811296
  413277
  513183
  547485
  590281
  416677
  609154
  443090
  450357
  514240
  530482
]

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 (782791, 537138, 770261, 740926, 597029, 392843, 544848, 722382, 752753, 401769, 666898, 642013, 547470, 750359, 634114, 749264, 382304, 386421, 444540, 817173, 453223, 583712, 545550, 571194, 669046, 752677, 752620, 416700, 448880, 788907, 452810, 738814, 432613, 416691, 515546, 700975, 660399, 547847, 642065, 751615, 808331, 513842, 416515, 671052, 402626, 416624, 447160, 534839, 595376, 415303, 449173, 416676, 475405, 458115, 805120, 573197, 665957, 660375, 640270, 825864, 500290, 641950, 811296, 413277, 513183, 547485, 590281, 416677, 609154, 443090, 450357, 514240, 530482);

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
  382304
  386421
  392843
  401769
  402626
  413277
  415303
  416515
  416624
  416676
  416677
  416691
  416700
  432613
  443090
  444540
  447160
  448880
  449173
  450357
  452810
  453223
  458115
  475405
  500290
  513183
  513842
  514240
  515546
  530482
  534839
  537138
  544848
  545550
  547470
  547485
  547847
  571194
  573197
  583712
  590281
  597029
  609154
  634114
  640270
  641950
  642013
  642065
  660375
  660399
  665957
  666898
  669046
  671052
  700975
  722382
  738814
  740926
  749264
  750359
  751615
  752620
  752677
  752753
  770261
  782791
  788907
  805120
  808331
  811296
  817173
  825864
]

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 (382304, 386421, 392843, 401769, 402626, 413277, 415303, 416515, 416624, 416676, 416677, 416691, 416700, 432613, 443090, 444540, 447160, 448880, 449173, 450357, 452810, 453223, 458115, 475405, 500290, 513183, 513842, 514240, 515546, 530482, 534839, 537138, 544848, 545550, 547470, 547485, 547847, 571194, 573197, 583712, 590281, 597029, 609154, 634114, 640270, 641950, 642013, 642065, 660375, 660399, 665957, 666898, 669046, 671052, 700975, 722382, 738814, 740926, 749264, 750359, 751615, 752620, 752677, 752753, 770261, 782791, 788907, 805120, 808331, 811296, 817173, 825864);

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
  382304
  386421
  392843
  401769
  402626
  413277
  415303
  416515
  416624
  416676
  416677
  416691
  416700
  432613
  443090
  444540
  447160
  448880
  449173
  450357
  452810
  453223
  458115
  475405
  500290
  513183
  513842
  514240
  515546
  530482
  534839
  537138
  544848
  545550
  547470
  547485
  547847
  571194
  573197
  583712
  590281
  597029
  609154
  634114
  640270
  641950
  642013
  642065
  660375
  660399
  665957
  666898
  669046
  671052
  700975
  722382
  738814
  740926
  749264
  750359
  751615
  752620
  752677
  752753
  770261
  782791
  788907
  805120
  808331
  811296
  817173
  825864
]

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 (382304, 386421, 392843, 401769, 402626, 413277, 415303, 416515, 416624, 416676, 416677, 416691, 416700, 432613, 443090, 444540, 447160, 448880, 449173, 450357, 452810, 453223, 458115, 475405, 500290, 513183, 513842, 514240, 515546, 530482, 534839, 537138, 544848, 545550, 547470, 547485, 547847, 571194, 573197, 583712, 590281, 597029, 609154, 634114, 640270, 641950, 642013, 642065, 660375, 660399, 665957, 666898, 669046, 671052, 700975, 722382, 738814, 740926, 749264, 750359, 751615, 752620, 752677, 752753, 770261, 782791, 788907, 805120, 808331, 811296, 817173, 825864);

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

[
  "хардкор анал dildos"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'хардкор анал dildos';

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

[
  "хардкор анал dildos"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'хардкор анал dildos';

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 ?

[
  "extreme anal dildos"
  "extreme anal dildos"
  "extreme anal dildos"
  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 ('extreme anal dildos') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('extreme anal dildos')
              AND `query` <> 'extreme anal dildos'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;