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

[
  "painful big cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'painful big cock' 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
  530582
  688664
  681091
  542218
  621352
  507733
  414357
  655087
  653267
  688390
  598464
  610661
  597501
  481910
  467508
  484581
  547620
  485100
  406075
  548594
  553108
  583994
  609292
  473772
  617006
  663930
  427981
  518521
  516904
  654552
  655615
  584712
  604289
  620295
  601906
  484372
  511837
  576723
  601125
  689013
  516682
  520008
  521989
  496367
  580334
  554798
  651938
  652907
  582631
  593343
  598524
  599404
  619965
  601976
  549860
  540141
  599512
  521306
  520697
  528353
  611900
  657438
  601314
  607129
  634230
  622778
  617212
  541804
  649185
  610695
  565186
  560511
]

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 (530582, 688664, 681091, 542218, 621352, 507733, 414357, 655087, 653267, 688390, 598464, 610661, 597501, 481910, 467508, 484581, 547620, 485100, 406075, 548594, 553108, 583994, 609292, 473772, 617006, 663930, 427981, 518521, 516904, 654552, 655615, 584712, 604289, 620295, 601906, 484372, 511837, 576723, 601125, 689013, 516682, 520008, 521989, 496367, 580334, 554798, 651938, 652907, 582631, 593343, 598524, 599404, 619965, 601976, 549860, 540141, 599512, 521306, 520697, 528353, 611900, 657438, 601314, 607129, 634230, 622778, 617212, 541804, 649185, 610695, 565186, 560511);

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
  406075
  414357
  427981
  467508
  473772
  481910
  484372
  484581
  485100
  496367
  507733
  511837
  516682
  516904
  518521
  520008
  520697
  521306
  521989
  528353
  530582
  540141
  541804
  542218
  547620
  548594
  549860
  553108
  554798
  560511
  565186
  576723
  580334
  582631
  583994
  584712
  593343
  597501
  598464
  598524
  599404
  599512
  601125
  601314
  601906
  601976
  604289
  607129
  609292
  610661
  610695
  611900
  617006
  617212
  619965
  620295
  621352
  622778
  634230
  649185
  651938
  652907
  653267
  654552
  655087
  655615
  657438
  663930
  681091
  688390
  688664
  689013
]

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 (406075, 414357, 427981, 467508, 473772, 481910, 484372, 484581, 485100, 496367, 507733, 511837, 516682, 516904, 518521, 520008, 520697, 521306, 521989, 528353, 530582, 540141, 541804, 542218, 547620, 548594, 549860, 553108, 554798, 560511, 565186, 576723, 580334, 582631, 583994, 584712, 593343, 597501, 598464, 598524, 599404, 599512, 601125, 601314, 601906, 601976, 604289, 607129, 609292, 610661, 610695, 611900, 617006, 617212, 619965, 620295, 621352, 622778, 634230, 649185, 651938, 652907, 653267, 654552, 655087, 655615, 657438, 663930, 681091, 688390, 688664, 689013);

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
  406075
  414357
  427981
  467508
  473772
  481910
  484372
  484581
  485100
  496367
  507733
  511837
  516682
  516904
  518521
  520008
  520697
  521306
  521989
  528353
  530582
  540141
  541804
  542218
  547620
  548594
  549860
  553108
  554798
  560511
  565186
  576723
  580334
  582631
  583994
  584712
  593343
  597501
  598464
  598524
  599404
  599512
  601125
  601314
  601906
  601976
  604289
  607129
  609292
  610661
  610695
  611900
  617006
  617212
  619965
  620295
  621352
  622778
  634230
  649185
  651938
  652907
  653267
  654552
  655087
  655615
  657438
  663930
  681091
  688390
  688664
  689013
]

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 (406075, 414357, 427981, 467508, 473772, 481910, 484372, 484581, 485100, 496367, 507733, 511837, 516682, 516904, 518521, 520008, 520697, 521306, 521989, 528353, 530582, 540141, 541804, 542218, 547620, 548594, 549860, 553108, 554798, 560511, 565186, 576723, 580334, 582631, 583994, 584712, 593343, 597501, 598464, 598524, 599404, 599512, 601125, 601314, 601906, 601976, 604289, 607129, 609292, 610661, 610695, 611900, 617006, 617212, 619965, 620295, 621352, 622778, 634230, 649185, 651938, 652907, 653267, 654552, 655087, 655615, 657438, 663930, 681091, 688390, 688664, 689013);

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

[
  "крича вперв большие cock"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'крича вперв большие cock';

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

[
  "крича вперв большие cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'крича вперв большие cock';

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 ?

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