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 star"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf star' 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
  454106
  402618
  585049
  448598
  484540
  566318
  586130
  613671
  803476
  810988
  774575
  33727
  814752
  814404
  448973
  474149
  489202
  504591
  587202
  593248
  790895
  719016
  798517
  455380
  501308
  506185
  415573
  400934
  415559
  415581
  820902
  454778
  494086
  517180
  482683
  563619
  693194
  691201
  592481
  595986
  801296
  443594
  478760
  475273
  503577
  466372
  384243
  384769
  415567
  415582
  815427
  459191
  492554
  472244
  534999
  549729
  646185
  559607
  802826
  415577
  415575
  80332
  411307
  453178
  487747
  600237
  586002
  595808
  459189
  483162
  430546
  646451
  649106
  430979
  567140
  474662
  540476
  626136
  524165
  506500
  519345
]

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 (454106, 402618, 585049, 448598, 484540, 566318, 586130, 613671, 803476, 810988, 774575, 33727, 814752, 814404, 448973, 474149, 489202, 504591, 587202, 593248, 790895, 719016, 798517, 455380, 501308, 506185, 415573, 400934, 415559, 415581, 820902, 454778, 494086, 517180, 482683, 563619, 693194, 691201, 592481, 595986, 801296, 443594, 478760, 475273, 503577, 466372, 384243, 384769, 415567, 415582, 815427, 459191, 492554, 472244, 534999, 549729, 646185, 559607, 802826, 415577, 415575, 80332, 411307, 453178, 487747, 600237, 586002, 595808, 459189, 483162, 430546, 646451, 649106, 430979, 567140, 474662, 540476, 626136, 524165, 506500, 519345);

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
  33727
  80332
  384243
  384769
  400934
  402618
  411307
  415559
  415567
  415573
  415575
  415577
  415581
  415582
  430546
  430979
  443594
  448598
  448973
  453178
  454106
  454778
  455380
  459189
  459191
  466372
  472244
  474149
  474662
  475273
  478760
  482683
  483162
  484540
  487747
  489202
  492554
  494086
  501308
  503577
  504591
  506185
  506500
  517180
  519345
  524165
  534999
  540476
  549729
  559607
  563619
  566318
  567140
  585049
  586002
  586130
  587202
  592481
  593248
  595808
  595986
  600237
  613671
  626136
  646185
  646451
  649106
  691201
  693194
  719016
  774575
  790895
  798517
  801296
  802826
  803476
  810988
  814404
  814752
  815427
  820902
]

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 (33727, 80332, 384243, 384769, 400934, 402618, 411307, 415559, 415567, 415573, 415575, 415577, 415581, 415582, 430546, 430979, 443594, 448598, 448973, 453178, 454106, 454778, 455380, 459189, 459191, 466372, 472244, 474149, 474662, 475273, 478760, 482683, 483162, 484540, 487747, 489202, 492554, 494086, 501308, 503577, 504591, 506185, 506500, 517180, 519345, 524165, 534999, 540476, 549729, 559607, 563619, 566318, 567140, 585049, 586002, 586130, 587202, 592481, 593248, 595808, 595986, 600237, 613671, 626136, 646185, 646451, 649106, 691201, 693194, 719016, 774575, 790895, 798517, 801296, 802826, 803476, 810988, 814404, 814752, 815427, 820902);

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
  33727
  80332
  384243
  384769
  400934
  402618
  411307
  415559
  415567
  415573
  415575
  415577
  415581
  415582
  430546
  430979
  443594
  448598
  448973
  453178
  454106
  454778
  455380
  459189
  459191
  466372
  472244
  474149
  474662
  475273
  478760
  482683
  483162
  484540
  487747
  489202
  492554
  494086
  501308
  503577
  504591
  506185
  506500
  517180
  519345
  524165
  534999
  540476
  549729
  559607
  563619
  566318
  567140
  585049
  586002
  586130
  587202
  592481
  593248
  595808
  595986
  600237
  613671
  626136
  646185
  646451
  649106
  691201
  693194
  719016
  774575
  790895
  798517
  801296
  802826
  803476
  810988
  814404
  814752
  815427
  820902
]

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 (33727, 80332, 384243, 384769, 400934, 402618, 411307, 415559, 415567, 415573, 415575, 415577, 415581, 415582, 430546, 430979, 443594, 448598, 448973, 453178, 454106, 454778, 455380, 459189, 459191, 466372, 472244, 474149, 474662, 475273, 478760, 482683, 483162, 484540, 487747, 489202, 492554, 494086, 501308, 503577, 504591, 506185, 506500, 517180, 519345, 524165, 534999, 540476, 549729, 559607, 563619, 566318, 567140, 585049, 586002, 586130, 587202, 592481, 593248, 595808, 595986, 600237, 613671, 626136, 646185, 646451, 649106, 691201, 693194, 719016, 774575, 790895, 798517, 801296, 802826, 803476, 810988, 814404, 814752, 815427, 820902);

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

[
  "milf star"
]

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

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

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

[
  "milf star"
]

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

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