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

[
  "hot young milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot young milf' 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
  726553
  409506
  411863
  428895
  467250
  400857
  467975
  421494
  492912
  517478
  512717
  543772
  607374
  511009
  524141
  523335
  389066
  420891
  449889
  458718
  459877
  525189
  512533
  522622
  483386
  650849
  789665
  726487
  401933
  439649
  469017
  448333
  462317
  462483
  469338
  540800
  536584
  609953
  431112
  814901
  451796
  498022
  529212
  494770
  503967
  534845
  493102
  414315
  502794
  513480
  513506
  486110
  490182
  519087
  484672
  491473
  512927
  430827
  514824
  515972
  516885
  556830
  454709
  474147
  508860
  432751
  532680
  551012
  621655
  487717
  489950
  518438
  453313
  565783
  624226
]

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 (726553, 409506, 411863, 428895, 467250, 400857, 467975, 421494, 492912, 517478, 512717, 543772, 607374, 511009, 524141, 523335, 389066, 420891, 449889, 458718, 459877, 525189, 512533, 522622, 483386, 650849, 789665, 726487, 401933, 439649, 469017, 448333, 462317, 462483, 469338, 540800, 536584, 609953, 431112, 814901, 451796, 498022, 529212, 494770, 503967, 534845, 493102, 414315, 502794, 513480, 513506, 486110, 490182, 519087, 484672, 491473, 512927, 430827, 514824, 515972, 516885, 556830, 454709, 474147, 508860, 432751, 532680, 551012, 621655, 487717, 489950, 518438, 453313, 565783, 624226);

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
  389066
  400857
  401933
  409506
  411863
  414315
  420891
  421494
  428895
  430827
  431112
  432751
  439649
  448333
  449889
  451796
  453313
  454709
  458718
  459877
  462317
  462483
  467250
  467975
  469017
  469338
  474147
  483386
  484672
  486110
  487717
  489950
  490182
  491473
  492912
  493102
  494770
  498022
  502794
  503967
  508860
  511009
  512533
  512717
  512927
  513480
  513506
  514824
  515972
  516885
  517478
  518438
  519087
  522622
  523335
  524141
  525189
  529212
  532680
  534845
  536584
  540800
  543772
  551012
  556830
  565783
  607374
  609953
  621655
  624226
  650849
  726487
  726553
  789665
  814901
]

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 (389066, 400857, 401933, 409506, 411863, 414315, 420891, 421494, 428895, 430827, 431112, 432751, 439649, 448333, 449889, 451796, 453313, 454709, 458718, 459877, 462317, 462483, 467250, 467975, 469017, 469338, 474147, 483386, 484672, 486110, 487717, 489950, 490182, 491473, 492912, 493102, 494770, 498022, 502794, 503967, 508860, 511009, 512533, 512717, 512927, 513480, 513506, 514824, 515972, 516885, 517478, 518438, 519087, 522622, 523335, 524141, 525189, 529212, 532680, 534845, 536584, 540800, 543772, 551012, 556830, 565783, 607374, 609953, 621655, 624226, 650849, 726487, 726553, 789665, 814901);

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
  389066
  400857
  401933
  409506
  411863
  414315
  420891
  421494
  428895
  430827
  431112
  432751
  439649
  448333
  449889
  451796
  453313
  454709
  458718
  459877
  462317
  462483
  467250
  467975
  469017
  469338
  474147
  483386
  484672
  486110
  487717
  489950
  490182
  491473
  492912
  493102
  494770
  498022
  502794
  503967
  508860
  511009
  512533
  512717
  512927
  513480
  513506
  514824
  515972
  516885
  517478
  518438
  519087
  522622
  523335
  524141
  525189
  529212
  532680
  534845
  536584
  540800
  543772
  551012
  556830
  565783
  607374
  609953
  621655
  624226
  650849
  726487
  726553
  789665
  814901
]

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 (389066, 400857, 401933, 409506, 411863, 414315, 420891, 421494, 428895, 430827, 431112, 432751, 439649, 448333, 449889, 451796, 453313, 454709, 458718, 459877, 462317, 462483, 467250, 467975, 469017, 469338, 474147, 483386, 484672, 486110, 487717, 489950, 490182, 491473, 492912, 493102, 494770, 498022, 502794, 503967, 508860, 511009, 512533, 512717, 512927, 513480, 513506, 514824, 515972, 516885, 517478, 518438, 519087, 522622, 523335, 524141, 525189, 529212, 532680, 534845, 536584, 540800, 543772, 551012, 556830, 565783, 607374, 609953, 621655, 624226, 650849, 726487, 726553, 789665, 814901);

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

[
  "hot young milf"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'hot young milf';

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

[
  "hot young milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot young milf';