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

[
  "if you can"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'if you can' 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
  511186
  511623
  523241
  570940
  656320
  646876
  650856
  681394
  699325
  613004
  589602
  611204
  777223
  792173
  813085
  770599
  744524
  758122
  615385
  780267
  459900
  382604
  401383
  411603
  458996
  531635
  538294
  580511
  552478
  558598
  697542
  556019
  559047
  606333
  627699
  797119
  812831
  639152
  488352
  508730
  512901
  509576
  430212
  463464
  449461
  449473
  467340
  476502
  488491
  543547
  571089
  574958
  571014
  647693
  662104
  562398
  565218
  604101
  623962
  631083
  443195
  476505
  523918
  515846
  527017
  445602
  449512
  520832
  581320
  478107
  503172
  519460
  449372
  449508
  682909
  574243
  535655
  507666
  533079
  540350
  517769
  528723
  503905
]

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 (511186, 511623, 523241, 570940, 656320, 646876, 650856, 681394, 699325, 613004, 589602, 611204, 777223, 792173, 813085, 770599, 744524, 758122, 615385, 780267, 459900, 382604, 401383, 411603, 458996, 531635, 538294, 580511, 552478, 558598, 697542, 556019, 559047, 606333, 627699, 797119, 812831, 639152, 488352, 508730, 512901, 509576, 430212, 463464, 449461, 449473, 467340, 476502, 488491, 543547, 571089, 574958, 571014, 647693, 662104, 562398, 565218, 604101, 623962, 631083, 443195, 476505, 523918, 515846, 527017, 445602, 449512, 520832, 581320, 478107, 503172, 519460, 449372, 449508, 682909, 574243, 535655, 507666, 533079, 540350, 517769, 528723, 503905);

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
  382604
  401383
  411603
  430212
  443195
  445602
  449372
  449461
  449473
  449508
  449512
  458996
  459900
  463464
  467340
  476502
  476505
  478107
  488352
  488491
  503172
  503905
  507666
  508730
  509576
  511186
  511623
  512901
  515846
  517769
  519460
  520832
  523241
  523918
  527017
  528723
  531635
  533079
  535655
  538294
  540350
  543547
  552478
  556019
  558598
  559047
  562398
  565218
  570940
  571014
  571089
  574243
  574958
  580511
  581320
  589602
  604101
  606333
  611204
  613004
  615385
  623962
  627699
  631083
  639152
  646876
  647693
  650856
  656320
  662104
  681394
  682909
  697542
  699325
  744524
  758122
  770599
  777223
  780267
  792173
  797119
  812831
  813085
]

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 (382604, 401383, 411603, 430212, 443195, 445602, 449372, 449461, 449473, 449508, 449512, 458996, 459900, 463464, 467340, 476502, 476505, 478107, 488352, 488491, 503172, 503905, 507666, 508730, 509576, 511186, 511623, 512901, 515846, 517769, 519460, 520832, 523241, 523918, 527017, 528723, 531635, 533079, 535655, 538294, 540350, 543547, 552478, 556019, 558598, 559047, 562398, 565218, 570940, 571014, 571089, 574243, 574958, 580511, 581320, 589602, 604101, 606333, 611204, 613004, 615385, 623962, 627699, 631083, 639152, 646876, 647693, 650856, 656320, 662104, 681394, 682909, 697542, 699325, 744524, 758122, 770599, 777223, 780267, 792173, 797119, 812831, 813085);

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
  382604
  401383
  411603
  430212
  443195
  445602
  449372
  449461
  449473
  449508
  449512
  458996
  459900
  463464
  467340
  476502
  476505
  478107
  488352
  488491
  503172
  503905
  507666
  508730
  509576
  511186
  511623
  512901
  515846
  517769
  519460
  520832
  523241
  523918
  527017
  528723
  531635
  533079
  535655
  538294
  540350
  543547
  552478
  556019
  558598
  559047
  562398
  565218
  570940
  571014
  571089
  574243
  574958
  580511
  581320
  589602
  604101
  606333
  611204
  613004
  615385
  623962
  627699
  631083
  639152
  646876
  647693
  650856
  656320
  662104
  681394
  682909
  697542
  699325
  744524
  758122
  770599
  777223
  780267
  792173
  797119
  812831
  813085
]

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 (382604, 401383, 411603, 430212, 443195, 445602, 449372, 449461, 449473, 449508, 449512, 458996, 459900, 463464, 467340, 476502, 476505, 478107, 488352, 488491, 503172, 503905, 507666, 508730, 509576, 511186, 511623, 512901, 515846, 517769, 519460, 520832, 523241, 523918, 527017, 528723, 531635, 533079, 535655, 538294, 540350, 543547, 552478, 556019, 558598, 559047, 562398, 565218, 570940, 571014, 571089, 574243, 574958, 580511, 581320, 589602, 604101, 606333, 611204, 613004, 615385, 623962, 627699, 631083, 639152, 646876, 647693, 650856, 656320, 662104, 681394, 682909, 697542, 699325, 744524, 758122, 770599, 777223, 780267, 792173, 797119, 812831, 813085);

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

[
  "you can"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'you can';

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

[
  "you can"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'you can';