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

[
  "pickup hairy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pickup hairy' 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
  456369
  474859
  476262
  478774
  528946
  520250
  533182
  502180
  510047
  477899
  492519
  560168
  605563
  623822
  503248
  529079
  487054
  489187
  486606
  572121
  382761
  32874
  398555
  413499
  471890
  469357
  473218
  485733
  512799
  522939
  525104
  523712
  505005
  471810
  472935
  543480
  560155
  562843
  549234
  594920
  598893
  590194
  420068
  454179
  471548
  528406
  527568
  486516
  491673
  518309
  520909
  475781
  462785
  512071
  524900
  528395
  482367
  541373
  543195
  558286
  689634
  649833
  465198
  471831
  524982
  383590
  485759
  445634
  477200
  582790
  586504
  515749
  525701
  464598
  454954
  472931
  466382
  422853
  472840
  401927
]

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 (456369, 474859, 476262, 478774, 528946, 520250, 533182, 502180, 510047, 477899, 492519, 560168, 605563, 623822, 503248, 529079, 487054, 489187, 486606, 572121, 382761, 32874, 398555, 413499, 471890, 469357, 473218, 485733, 512799, 522939, 525104, 523712, 505005, 471810, 472935, 543480, 560155, 562843, 549234, 594920, 598893, 590194, 420068, 454179, 471548, 528406, 527568, 486516, 491673, 518309, 520909, 475781, 462785, 512071, 524900, 528395, 482367, 541373, 543195, 558286, 689634, 649833, 465198, 471831, 524982, 383590, 485759, 445634, 477200, 582790, 586504, 515749, 525701, 464598, 454954, 472931, 466382, 422853, 472840, 401927);

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
  32874
  382761
  383590
  398555
  401927
  413499
  420068
  422853
  445634
  454179
  454954
  456369
  462785
  464598
  465198
  466382
  469357
  471548
  471810
  471831
  471890
  472840
  472931
  472935
  473218
  474859
  475781
  476262
  477200
  477899
  478774
  482367
  485733
  485759
  486516
  486606
  487054
  489187
  491673
  492519
  502180
  503248
  505005
  510047
  512071
  512799
  515749
  518309
  520250
  520909
  522939
  523712
  524900
  524982
  525104
  525701
  527568
  528395
  528406
  528946
  529079
  533182
  541373
  543195
  543480
  549234
  558286
  560155
  560168
  562843
  572121
  582790
  586504
  590194
  594920
  598893
  605563
  623822
  649833
  689634
]

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 (32874, 382761, 383590, 398555, 401927, 413499, 420068, 422853, 445634, 454179, 454954, 456369, 462785, 464598, 465198, 466382, 469357, 471548, 471810, 471831, 471890, 472840, 472931, 472935, 473218, 474859, 475781, 476262, 477200, 477899, 478774, 482367, 485733, 485759, 486516, 486606, 487054, 489187, 491673, 492519, 502180, 503248, 505005, 510047, 512071, 512799, 515749, 518309, 520250, 520909, 522939, 523712, 524900, 524982, 525104, 525701, 527568, 528395, 528406, 528946, 529079, 533182, 541373, 543195, 543480, 549234, 558286, 560155, 560168, 562843, 572121, 582790, 586504, 590194, 594920, 598893, 605563, 623822, 649833, 689634);

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
  32874
  382761
  383590
  398555
  401927
  413499
  420068
  422853
  445634
  454179
  454954
  456369
  462785
  464598
  465198
  466382
  469357
  471548
  471810
  471831
  471890
  472840
  472931
  472935
  473218
  474859
  475781
  476262
  477200
  477899
  478774
  482367
  485733
  485759
  486516
  486606
  487054
  489187
  491673
  492519
  502180
  503248
  505005
  510047
  512071
  512799
  515749
  518309
  520250
  520909
  522939
  523712
  524900
  524982
  525104
  525701
  527568
  528395
  528406
  528946
  529079
  533182
  541373
  543195
  543480
  549234
  558286
  560155
  560168
  562843
  572121
  582790
  586504
  590194
  594920
  598893
  605563
  623822
  649833
  689634
]

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 (32874, 382761, 383590, 398555, 401927, 413499, 420068, 422853, 445634, 454179, 454954, 456369, 462785, 464598, 465198, 466382, 469357, 471548, 471810, 471831, 471890, 472840, 472931, 472935, 473218, 474859, 475781, 476262, 477200, 477899, 478774, 482367, 485733, 485759, 486516, 486606, 487054, 489187, 491673, 492519, 502180, 503248, 505005, 510047, 512071, 512799, 515749, 518309, 520250, 520909, 522939, 523712, 524900, 524982, 525104, 525701, 527568, 528395, 528406, 528946, 529079, 533182, 541373, 543195, 543480, 549234, 558286, 560155, 560168, 562843, 572121, 582790, 586504, 590194, 594920, 598893, 605563, 623822, 649833, 689634);

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

[
  "пикап волосатая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'пикап волосатая';

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

[
  "пикап волосатая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'пикап волосатая';