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

[
  "hairy casting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy casting' 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
  642063
  599844
  639824
  586573
  636295
  727812
  614858
  473733
  445737
  512891
  533645
  429200
  741531
  489424
  511313
  531117
  494694
  526553
  528723
  647854
  646176
  556797
  622398
  639796
  589060
  639760
  643103
  617422
  636308
  475828
  419627
  492733
  528378
  509802
  508518
  532661
  551763
  580766
  647948
  591882
  614737
  622938
  639739
  642016
  518996
  554428
  596234
  456095
  580657
  443998
  474964
  524191
  789494
  510581
  508523
  573393
  647860
  603493
  641978
  589041
  621125
  518633
  444916
  423633
  409995
  494786
  524886
  635275
  484433
  433497
  516744
  553070
  522382
]

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 (642063, 599844, 639824, 586573, 636295, 727812, 614858, 473733, 445737, 512891, 533645, 429200, 741531, 489424, 511313, 531117, 494694, 526553, 528723, 647854, 646176, 556797, 622398, 639796, 589060, 639760, 643103, 617422, 636308, 475828, 419627, 492733, 528378, 509802, 508518, 532661, 551763, 580766, 647948, 591882, 614737, 622938, 639739, 642016, 518996, 554428, 596234, 456095, 580657, 443998, 474964, 524191, 789494, 510581, 508523, 573393, 647860, 603493, 641978, 589041, 621125, 518633, 444916, 423633, 409995, 494786, 524886, 635275, 484433, 433497, 516744, 553070, 522382);

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
  409995
  419627
  423633
  429200
  433497
  443998
  444916
  445737
  456095
  473733
  474964
  475828
  484433
  489424
  492733
  494694
  494786
  508518
  508523
  509802
  510581
  511313
  512891
  516744
  518633
  518996
  522382
  524191
  524886
  526553
  528378
  528723
  531117
  532661
  533645
  551763
  553070
  554428
  556797
  573393
  580657
  580766
  586573
  589041
  589060
  591882
  596234
  599844
  603493
  614737
  614858
  617422
  621125
  622398
  622938
  635275
  636295
  636308
  639739
  639760
  639796
  639824
  641978
  642016
  642063
  643103
  646176
  647854
  647860
  647948
  727812
  741531
  789494
]

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 (409995, 419627, 423633, 429200, 433497, 443998, 444916, 445737, 456095, 473733, 474964, 475828, 484433, 489424, 492733, 494694, 494786, 508518, 508523, 509802, 510581, 511313, 512891, 516744, 518633, 518996, 522382, 524191, 524886, 526553, 528378, 528723, 531117, 532661, 533645, 551763, 553070, 554428, 556797, 573393, 580657, 580766, 586573, 589041, 589060, 591882, 596234, 599844, 603493, 614737, 614858, 617422, 621125, 622398, 622938, 635275, 636295, 636308, 639739, 639760, 639796, 639824, 641978, 642016, 642063, 643103, 646176, 647854, 647860, 647948, 727812, 741531, 789494);

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
  409995
  419627
  423633
  429200
  433497
  443998
  444916
  445737
  456095
  473733
  474964
  475828
  484433
  489424
  492733
  494694
  494786
  508518
  508523
  509802
  510581
  511313
  512891
  516744
  518633
  518996
  522382
  524191
  524886
  526553
  528378
  528723
  531117
  532661
  533645
  551763
  553070
  554428
  556797
  573393
  580657
  580766
  586573
  589041
  589060
  591882
  596234
  599844
  603493
  614737
  614858
  617422
  621125
  622398
  622938
  635275
  636295
  636308
  639739
  639760
  639796
  639824
  641978
  642016
  642063
  643103
  646176
  647854
  647860
  647948
  727812
  741531
  789494
]

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 (409995, 419627, 423633, 429200, 433497, 443998, 444916, 445737, 456095, 473733, 474964, 475828, 484433, 489424, 492733, 494694, 494786, 508518, 508523, 509802, 510581, 511313, 512891, 516744, 518633, 518996, 522382, 524191, 524886, 526553, 528378, 528723, 531117, 532661, 533645, 551763, 553070, 554428, 556797, 573393, 580657, 580766, 586573, 589041, 589060, 591882, 596234, 599844, 603493, 614737, 614858, 617422, 621125, 622398, 622938, 635275, 636295, 636308, 639739, 639760, 639796, 639824, 641978, 642016, 642063, 643103, 646176, 647854, 647860, 647948, 727812, 741531, 789494);

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` = 'волосатая кастинг';

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 ?

[
  "hairy casting"
  "hairy casting"
  "hairy casting"
  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 ('hairy casting') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('hairy casting')
              AND `query` <> 'hairy casting'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;