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

[
  "pussy gaping vagina"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy gaping vagina' 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
  388032
  541422
  444322
  593780
  422324
  446176
  446407
  451358
  666623
  742373
  431485
  790648
  785732
  496146
  598401
  610006
  480680
  463876
  603612
  400802
  566208
  752609
  475318
  65568
  571809
  493754
  788923
  777509
  527922
  586688
  445211
  599538
  392019
  400839
  548153
  707328
  454625
  443260
  450434
  513209
  560905
  517724
  446108
  525468
  501641
  480480
  421220
  447879
  510425
  601604
  786461
  458281
  410573
  432034
  602092
  395970
  433295
  422723
  446874
  453408
  503411
  446501
  421207
  502043
  427959
  475830
  523549
  617437
  524213
  626297
  426551
  642407
]

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 (388032, 541422, 444322, 593780, 422324, 446176, 446407, 451358, 666623, 742373, 431485, 790648, 785732, 496146, 598401, 610006, 480680, 463876, 603612, 400802, 566208, 752609, 475318, 65568, 571809, 493754, 788923, 777509, 527922, 586688, 445211, 599538, 392019, 400839, 548153, 707328, 454625, 443260, 450434, 513209, 560905, 517724, 446108, 525468, 501641, 480480, 421220, 447879, 510425, 601604, 786461, 458281, 410573, 432034, 602092, 395970, 433295, 422723, 446874, 453408, 503411, 446501, 421207, 502043, 427959, 475830, 523549, 617437, 524213, 626297, 426551, 642407);

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
  65568
  388032
  392019
  395970
  400802
  400839
  410573
  421207
  421220
  422324
  422723
  426551
  427959
  431485
  432034
  433295
  443260
  444322
  445211
  446108
  446176
  446407
  446501
  446874
  447879
  450434
  451358
  453408
  454625
  458281
  463876
  475318
  475830
  480480
  480680
  493754
  496146
  501641
  502043
  503411
  510425
  513209
  517724
  523549
  524213
  525468
  527922
  541422
  548153
  560905
  566208
  571809
  586688
  593780
  598401
  599538
  601604
  602092
  603612
  610006
  617437
  626297
  642407
  666623
  707328
  742373
  752609
  777509
  785732
  786461
  788923
  790648
]

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 (65568, 388032, 392019, 395970, 400802, 400839, 410573, 421207, 421220, 422324, 422723, 426551, 427959, 431485, 432034, 433295, 443260, 444322, 445211, 446108, 446176, 446407, 446501, 446874, 447879, 450434, 451358, 453408, 454625, 458281, 463876, 475318, 475830, 480480, 480680, 493754, 496146, 501641, 502043, 503411, 510425, 513209, 517724, 523549, 524213, 525468, 527922, 541422, 548153, 560905, 566208, 571809, 586688, 593780, 598401, 599538, 601604, 602092, 603612, 610006, 617437, 626297, 642407, 666623, 707328, 742373, 752609, 777509, 785732, 786461, 788923, 790648);

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
  65568
  388032
  392019
  395970
  400802
  400839
  410573
  421207
  421220
  422324
  422723
  426551
  427959
  431485
  432034
  433295
  443260
  444322
  445211
  446108
  446176
  446407
  446501
  446874
  447879
  450434
  451358
  453408
  454625
  458281
  463876
  475318
  475830
  480480
  480680
  493754
  496146
  501641
  502043
  503411
  510425
  513209
  517724
  523549
  524213
  525468
  527922
  541422
  548153
  560905
  566208
  571809
  586688
  593780
  598401
  599538
  601604
  602092
  603612
  610006
  617437
  626297
  642407
  666623
  707328
  742373
  752609
  777509
  785732
  786461
  788923
  790648
]

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 (65568, 388032, 392019, 395970, 400802, 400839, 410573, 421207, 421220, 422324, 422723, 426551, 427959, 431485, 432034, 433295, 443260, 444322, 445211, 446108, 446176, 446407, 446501, 446874, 447879, 450434, 451358, 453408, 454625, 458281, 463876, 475318, 475830, 480480, 480680, 493754, 496146, 501641, 502043, 503411, 510425, 513209, 517724, 523549, 524213, 525468, 527922, 541422, 548153, 560905, 566208, 571809, 586688, 593780, 598401, 599538, 601604, 602092, 603612, 610006, 617437, 626297, 642407, 666623, 707328, 742373, 752609, 777509, 785732, 786461, 788923, 790648);

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

[
  "pussy gaping вагин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pussy gaping вагин';

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

[
  "pussy gaping вагин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy gaping вагин';

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 ?

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