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

[
  "beauty model"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty model' 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
  624039
  791034
  633485
  462798
  404257
  434071
  434782
  442435
  471716
  480821
  508348
  511929
  488608
  524627
  492601
  497663
  524748
  528652
  476767
  524530
  530935
  602011
  574511
  565400
  580238
  599436
  586639
  600496
  419674
  426030
  448498
  458773
  415387
  421991
  405093
  417897
  428392
  456839
  473537
  518921
  526195
  509736
  524752
  535015
  435078
  500767
  575756
  567134
  624221
  418323
  435428
  395984
  424748
  520572
  495631
  514151
  602610
  558249
  628175
  599962
  451173
  467155
  596467
  649123
  524620
  594802
  620203
  625003
  553411
  577909
  623235
  510266
  661926
  612455
  492555
  522049
]

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 (624039, 791034, 633485, 462798, 404257, 434071, 434782, 442435, 471716, 480821, 508348, 511929, 488608, 524627, 492601, 497663, 524748, 528652, 476767, 524530, 530935, 602011, 574511, 565400, 580238, 599436, 586639, 600496, 419674, 426030, 448498, 458773, 415387, 421991, 405093, 417897, 428392, 456839, 473537, 518921, 526195, 509736, 524752, 535015, 435078, 500767, 575756, 567134, 624221, 418323, 435428, 395984, 424748, 520572, 495631, 514151, 602610, 558249, 628175, 599962, 451173, 467155, 596467, 649123, 524620, 594802, 620203, 625003, 553411, 577909, 623235, 510266, 661926, 612455, 492555, 522049);

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
  395984
  404257
  405093
  415387
  417897
  418323
  419674
  421991
  424748
  426030
  428392
  434071
  434782
  435078
  435428
  442435
  448498
  451173
  456839
  458773
  462798
  467155
  471716
  473537
  476767
  480821
  488608
  492555
  492601
  495631
  497663
  500767
  508348
  509736
  510266
  511929
  514151
  518921
  520572
  522049
  524530
  524620
  524627
  524748
  524752
  526195
  528652
  530935
  535015
  553411
  558249
  565400
  567134
  574511
  575756
  577909
  580238
  586639
  594802
  596467
  599436
  599962
  600496
  602011
  602610
  612455
  620203
  623235
  624039
  624221
  625003
  628175
  633485
  649123
  661926
  791034
]

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 (395984, 404257, 405093, 415387, 417897, 418323, 419674, 421991, 424748, 426030, 428392, 434071, 434782, 435078, 435428, 442435, 448498, 451173, 456839, 458773, 462798, 467155, 471716, 473537, 476767, 480821, 488608, 492555, 492601, 495631, 497663, 500767, 508348, 509736, 510266, 511929, 514151, 518921, 520572, 522049, 524530, 524620, 524627, 524748, 524752, 526195, 528652, 530935, 535015, 553411, 558249, 565400, 567134, 574511, 575756, 577909, 580238, 586639, 594802, 596467, 599436, 599962, 600496, 602011, 602610, 612455, 620203, 623235, 624039, 624221, 625003, 628175, 633485, 649123, 661926, 791034);

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
  395984
  404257
  405093
  415387
  417897
  418323
  419674
  421991
  424748
  426030
  428392
  434071
  434782
  435078
  435428
  442435
  448498
  451173
  456839
  458773
  462798
  467155
  471716
  473537
  476767
  480821
  488608
  492555
  492601
  495631
  497663
  500767
  508348
  509736
  510266
  511929
  514151
  518921
  520572
  522049
  524530
  524620
  524627
  524748
  524752
  526195
  528652
  530935
  535015
  553411
  558249
  565400
  567134
  574511
  575756
  577909
  580238
  586639
  594802
  596467
  599436
  599962
  600496
  602011
  602610
  612455
  620203
  623235
  624039
  624221
  625003
  628175
  633485
  649123
  661926
  791034
]

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 (395984, 404257, 405093, 415387, 417897, 418323, 419674, 421991, 424748, 426030, 428392, 434071, 434782, 435078, 435428, 442435, 448498, 451173, 456839, 458773, 462798, 467155, 471716, 473537, 476767, 480821, 488608, 492555, 492601, 495631, 497663, 500767, 508348, 509736, 510266, 511929, 514151, 518921, 520572, 522049, 524530, 524620, 524627, 524748, 524752, 526195, 528652, 530935, 535015, 553411, 558249, 565400, 567134, 574511, 575756, 577909, 580238, 586639, 594802, 596467, 599436, 599962, 600496, 602011, 602610, 612455, 620203, 623235, 624039, 624221, 625003, 628175, 633485, 649123, 661926, 791034);

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

[
  "beauty model"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'beauty model';

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

[
  "beauty model"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty model';