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

[
  "19 old casting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = '19 old casting' 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
  649960
  646851
  702163
  545773
  565245
  640813
  586587
  597272
  634769
  628082
  459527
  454984
  419627
  483498
  620205
  537888
  539203
  536584
  537210
  537212
  518473
  531123
  532745
  558601
  541853
  545409
  545488
  545600
  545611
  553272
  566786
  680186
  666868
  680176
  634187
  628126
  594830
  602715
  599452
  632701
  632706
  633449
  494617
  510757
  470745
  605304
  421562
  553280
  513207
  418650
  533746
  540330
  536695
  545418
  648257
  628333
  632632
  519249
  465649
  483500
  484785
  533915
  530369
  509802
  418416
  545480
  582229
  527915
  521575
  516744
  522382
  527967
]

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 (649960, 646851, 702163, 545773, 565245, 640813, 586587, 597272, 634769, 628082, 459527, 454984, 419627, 483498, 620205, 537888, 539203, 536584, 537210, 537212, 518473, 531123, 532745, 558601, 541853, 545409, 545488, 545600, 545611, 553272, 566786, 680186, 666868, 680176, 634187, 628126, 594830, 602715, 599452, 632701, 632706, 633449, 494617, 510757, 470745, 605304, 421562, 553280, 513207, 418650, 533746, 540330, 536695, 545418, 648257, 628333, 632632, 519249, 465649, 483500, 484785, 533915, 530369, 509802, 418416, 545480, 582229, 527915, 521575, 516744, 522382, 527967);

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
  418416
  418650
  419627
  421562
  454984
  459527
  465649
  470745
  483498
  483500
  484785
  494617
  509802
  510757
  513207
  516744
  518473
  519249
  521575
  522382
  527915
  527967
  530369
  531123
  532745
  533746
  533915
  536584
  536695
  537210
  537212
  537888
  539203
  540330
  541853
  545409
  545418
  545480
  545488
  545600
  545611
  545773
  553272
  553280
  558601
  565245
  566786
  582229
  586587
  594830
  597272
  599452
  602715
  605304
  620205
  628082
  628126
  628333
  632632
  632701
  632706
  633449
  634187
  634769
  640813
  646851
  648257
  649960
  666868
  680176
  680186
  702163
]

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 (418416, 418650, 419627, 421562, 454984, 459527, 465649, 470745, 483498, 483500, 484785, 494617, 509802, 510757, 513207, 516744, 518473, 519249, 521575, 522382, 527915, 527967, 530369, 531123, 532745, 533746, 533915, 536584, 536695, 537210, 537212, 537888, 539203, 540330, 541853, 545409, 545418, 545480, 545488, 545600, 545611, 545773, 553272, 553280, 558601, 565245, 566786, 582229, 586587, 594830, 597272, 599452, 602715, 605304, 620205, 628082, 628126, 628333, 632632, 632701, 632706, 633449, 634187, 634769, 640813, 646851, 648257, 649960, 666868, 680176, 680186, 702163);

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
  418416
  418650
  419627
  421562
  454984
  459527
  465649
  470745
  483498
  483500
  484785
  494617
  509802
  510757
  513207
  516744
  518473
  519249
  521575
  522382
  527915
  527967
  530369
  531123
  532745
  533746
  533915
  536584
  536695
  537210
  537212
  537888
  539203
  540330
  541853
  545409
  545418
  545480
  545488
  545600
  545611
  545773
  553272
  553280
  558601
  565245
  566786
  582229
  586587
  594830
  597272
  599452
  602715
  605304
  620205
  628082
  628126
  628333
  632632
  632701
  632706
  633449
  634187
  634769
  640813
  646851
  648257
  649960
  666868
  680176
  680186
  702163
]

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 (418416, 418650, 419627, 421562, 454984, 459527, 465649, 470745, 483498, 483500, 484785, 494617, 509802, 510757, 513207, 516744, 518473, 519249, 521575, 522382, 527915, 527967, 530369, 531123, 532745, 533746, 533915, 536584, 536695, 537210, 537212, 537888, 539203, 540330, 541853, 545409, 545418, 545480, 545488, 545600, 545611, 545773, 553272, 553280, 558601, 565245, 566786, 582229, 586587, 594830, 597272, 599452, 602715, 605304, 620205, 628082, 628126, 628333, 632632, 632701, 632706, 633449, 634187, 634769, 640813, 646851, 648257, 649960, 666868, 680176, 680186, 702163);

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

[
  "19 old кастинг"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = '19 old кастинг';

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

[
  "19 old кастинг"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = '19 old кастинг';

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 ?

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