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

[
  "car ebony"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'car ebony' 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
  542296
  472279
  532277
  780939
  700845
  637450
  599781
  641109
  384243
  385941
  151163
  562821
  485795
  391074
  382493
  533941
  810244
  809628
  485159
  739607
  382514
  637955
  383079
  383577
  690516
  665074
  804390
  738981
  631186
  51659
  648284
  710321
  587259
  488937
  648046
  784397
  744430
  477899
  543011
  676939
  624765
  532086
  636419
  402869
  413485
  605058
  549899
  704429
  560168
  575411
  621648
  806362
  777067
  743858
  534380
  777079
  413495
  584623
  638248
  741441
  770520
  777073
  525344
  565439
  464922
  553446
  539192
  689634
  638967
  673133
  807023
  523099
  431558
  427174
]

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 (542296, 472279, 532277, 780939, 700845, 637450, 599781, 641109, 384243, 385941, 151163, 562821, 485795, 391074, 382493, 533941, 810244, 809628, 485159, 739607, 382514, 637955, 383079, 383577, 690516, 665074, 804390, 738981, 631186, 51659, 648284, 710321, 587259, 488937, 648046, 784397, 744430, 477899, 543011, 676939, 624765, 532086, 636419, 402869, 413485, 605058, 549899, 704429, 560168, 575411, 621648, 806362, 777067, 743858, 534380, 777079, 413495, 584623, 638248, 741441, 770520, 777073, 525344, 565439, 464922, 553446, 539192, 689634, 638967, 673133, 807023, 523099, 431558, 427174);

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
  51659
  151163
  382493
  382514
  383079
  383577
  384243
  385941
  391074
  402869
  413485
  413495
  427174
  431558
  464922
  472279
  477899
  485159
  485795
  488937
  523099
  525344
  532086
  532277
  533941
  539192
  542296
  543011
  549899
  553446
  560168
  562821
  565439
  575411
  584623
  587259
  599781
  605058
  621648
  624765
  631186
  636419
  637450
  637955
  638248
  638967
  641109
  648046
  648284
  665074
  673133
  676939
  689634
  690516
  700845
  704429
  710321
  738981
  739607
  741441
  743858
  744430
  770520
  777067
  777073
  777079
  780939
  784397
  804390
  806362
  807023
  809628
  810244
]

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 (51659, 151163, 382493, 382514, 383079, 383577, 384243, 385941, 391074, 402869, 413485, 413495, 427174, 431558, 464922, 472279, 477899, 485159, 485795, 488937, 523099, 525344, 532086, 532277, 533941, 539192, 542296, 543011, 549899, 553446, 560168, 562821, 565439, 575411, 584623, 587259, 599781, 605058, 621648, 624765, 631186, 636419, 637450, 637955, 638248, 638967, 641109, 648046, 648284, 665074, 673133, 676939, 689634, 690516, 700845, 704429, 710321, 738981, 739607, 741441, 743858, 744430, 770520, 777067, 777073, 777079, 780939, 784397, 804390, 806362, 807023, 809628, 810244);

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
  51659
  151163
  382493
  382514
  383079
  383577
  384243
  385941
  391074
  402869
  413485
  413495
  427174
  431558
  464922
  472279
  477899
  485159
  485795
  488937
  523099
  525344
  532086
  532277
  533941
  539192
  542296
  543011
  549899
  553446
  560168
  562821
  565439
  575411
  584623
  587259
  599781
  605058
  621648
  624765
  631186
  636419
  637450
  637955
  638248
  638967
  641109
  648046
  648284
  665074
  673133
  676939
  689634
  690516
  700845
  704429
  710321
  738981
  739607
  741441
  743858
  744430
  770520
  777067
  777073
  777079
  780939
  784397
  804390
  806362
  807023
  809628
  810244
]

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 (51659, 151163, 382493, 382514, 383079, 383577, 384243, 385941, 391074, 402869, 413485, 413495, 427174, 431558, 464922, 472279, 477899, 485159, 485795, 488937, 523099, 525344, 532086, 532277, 533941, 539192, 542296, 543011, 549899, 553446, 560168, 562821, 565439, 575411, 584623, 587259, 599781, 605058, 621648, 624765, 631186, 636419, 637450, 637955, 638248, 638967, 641109, 648046, 648284, 665074, 673133, 676939, 689634, 690516, 700845, 704429, 710321, 738981, 739607, 741441, 743858, 744430, 770520, 777067, 777073, 777079, 780939, 784397, 804390, 806362, 807023, 809628, 810244);

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 ?

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