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

[
  "milf in heels"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf in heels' 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
  724354
  730688
  728375
  605066
  456738
  433596
  465467
  464135
  505420
  508243
  485355
  497920
  506065
  447911
  447935
  496094
  538608
  480204
  571128
  675109
  675675
  675060
  675092
  704218
  704525
  675066
  675144
  675723
  589129
  589968
  600781
  791914
  447604
  476799
  505885
  515592
  508820
  516543
  502222
  624201
  429563
  825299
  490098
  516622
  510873
  556000
  675081
  709524
  675430
  675126
  555970
  586189
  639253
  509174
  447952
  430602
  425206
  471464
  507310
  513204
  503274
  541418
  555968
  585550
  447917
  526721
  515593
  486868
  544788
  675123
  590288
  592770
  617428
  703833
  462462
  575841
  486864
  624150
  524620
]

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 (724354, 730688, 728375, 605066, 456738, 433596, 465467, 464135, 505420, 508243, 485355, 497920, 506065, 447911, 447935, 496094, 538608, 480204, 571128, 675109, 675675, 675060, 675092, 704218, 704525, 675066, 675144, 675723, 589129, 589968, 600781, 791914, 447604, 476799, 505885, 515592, 508820, 516543, 502222, 624201, 429563, 825299, 490098, 516622, 510873, 556000, 675081, 709524, 675430, 675126, 555970, 586189, 639253, 509174, 447952, 430602, 425206, 471464, 507310, 513204, 503274, 541418, 555968, 585550, 447917, 526721, 515593, 486868, 544788, 675123, 590288, 592770, 617428, 703833, 462462, 575841, 486864, 624150, 524620);

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
  425206
  429563
  430602
  433596
  447604
  447911
  447917
  447935
  447952
  456738
  462462
  464135
  465467
  471464
  476799
  480204
  485355
  486864
  486868
  490098
  496094
  497920
  502222
  503274
  505420
  505885
  506065
  507310
  508243
  508820
  509174
  510873
  513204
  515592
  515593
  516543
  516622
  524620
  526721
  538608
  541418
  544788
  555968
  555970
  556000
  571128
  575841
  585550
  586189
  589129
  589968
  590288
  592770
  600781
  605066
  617428
  624150
  624201
  639253
  675060
  675066
  675081
  675092
  675109
  675123
  675126
  675144
  675430
  675675
  675723
  703833
  704218
  704525
  709524
  724354
  728375
  730688
  791914
  825299
]

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 (425206, 429563, 430602, 433596, 447604, 447911, 447917, 447935, 447952, 456738, 462462, 464135, 465467, 471464, 476799, 480204, 485355, 486864, 486868, 490098, 496094, 497920, 502222, 503274, 505420, 505885, 506065, 507310, 508243, 508820, 509174, 510873, 513204, 515592, 515593, 516543, 516622, 524620, 526721, 538608, 541418, 544788, 555968, 555970, 556000, 571128, 575841, 585550, 586189, 589129, 589968, 590288, 592770, 600781, 605066, 617428, 624150, 624201, 639253, 675060, 675066, 675081, 675092, 675109, 675123, 675126, 675144, 675430, 675675, 675723, 703833, 704218, 704525, 709524, 724354, 728375, 730688, 791914, 825299);

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
  425206
  429563
  430602
  433596
  447604
  447911
  447917
  447935
  447952
  456738
  462462
  464135
  465467
  471464
  476799
  480204
  485355
  486864
  486868
  490098
  496094
  497920
  502222
  503274
  505420
  505885
  506065
  507310
  508243
  508820
  509174
  510873
  513204
  515592
  515593
  516543
  516622
  524620
  526721
  538608
  541418
  544788
  555968
  555970
  556000
  571128
  575841
  585550
  586189
  589129
  589968
  590288
  592770
  600781
  605066
  617428
  624150
  624201
  639253
  675060
  675066
  675081
  675092
  675109
  675123
  675126
  675144
  675430
  675675
  675723
  703833
  704218
  704525
  709524
  724354
  728375
  730688
  791914
  825299
]

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 (425206, 429563, 430602, 433596, 447604, 447911, 447917, 447935, 447952, 456738, 462462, 464135, 465467, 471464, 476799, 480204, 485355, 486864, 486868, 490098, 496094, 497920, 502222, 503274, 505420, 505885, 506065, 507310, 508243, 508820, 509174, 510873, 513204, 515592, 515593, 516543, 516622, 524620, 526721, 538608, 541418, 544788, 555968, 555970, 556000, 571128, 575841, 585550, 586189, 589129, 589968, 590288, 592770, 600781, 605066, 617428, 624150, 624201, 639253, 675060, 675066, 675081, 675092, 675109, 675123, 675126, 675144, 675430, 675675, 675723, 703833, 704218, 704525, 709524, 724354, 728375, 730688, 791914, 825299);

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

[
  "milf heels"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf heels';

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

[
  "milf heels"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf heels';