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

[
  "anal lovers 2007"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal lovers 2007' 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
  753485
  6853
  752610
  645248
  775453
  735866
  741289
  614261
  727877
  773642
  798729
  720796
  709588
  811669
  558027
  519486
  575774
  740248
  463868
  721566
  770274
  711905
  753476
  750316
  773665
  766807
  558028
  463885
  501757
  677014
  805502
  463179
  443170
  502424
  502440
  604968
  575156
  708468
  570724
  407266
  407296
  501730
  525956
  435916
  501723
  501754
  502118
  501755
  523100
  666879
  575076
  502390
  502420
  574511
  532876
  575212
  586605
  501718
  788566
  463962
  502115
  494148
  464181
  575814
  502071
  569179
  644324
  482510
  492598
  502422
  565186
  576547
]

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 (753485, 6853, 752610, 645248, 775453, 735866, 741289, 614261, 727877, 773642, 798729, 720796, 709588, 811669, 558027, 519486, 575774, 740248, 463868, 721566, 770274, 711905, 753476, 750316, 773665, 766807, 558028, 463885, 501757, 677014, 805502, 463179, 443170, 502424, 502440, 604968, 575156, 708468, 570724, 407266, 407296, 501730, 525956, 435916, 501723, 501754, 502118, 501755, 523100, 666879, 575076, 502390, 502420, 574511, 532876, 575212, 586605, 501718, 788566, 463962, 502115, 494148, 464181, 575814, 502071, 569179, 644324, 482510, 492598, 502422, 565186, 576547);

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
  6853
  407266
  407296
  435916
  443170
  463179
  463868
  463885
  463962
  464181
  482510
  492598
  494148
  501718
  501723
  501730
  501754
  501755
  501757
  502071
  502115
  502118
  502390
  502420
  502422
  502424
  502440
  519486
  523100
  525956
  532876
  558027
  558028
  565186
  569179
  570724
  574511
  575076
  575156
  575212
  575774
  575814
  576547
  586605
  604968
  614261
  644324
  645248
  666879
  677014
  708468
  709588
  711905
  720796
  721566
  727877
  735866
  740248
  741289
  750316
  752610
  753476
  753485
  766807
  770274
  773642
  773665
  775453
  788566
  798729
  805502
  811669
]

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 (6853, 407266, 407296, 435916, 443170, 463179, 463868, 463885, 463962, 464181, 482510, 492598, 494148, 501718, 501723, 501730, 501754, 501755, 501757, 502071, 502115, 502118, 502390, 502420, 502422, 502424, 502440, 519486, 523100, 525956, 532876, 558027, 558028, 565186, 569179, 570724, 574511, 575076, 575156, 575212, 575774, 575814, 576547, 586605, 604968, 614261, 644324, 645248, 666879, 677014, 708468, 709588, 711905, 720796, 721566, 727877, 735866, 740248, 741289, 750316, 752610, 753476, 753485, 766807, 770274, 773642, 773665, 775453, 788566, 798729, 805502, 811669);

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
  6853
  407266
  407296
  435916
  443170
  463179
  463868
  463885
  463962
  464181
  482510
  492598
  494148
  501718
  501723
  501730
  501754
  501755
  501757
  502071
  502115
  502118
  502390
  502420
  502422
  502424
  502440
  519486
  523100
  525956
  532876
  558027
  558028
  565186
  569179
  570724
  574511
  575076
  575156
  575212
  575774
  575814
  576547
  586605
  604968
  614261
  644324
  645248
  666879
  677014
  708468
  709588
  711905
  720796
  721566
  727877
  735866
  740248
  741289
  750316
  752610
  753476
  753485
  766807
  770274
  773642
  773665
  775453
  788566
  798729
  805502
  811669
]

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 (6853, 407266, 407296, 435916, 443170, 463179, 463868, 463885, 463962, 464181, 482510, 492598, 494148, 501718, 501723, 501730, 501754, 501755, 501757, 502071, 502115, 502118, 502390, 502420, 502422, 502424, 502440, 519486, 523100, 525956, 532876, 558027, 558028, 565186, 569179, 570724, 574511, 575076, 575156, 575212, 575774, 575814, 576547, 586605, 604968, 614261, 644324, 645248, 666879, 677014, 708468, 709588, 711905, 720796, 721566, 727877, 735866, 740248, 741289, 750316, 752610, 753476, 753485, 766807, 770274, 773642, 773665, 775453, 788566, 798729, 805502, 811669);

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

[
  "анал lovers"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал lovers';

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

[
  "анал lovers"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал lovers';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "anal lovers 2007"
  "anal lovers 2007"
  "anal lovers 2007"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('anal lovers 2007') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('anal lovers 2007')
              AND `query` <> 'anal lovers 2007'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;