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

[
  "smoking webcam milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'smoking webcam milf' 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
  456547
  607378
  369221
  811274
  253445
  550137
  553321
  606332
  811362
  641118
  607296
  790362
  790361
  760316
  569001
  811366
  605267
  583219
  811230
  393029
  779182
  798825
  581306
  488527
  607641
  761061
  804617
  801507
  586358
  454562
  493375
  804644
  804272
  89769
  586394
  786217
  811369
  456542
  555011
  423772
  537508
  646796
  423775
  452946
  461841
  765123
  726239
  804612
  606331
  392079
  550021
  789848
  568023
  458446
  808340
  589120
  596324
  785899
  476418
  742402
  475855
  614890
  623925
  423769
  519211
  522579
  526058
  517765
  488842
  517078
  479425
]

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 (456547, 607378, 369221, 811274, 253445, 550137, 553321, 606332, 811362, 641118, 607296, 790362, 790361, 760316, 569001, 811366, 605267, 583219, 811230, 393029, 779182, 798825, 581306, 488527, 607641, 761061, 804617, 801507, 586358, 454562, 493375, 804644, 804272, 89769, 586394, 786217, 811369, 456542, 555011, 423772, 537508, 646796, 423775, 452946, 461841, 765123, 726239, 804612, 606331, 392079, 550021, 789848, 568023, 458446, 808340, 589120, 596324, 785899, 476418, 742402, 475855, 614890, 623925, 423769, 519211, 522579, 526058, 517765, 488842, 517078, 479425);

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
  89769
  253445
  369221
  392079
  393029
  423769
  423772
  423775
  452946
  454562
  456542
  456547
  458446
  461841
  475855
  476418
  479425
  488527
  488842
  493375
  517078
  517765
  519211
  522579
  526058
  537508
  550021
  550137
  553321
  555011
  568023
  569001
  581306
  583219
  586358
  586394
  589120
  596324
  605267
  606331
  606332
  607296
  607378
  614890
  623925
  641118
  646796
  726239
  742402
  760316
  761061
  765123
  779182
  785899
  786217
  789848
  790361
  790362
  798825
  801507
  804272
  804612
  804617
  804644
  808340
  811230
  811274
  811362
  811366
  811369
]

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 (89769, 253445, 369221, 392079, 393029, 423769, 423772, 423775, 452946, 454562, 456542, 456547, 458446, 461841, 475855, 476418, 479425, 488527, 488842, 493375, 517078, 517765, 519211, 522579, 526058, 537508, 550021, 550137, 553321, 555011, 568023, 569001, 581306, 583219, 586358, 586394, 589120, 596324, 605267, 606331, 606332, 607296, 607378, 614890, 623925, 641118, 646796, 726239, 742402, 760316, 761061, 765123, 779182, 785899, 786217, 789848, 790361, 790362, 798825, 801507, 804272, 804612, 804617, 804644, 808340, 811230, 811274, 811362, 811366, 811369);

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
  89769
  253445
  369221
  392079
  393029
  423769
  423772
  423775
  452946
  454562
  456542
  456547
  458446
  461841
  475855
  476418
  479425
  488527
  488842
  493375
  517078
  517765
  519211
  522579
  526058
  537508
  550021
  550137
  553321
  555011
  568023
  569001
  581306
  583219
  586358
  586394
  589120
  596324
  605267
  606331
  606332
  607296
  607378
  614890
  623925
  641118
  646796
  726239
  742402
  760316
  761061
  765123
  779182
  785899
  786217
  789848
  790361
  790362
  798825
  801507
  804272
  804612
  804617
  804644
  808340
  811230
  811274
  811362
  811366
  811369
]

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 (89769, 253445, 369221, 392079, 393029, 423769, 423772, 423775, 452946, 454562, 456542, 456547, 458446, 461841, 475855, 476418, 479425, 488527, 488842, 493375, 517078, 517765, 519211, 522579, 526058, 537508, 550021, 550137, 553321, 555011, 568023, 569001, 581306, 583219, 586358, 586394, 589120, 596324, 605267, 606331, 606332, 607296, 607378, 614890, 623925, 641118, 646796, 726239, 742402, 760316, 761061, 765123, 779182, 785899, 786217, 789848, 790361, 790362, 798825, 801507, 804272, 804612, 804617, 804644, 808340, 811230, 811274, 811362, 811366, 811369);

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

[
  "курен вебкамер milf"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'курен вебкамер milf';

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

[
  "курен вебкамер milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'курен вебкамер milf';

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 ?

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