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

[
  "indian chubby"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'indian chubby' 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
  825954
  587591
  826063
  543173
  827281
  825953
  826171
  826281
  532100
  743011
  736188
  825261
  536531
  547520
  685318
  826282
  823608
  550636
  546080
  558726
  797043
  740257
  810012
  550425
  629544
  607688
  796787
  734183
  736219
  825789
  820096
  559342
  666114
  526437
  666120
  640148
  630370
  812388
  726948
  640477
  599810
  810521
  736178
  562974
  573502
  614118
  814399
  492136
  577101
  559356
  589664
  630092
  736226
  796822
  527910
  433382
  476564
  546113
  570747
  582235
  546119
  660457
  489183
  433038
  543794
  471780
  492445
  433391
  433047
  433040
  521807
  472299
  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 (825954, 587591, 826063, 543173, 827281, 825953, 826171, 826281, 532100, 743011, 736188, 825261, 536531, 547520, 685318, 826282, 823608, 550636, 546080, 558726, 797043, 740257, 810012, 550425, 629544, 607688, 796787, 734183, 736219, 825789, 820096, 559342, 666114, 526437, 666120, 640148, 630370, 812388, 726948, 640477, 599810, 810521, 736178, 562974, 573502, 614118, 814399, 492136, 577101, 559356, 589664, 630092, 736226, 796822, 527910, 433382, 476564, 546113, 570747, 582235, 546119, 660457, 489183, 433038, 543794, 471780, 492445, 433391, 433047, 433040, 521807, 472299, 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
  433038
  433040
  433047
  433382
  433391
  471780
  472299
  476564
  489183
  492136
  492445
  521807
  526437
  527910
  532100
  536531
  543173
  543794
  546080
  546113
  546119
  547520
  550425
  550636
  558726
  559342
  559356
  562974
  570747
  573502
  577101
  582235
  587591
  589664
  599810
  601101
  607688
  614118
  629544
  630092
  630370
  640148
  640477
  660457
  666114
  666120
  685318
  726948
  734183
  736178
  736188
  736219
  736226
  740257
  743011
  796787
  796822
  797043
  810012
  810521
  812388
  814399
  820096
  823608
  825261
  825789
  825953
  825954
  826063
  826171
  826281
  826282
  827281
]

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 (433038, 433040, 433047, 433382, 433391, 471780, 472299, 476564, 489183, 492136, 492445, 521807, 526437, 527910, 532100, 536531, 543173, 543794, 546080, 546113, 546119, 547520, 550425, 550636, 558726, 559342, 559356, 562974, 570747, 573502, 577101, 582235, 587591, 589664, 599810, 601101, 607688, 614118, 629544, 630092, 630370, 640148, 640477, 660457, 666114, 666120, 685318, 726948, 734183, 736178, 736188, 736219, 736226, 740257, 743011, 796787, 796822, 797043, 810012, 810521, 812388, 814399, 820096, 823608, 825261, 825789, 825953, 825954, 826063, 826171, 826281, 826282, 827281);

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
  433038
  433040
  433047
  433382
  433391
  471780
  472299
  476564
  489183
  492136
  492445
  521807
  526437
  527910
  532100
  536531
  543173
  543794
  546080
  546113
  546119
  547520
  550425
  550636
  558726
  559342
  559356
  562974
  570747
  573502
  577101
  582235
  587591
  589664
  599810
  601101
  607688
  614118
  629544
  630092
  630370
  640148
  640477
  660457
  666114
  666120
  685318
  726948
  734183
  736178
  736188
  736219
  736226
  740257
  743011
  796787
  796822
  797043
  810012
  810521
  812388
  814399
  820096
  823608
  825261
  825789
  825953
  825954
  826063
  826171
  826281
  826282
  827281
]

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 (433038, 433040, 433047, 433382, 433391, 471780, 472299, 476564, 489183, 492136, 492445, 521807, 526437, 527910, 532100, 536531, 543173, 543794, 546080, 546113, 546119, 547520, 550425, 550636, 558726, 559342, 559356, 562974, 570747, 573502, 577101, 582235, 587591, 589664, 599810, 601101, 607688, 614118, 629544, 630092, 630370, 640148, 640477, 660457, 666114, 666120, 685318, 726948, 734183, 736178, 736188, 736219, 736226, 740257, 743011, 796787, 796822, 797043, 810012, 810521, 812388, 814399, 820096, 823608, 825261, 825789, 825953, 825954, 826063, 826171, 826281, 826282, 827281);

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

[
  "indian chubby"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'indian chubby';

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

[
  "indian chubby"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'indian chubby';

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 ?

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