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

[
  "does"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'does' 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
  440041
  447480
  464237
  421832
  447486
  501228
  515567
  516551
  485138
  521167
  527495
  395620
  395894
  404585
  414779
  418385
  421995
  471148
  501253
  537908
  535537
  504754
  510074
  528329
  528358
  544530
  551268
  677963
  546123
  555149
  596226
  604507
  605470
  609237
  811466
  624511
  439572
  472712
  390642
  419622
  470481
  405145
  439460
  431333
  439813
  456028
  475833
  477454
  504186
  484797
  494589
  520290
  489382
  527085
  444838
  415978
  514653
  528282
  474706
  559065
  558786
  555915
  590427
  600410
  598510
  417811
  440426
  501487
  473539
  508180
  516432
  546511
  621463
  605461
  444654
  559017
  462450
  514113
  497935
  512222
  602003
  620754
  535511
  512885
  606799
  596839
]

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 (440041, 447480, 464237, 421832, 447486, 501228, 515567, 516551, 485138, 521167, 527495, 395620, 395894, 404585, 414779, 418385, 421995, 471148, 501253, 537908, 535537, 504754, 510074, 528329, 528358, 544530, 551268, 677963, 546123, 555149, 596226, 604507, 605470, 609237, 811466, 624511, 439572, 472712, 390642, 419622, 470481, 405145, 439460, 431333, 439813, 456028, 475833, 477454, 504186, 484797, 494589, 520290, 489382, 527085, 444838, 415978, 514653, 528282, 474706, 559065, 558786, 555915, 590427, 600410, 598510, 417811, 440426, 501487, 473539, 508180, 516432, 546511, 621463, 605461, 444654, 559017, 462450, 514113, 497935, 512222, 602003, 620754, 535511, 512885, 606799, 596839);

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
  390642
  395620
  395894
  404585
  405145
  414779
  415978
  417811
  418385
  419622
  421832
  421995
  431333
  439460
  439572
  439813
  440041
  440426
  444654
  444838
  447480
  447486
  456028
  462450
  464237
  470481
  471148
  472712
  473539
  474706
  475833
  477454
  484797
  485138
  489382
  494589
  497935
  501228
  501253
  501487
  504186
  504754
  508180
  510074
  512222
  512885
  514113
  514653
  515567
  516432
  516551
  520290
  521167
  527085
  527495
  528282
  528329
  528358
  535511
  535537
  537908
  544530
  546123
  546511
  551268
  555149
  555915
  558786
  559017
  559065
  590427
  596226
  596839
  598510
  600410
  602003
  604507
  605461
  605470
  606799
  609237
  620754
  621463
  624511
  677963
  811466
]

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 (390642, 395620, 395894, 404585, 405145, 414779, 415978, 417811, 418385, 419622, 421832, 421995, 431333, 439460, 439572, 439813, 440041, 440426, 444654, 444838, 447480, 447486, 456028, 462450, 464237, 470481, 471148, 472712, 473539, 474706, 475833, 477454, 484797, 485138, 489382, 494589, 497935, 501228, 501253, 501487, 504186, 504754, 508180, 510074, 512222, 512885, 514113, 514653, 515567, 516432, 516551, 520290, 521167, 527085, 527495, 528282, 528329, 528358, 535511, 535537, 537908, 544530, 546123, 546511, 551268, 555149, 555915, 558786, 559017, 559065, 590427, 596226, 596839, 598510, 600410, 602003, 604507, 605461, 605470, 606799, 609237, 620754, 621463, 624511, 677963, 811466);

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
  390642
  395620
  395894
  404585
  405145
  414779
  415978
  417811
  418385
  419622
  421832
  421995
  431333
  439460
  439572
  439813
  440041
  440426
  444654
  444838
  447480
  447486
  456028
  462450
  464237
  470481
  471148
  472712
  473539
  474706
  475833
  477454
  484797
  485138
  489382
  494589
  497935
  501228
  501253
  501487
  504186
  504754
  508180
  510074
  512222
  512885
  514113
  514653
  515567
  516432
  516551
  520290
  521167
  527085
  527495
  528282
  528329
  528358
  535511
  535537
  537908
  544530
  546123
  546511
  551268
  555149
  555915
  558786
  559017
  559065
  590427
  596226
  596839
  598510
  600410
  602003
  604507
  605461
  605470
  606799
  609237
  620754
  621463
  624511
  677963
  811466
]

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 (390642, 395620, 395894, 404585, 405145, 414779, 415978, 417811, 418385, 419622, 421832, 421995, 431333, 439460, 439572, 439813, 440041, 440426, 444654, 444838, 447480, 447486, 456028, 462450, 464237, 470481, 471148, 472712, 473539, 474706, 475833, 477454, 484797, 485138, 489382, 494589, 497935, 501228, 501253, 501487, 504186, 504754, 508180, 510074, 512222, 512885, 514113, 514653, 515567, 516432, 516551, 520290, 521167, 527085, 527495, 528282, 528329, 528358, 535511, 535537, 537908, 544530, 546123, 546511, 551268, 555149, 555915, 558786, 559017, 559065, 590427, 596226, 596839, 598510, 600410, 602003, 604507, 605461, 605470, 606799, 609237, 620754, 621463, 624511, 677963, 811466);

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

[
  "does"
]

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

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

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

[
  "does"
]

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

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