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

[
  "female amateur sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'female amateur sex' 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
  592974
  557605
  557608
  542535
  520936
  501704
  497202
  469824
  547527
  557707
  560289
  503511
  503124
  452367
  510907
  552372
  560301
  441572
  618066
  462071
  464721
  451304
  460514
  520040
  624142
  586601
  500974
  604059
  435374
  490753
  497236
  526619
  558566
  557028
  481131
  585711
  537350
  496809
  743610
  593069
  525439
  571257
  498469
  526594
  489615
  507647
  492466
  520930
  541540
  619385
  588656
  424332
  499182
  455351
  479893
  525736
  487342
  555968
  517493
  562973
  557205
  566288
  470903
  579417
  515726
  510571
  453906
  515994
  567051
  508912
  511013
  492169
  616779
  513001
]

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 (592974, 557605, 557608, 542535, 520936, 501704, 497202, 469824, 547527, 557707, 560289, 503511, 503124, 452367, 510907, 552372, 560301, 441572, 618066, 462071, 464721, 451304, 460514, 520040, 624142, 586601, 500974, 604059, 435374, 490753, 497236, 526619, 558566, 557028, 481131, 585711, 537350, 496809, 743610, 593069, 525439, 571257, 498469, 526594, 489615, 507647, 492466, 520930, 541540, 619385, 588656, 424332, 499182, 455351, 479893, 525736, 487342, 555968, 517493, 562973, 557205, 566288, 470903, 579417, 515726, 510571, 453906, 515994, 567051, 508912, 511013, 492169, 616779, 513001);

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
  424332
  435374
  441572
  451304
  452367
  453906
  455351
  460514
  462071
  464721
  469824
  470903
  479893
  481131
  487342
  489615
  490753
  492169
  492466
  496809
  497202
  497236
  498469
  499182
  500974
  501704
  503124
  503511
  507647
  508912
  510571
  510907
  511013
  513001
  515726
  515994
  517493
  520040
  520930
  520936
  525439
  525736
  526594
  526619
  537350
  541540
  542535
  547527
  552372
  555968
  557028
  557205
  557605
  557608
  557707
  558566
  560289
  560301
  562973
  566288
  567051
  571257
  579417
  585711
  586601
  588656
  592974
  593069
  604059
  616779
  618066
  619385
  624142
  743610
]

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 (424332, 435374, 441572, 451304, 452367, 453906, 455351, 460514, 462071, 464721, 469824, 470903, 479893, 481131, 487342, 489615, 490753, 492169, 492466, 496809, 497202, 497236, 498469, 499182, 500974, 501704, 503124, 503511, 507647, 508912, 510571, 510907, 511013, 513001, 515726, 515994, 517493, 520040, 520930, 520936, 525439, 525736, 526594, 526619, 537350, 541540, 542535, 547527, 552372, 555968, 557028, 557205, 557605, 557608, 557707, 558566, 560289, 560301, 562973, 566288, 567051, 571257, 579417, 585711, 586601, 588656, 592974, 593069, 604059, 616779, 618066, 619385, 624142, 743610);

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
  424332
  435374
  441572
  451304
  452367
  453906
  455351
  460514
  462071
  464721
  469824
  470903
  479893
  481131
  487342
  489615
  490753
  492169
  492466
  496809
  497202
  497236
  498469
  499182
  500974
  501704
  503124
  503511
  507647
  508912
  510571
  510907
  511013
  513001
  515726
  515994
  517493
  520040
  520930
  520936
  525439
  525736
  526594
  526619
  537350
  541540
  542535
  547527
  552372
  555968
  557028
  557205
  557605
  557608
  557707
  558566
  560289
  560301
  562973
  566288
  567051
  571257
  579417
  585711
  586601
  588656
  592974
  593069
  604059
  616779
  618066
  619385
  624142
  743610
]

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 (424332, 435374, 441572, 451304, 452367, 453906, 455351, 460514, 462071, 464721, 469824, 470903, 479893, 481131, 487342, 489615, 490753, 492169, 492466, 496809, 497202, 497236, 498469, 499182, 500974, 501704, 503124, 503511, 507647, 508912, 510571, 510907, 511013, 513001, 515726, 515994, 517493, 520040, 520930, 520936, 525439, 525736, 526594, 526619, 537350, 541540, 542535, 547527, 552372, 555968, 557028, 557205, 557605, 557608, 557707, 558566, 560289, 560301, 562973, 566288, 567051, 571257, 579417, 585711, 586601, 588656, 592974, 593069, 604059, 616779, 618066, 619385, 624142, 743610);

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

[
  "female любительск секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'female любительск секс';

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

[
  "female любительск секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'female любительск секс';