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

[
  "milf kitchen brunette"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf kitchen brunette' 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
  454325
  502133
  506167
  514252
  520695
  523226
  569201
  574023
  580647
  583686
  615757
  415572
  469390
  421954
  439674
  473207
  439716
  454411
  469879
  439524
  467045
  529180
  490274
  509347
  519945
  538008
  593799
  524896
  451826
  474785
  607525
  631468
  604409
  614580
  426766
  426993
  464025
  472124
  469367
  480702
  514133
  510908
  511776
  511791
  526454
  522690
  389500
  430481
  425347
  463780
  510513
  527062
  534729
  623641
  421854
  439815
  460658
  525881
  590966
  598870
  486569
  473499
  541770
  406089
  619569
  541215
  430827
  523198
  574258
  608073
  434601
  512554
]

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 (454325, 502133, 506167, 514252, 520695, 523226, 569201, 574023, 580647, 583686, 615757, 415572, 469390, 421954, 439674, 473207, 439716, 454411, 469879, 439524, 467045, 529180, 490274, 509347, 519945, 538008, 593799, 524896, 451826, 474785, 607525, 631468, 604409, 614580, 426766, 426993, 464025, 472124, 469367, 480702, 514133, 510908, 511776, 511791, 526454, 522690, 389500, 430481, 425347, 463780, 510513, 527062, 534729, 623641, 421854, 439815, 460658, 525881, 590966, 598870, 486569, 473499, 541770, 406089, 619569, 541215, 430827, 523198, 574258, 608073, 434601, 512554);

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
  389500
  406089
  415572
  421854
  421954
  425347
  426766
  426993
  430481
  430827
  434601
  439524
  439674
  439716
  439815
  451826
  454325
  454411
  460658
  463780
  464025
  467045
  469367
  469390
  469879
  472124
  473207
  473499
  474785
  480702
  486569
  490274
  502133
  506167
  509347
  510513
  510908
  511776
  511791
  512554
  514133
  514252
  519945
  520695
  522690
  523198
  523226
  524896
  525881
  526454
  527062
  529180
  534729
  538008
  541215
  541770
  569201
  574023
  574258
  580647
  583686
  590966
  593799
  598870
  604409
  607525
  608073
  614580
  615757
  619569
  623641
  631468
]

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 (389500, 406089, 415572, 421854, 421954, 425347, 426766, 426993, 430481, 430827, 434601, 439524, 439674, 439716, 439815, 451826, 454325, 454411, 460658, 463780, 464025, 467045, 469367, 469390, 469879, 472124, 473207, 473499, 474785, 480702, 486569, 490274, 502133, 506167, 509347, 510513, 510908, 511776, 511791, 512554, 514133, 514252, 519945, 520695, 522690, 523198, 523226, 524896, 525881, 526454, 527062, 529180, 534729, 538008, 541215, 541770, 569201, 574023, 574258, 580647, 583686, 590966, 593799, 598870, 604409, 607525, 608073, 614580, 615757, 619569, 623641, 631468);

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
  389500
  406089
  415572
  421854
  421954
  425347
  426766
  426993
  430481
  430827
  434601
  439524
  439674
  439716
  439815
  451826
  454325
  454411
  460658
  463780
  464025
  467045
  469367
  469390
  469879
  472124
  473207
  473499
  474785
  480702
  486569
  490274
  502133
  506167
  509347
  510513
  510908
  511776
  511791
  512554
  514133
  514252
  519945
  520695
  522690
  523198
  523226
  524896
  525881
  526454
  527062
  529180
  534729
  538008
  541215
  541770
  569201
  574023
  574258
  580647
  583686
  590966
  593799
  598870
  604409
  607525
  608073
  614580
  615757
  619569
  623641
  631468
]

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 (389500, 406089, 415572, 421854, 421954, 425347, 426766, 426993, 430481, 430827, 434601, 439524, 439674, 439716, 439815, 451826, 454325, 454411, 460658, 463780, 464025, 467045, 469367, 469390, 469879, 472124, 473207, 473499, 474785, 480702, 486569, 490274, 502133, 506167, 509347, 510513, 510908, 511776, 511791, 512554, 514133, 514252, 519945, 520695, 522690, 523198, 523226, 524896, 525881, 526454, 527062, 529180, 534729, 538008, 541215, 541770, 569201, 574023, 574258, 580647, 583686, 590966, 593799, 598870, 604409, 607525, 608073, 614580, 615757, 619569, 623641, 631468);

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

[
  "milf кухн черноволосая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf кухн черноволосая';

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

[
  "milf кухн черноволосая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf кухн черноволосая';

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 ?

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