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

[
  "suck boobs"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'suck boobs' 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
  523189
  528400
  528443
  532504
  528386
  554240
  554503
  557128
  558544
  557182
  571723
  666784
  626441
  621796
  624875
  644150
  617021
  614918
  634765
  726714
  633312
  442910
  418591
  450912
  455861
  474874
  522986
  527609
  513113
  485985
  518818
  487577
  526134
  389921
  397269
  429604
  430625
  446402
  486861
  486870
  498056
  514079
  527721
  539739
  516765
  540071
  562777
  541572
  563742
  583997
  650992
  624921
  601853
  597207
  389895
  451492
  467220
  424060
  460370
  484628
  492323
  455206
  454210
  486911
  448094
  577323
  601963
  616205
  440990
  470543
  507533
  528265
  420541
  647975
  612125
  576308
  545828
  578458
  589642
  495393
  567416
  625001
]

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 (523189, 528400, 528443, 532504, 528386, 554240, 554503, 557128, 558544, 557182, 571723, 666784, 626441, 621796, 624875, 644150, 617021, 614918, 634765, 726714, 633312, 442910, 418591, 450912, 455861, 474874, 522986, 527609, 513113, 485985, 518818, 487577, 526134, 389921, 397269, 429604, 430625, 446402, 486861, 486870, 498056, 514079, 527721, 539739, 516765, 540071, 562777, 541572, 563742, 583997, 650992, 624921, 601853, 597207, 389895, 451492, 467220, 424060, 460370, 484628, 492323, 455206, 454210, 486911, 448094, 577323, 601963, 616205, 440990, 470543, 507533, 528265, 420541, 647975, 612125, 576308, 545828, 578458, 589642, 495393, 567416, 625001);

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
  389895
  389921
  397269
  418591
  420541
  424060
  429604
  430625
  440990
  442910
  446402
  448094
  450912
  451492
  454210
  455206
  455861
  460370
  467220
  470543
  474874
  484628
  485985
  486861
  486870
  486911
  487577
  492323
  495393
  498056
  507533
  513113
  514079
  516765
  518818
  522986
  523189
  526134
  527609
  527721
  528265
  528386
  528400
  528443
  532504
  539739
  540071
  541572
  545828
  554240
  554503
  557128
  557182
  558544
  562777
  563742
  567416
  571723
  576308
  577323
  578458
  583997
  589642
  597207
  601853
  601963
  612125
  614918
  616205
  617021
  621796
  624875
  624921
  625001
  626441
  633312
  634765
  644150
  647975
  650992
  666784
  726714
]

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 (389895, 389921, 397269, 418591, 420541, 424060, 429604, 430625, 440990, 442910, 446402, 448094, 450912, 451492, 454210, 455206, 455861, 460370, 467220, 470543, 474874, 484628, 485985, 486861, 486870, 486911, 487577, 492323, 495393, 498056, 507533, 513113, 514079, 516765, 518818, 522986, 523189, 526134, 527609, 527721, 528265, 528386, 528400, 528443, 532504, 539739, 540071, 541572, 545828, 554240, 554503, 557128, 557182, 558544, 562777, 563742, 567416, 571723, 576308, 577323, 578458, 583997, 589642, 597207, 601853, 601963, 612125, 614918, 616205, 617021, 621796, 624875, 624921, 625001, 626441, 633312, 634765, 644150, 647975, 650992, 666784, 726714);

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
  389895
  389921
  397269
  418591
  420541
  424060
  429604
  430625
  440990
  442910
  446402
  448094
  450912
  451492
  454210
  455206
  455861
  460370
  467220
  470543
  474874
  484628
  485985
  486861
  486870
  486911
  487577
  492323
  495393
  498056
  507533
  513113
  514079
  516765
  518818
  522986
  523189
  526134
  527609
  527721
  528265
  528386
  528400
  528443
  532504
  539739
  540071
  541572
  545828
  554240
  554503
  557128
  557182
  558544
  562777
  563742
  567416
  571723
  576308
  577323
  578458
  583997
  589642
  597207
  601853
  601963
  612125
  614918
  616205
  617021
  621796
  624875
  624921
  625001
  626441
  633312
  634765
  644150
  647975
  650992
  666784
  726714
]

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 (389895, 389921, 397269, 418591, 420541, 424060, 429604, 430625, 440990, 442910, 446402, 448094, 450912, 451492, 454210, 455206, 455861, 460370, 467220, 470543, 474874, 484628, 485985, 486861, 486870, 486911, 487577, 492323, 495393, 498056, 507533, 513113, 514079, 516765, 518818, 522986, 523189, 526134, 527609, 527721, 528265, 528386, 528400, 528443, 532504, 539739, 540071, 541572, 545828, 554240, 554503, 557128, 557182, 558544, 562777, 563742, 567416, 571723, 576308, 577323, 578458, 583997, 589642, 597207, 601853, 601963, 612125, 614918, 616205, 617021, 621796, 624875, 624921, 625001, 626441, 633312, 634765, 644150, 647975, 650992, 666784, 726714);

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

[
  "suck boobs"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'suck boobs';

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

[
  "suck boobs"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'suck boobs';