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

[
  "tub in"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tub in' 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
  828493
  817909
  736547
  693454
  650128
  23524
  821524
  822313
  819437
  646154
  701938
  653824
  97747
  647447
  592872
  772683
  690031
  785515
  810484
  728732
  205443
  403596
  768043
  515531
  758993
  821042
  820844
  533629
  654032
  700850
  792050
  731807
  261074
  423703
  562506
  563772
  572727
  576040
  650880
  551386
  615899
  447504
  416293
  814669
  816363
  494511
  686331
  476754
  521451
  504664
  818625
  819511
  514414
  619718
  447211
  476776
  513002
  423318
  510930
  567822
  654000
  651190
  481308
  409747
  434023
  543392
  587306
  605557
  606769
  526805
  573407
  629961
  467088
  583553
]

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 (828493, 817909, 736547, 693454, 650128, 23524, 821524, 822313, 819437, 646154, 701938, 653824, 97747, 647447, 592872, 772683, 690031, 785515, 810484, 728732, 205443, 403596, 768043, 515531, 758993, 821042, 820844, 533629, 654032, 700850, 792050, 731807, 261074, 423703, 562506, 563772, 572727, 576040, 650880, 551386, 615899, 447504, 416293, 814669, 816363, 494511, 686331, 476754, 521451, 504664, 818625, 819511, 514414, 619718, 447211, 476776, 513002, 423318, 510930, 567822, 654000, 651190, 481308, 409747, 434023, 543392, 587306, 605557, 606769, 526805, 573407, 629961, 467088, 583553);

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
  23524
  97747
  205443
  261074
  403596
  409747
  416293
  423318
  423703
  434023
  447211
  447504
  467088
  476754
  476776
  481308
  494511
  504664
  510930
  513002
  514414
  515531
  521451
  526805
  533629
  543392
  551386
  562506
  563772
  567822
  572727
  573407
  576040
  583553
  587306
  592872
  605557
  606769
  615899
  619718
  629961
  646154
  647447
  650128
  650880
  651190
  653824
  654000
  654032
  686331
  690031
  693454
  700850
  701938
  728732
  731807
  736547
  758993
  768043
  772683
  785515
  792050
  810484
  814669
  816363
  817909
  818625
  819437
  819511
  820844
  821042
  821524
  822313
  828493
]

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 (23524, 97747, 205443, 261074, 403596, 409747, 416293, 423318, 423703, 434023, 447211, 447504, 467088, 476754, 476776, 481308, 494511, 504664, 510930, 513002, 514414, 515531, 521451, 526805, 533629, 543392, 551386, 562506, 563772, 567822, 572727, 573407, 576040, 583553, 587306, 592872, 605557, 606769, 615899, 619718, 629961, 646154, 647447, 650128, 650880, 651190, 653824, 654000, 654032, 686331, 690031, 693454, 700850, 701938, 728732, 731807, 736547, 758993, 768043, 772683, 785515, 792050, 810484, 814669, 816363, 817909, 818625, 819437, 819511, 820844, 821042, 821524, 822313, 828493);

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
  23524
  97747
  205443
  261074
  403596
  409747
  416293
  423318
  423703
  434023
  447211
  447504
  467088
  476754
  476776
  481308
  494511
  504664
  510930
  513002
  514414
  515531
  521451
  526805
  533629
  543392
  551386
  562506
  563772
  567822
  572727
  573407
  576040
  583553
  587306
  592872
  605557
  606769
  615899
  619718
  629961
  646154
  647447
  650128
  650880
  651190
  653824
  654000
  654032
  686331
  690031
  693454
  700850
  701938
  728732
  731807
  736547
  758993
  768043
  772683
  785515
  792050
  810484
  814669
  816363
  817909
  818625
  819437
  819511
  820844
  821042
  821524
  822313
  828493
]

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 (23524, 97747, 205443, 261074, 403596, 409747, 416293, 423318, 423703, 434023, 447211, 447504, 467088, 476754, 476776, 481308, 494511, 504664, 510930, 513002, 514414, 515531, 521451, 526805, 533629, 543392, 551386, 562506, 563772, 567822, 572727, 573407, 576040, 583553, 587306, 592872, 605557, 606769, 615899, 619718, 629961, 646154, 647447, 650128, 650880, 651190, 653824, 654000, 654032, 686331, 690031, 693454, 700850, 701938, 728732, 731807, 736547, 758993, 768043, 772683, 785515, 792050, 810484, 814669, 816363, 817909, 818625, 819437, 819511, 820844, 821042, 821524, 822313, 828493);

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

[
  "tub"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'tub';

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

[
  "tub"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tub';

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 ?

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