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

[
  "fucking girlfriend"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fucking girlfriend' 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
  438935
  503013
  517475
  448076
  513128
  552584
  562618
  567821
  579812
  548306
  567409
  670848
  578954
  630566
  590319
  643488
  624160
  593172
  595868
  747223
  747194
  448647
  423782
  479878
  416099
  445756
  424560
  523435
  516387
  424995
  442964
  458978
  458985
  476632
  522103
  557252
  558704
  582833
  554580
  633454
  636593
  747195
  747228
  747231
  763437
  417898
  462830
  470443
  473258
  501717
  519680
  484123
  488829
  524143
  470092
  458486
  471299
  512345
  512844
  522668
  561284
  561297
  663370
  598184
  747236
  515818
  525542
  535279
  559009
  448260
  442387
  521971
  514413
  508492
  613220
]

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 (438935, 503013, 517475, 448076, 513128, 552584, 562618, 567821, 579812, 548306, 567409, 670848, 578954, 630566, 590319, 643488, 624160, 593172, 595868, 747223, 747194, 448647, 423782, 479878, 416099, 445756, 424560, 523435, 516387, 424995, 442964, 458978, 458985, 476632, 522103, 557252, 558704, 582833, 554580, 633454, 636593, 747195, 747228, 747231, 763437, 417898, 462830, 470443, 473258, 501717, 519680, 484123, 488829, 524143, 470092, 458486, 471299, 512345, 512844, 522668, 561284, 561297, 663370, 598184, 747236, 515818, 525542, 535279, 559009, 448260, 442387, 521971, 514413, 508492, 613220);

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
  416099
  417898
  423782
  424560
  424995
  438935
  442387
  442964
  445756
  448076
  448260
  448647
  458486
  458978
  458985
  462830
  470092
  470443
  471299
  473258
  476632
  479878
  484123
  488829
  501717
  503013
  508492
  512345
  512844
  513128
  514413
  515818
  516387
  517475
  519680
  521971
  522103
  522668
  523435
  524143
  525542
  535279
  548306
  552584
  554580
  557252
  558704
  559009
  561284
  561297
  562618
  567409
  567821
  578954
  579812
  582833
  590319
  593172
  595868
  598184
  613220
  624160
  630566
  633454
  636593
  643488
  663370
  670848
  747194
  747195
  747223
  747228
  747231
  747236
  763437
]

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 (416099, 417898, 423782, 424560, 424995, 438935, 442387, 442964, 445756, 448076, 448260, 448647, 458486, 458978, 458985, 462830, 470092, 470443, 471299, 473258, 476632, 479878, 484123, 488829, 501717, 503013, 508492, 512345, 512844, 513128, 514413, 515818, 516387, 517475, 519680, 521971, 522103, 522668, 523435, 524143, 525542, 535279, 548306, 552584, 554580, 557252, 558704, 559009, 561284, 561297, 562618, 567409, 567821, 578954, 579812, 582833, 590319, 593172, 595868, 598184, 613220, 624160, 630566, 633454, 636593, 643488, 663370, 670848, 747194, 747195, 747223, 747228, 747231, 747236, 763437);

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
  416099
  417898
  423782
  424560
  424995
  438935
  442387
  442964
  445756
  448076
  448260
  448647
  458486
  458978
  458985
  462830
  470092
  470443
  471299
  473258
  476632
  479878
  484123
  488829
  501717
  503013
  508492
  512345
  512844
  513128
  514413
  515818
  516387
  517475
  519680
  521971
  522103
  522668
  523435
  524143
  525542
  535279
  548306
  552584
  554580
  557252
  558704
  559009
  561284
  561297
  562618
  567409
  567821
  578954
  579812
  582833
  590319
  593172
  595868
  598184
  613220
  624160
  630566
  633454
  636593
  643488
  663370
  670848
  747194
  747195
  747223
  747228
  747231
  747236
  763437
]

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 (416099, 417898, 423782, 424560, 424995, 438935, 442387, 442964, 445756, 448076, 448260, 448647, 458486, 458978, 458985, 462830, 470092, 470443, 471299, 473258, 476632, 479878, 484123, 488829, 501717, 503013, 508492, 512345, 512844, 513128, 514413, 515818, 516387, 517475, 519680, 521971, 522103, 522668, 523435, 524143, 525542, 535279, 548306, 552584, 554580, 557252, 558704, 559009, 561284, 561297, 562618, 567409, 567821, 578954, 579812, 582833, 590319, 593172, 595868, 598184, 613220, 624160, 630566, 633454, 636593, 643488, 663370, 670848, 747194, 747195, 747223, 747228, 747231, 747236, 763437);

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

[
  "fucking girlfriend"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'fucking girlfriend';

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

[
  "fucking girlfriend"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fucking girlfriend';