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

[
  "mature sucks cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature sucks 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
  525200
  487753
  559165
  573911
  542508
  549680
  559546
  561379
  687190
  712534
  559818
  629766
  599491
  604835
  799743
  729627
  408157
  421822
  421869
  451523
  460294
  483450
  486574
  483248
  483411
  514004
  516299
  523128
  453710
  393715
  555968
  580626
  503556
  453718
  453730
  554887
  555127
  555997
  591123
  593870
  597096
  794963
  504102
  492458
  515686
  620215
  454308
  409043
  550972
  557534
  668176
  577437
  597159
  612726
  631170
  445740
  459673
  464175
  510853
  523859
  515396
  96029
  512533
  559162
  591022
  422211
  421573
  514375
  569415
  586616
  662412
  526587
  562790
]

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 (525200, 487753, 559165, 573911, 542508, 549680, 559546, 561379, 687190, 712534, 559818, 629766, 599491, 604835, 799743, 729627, 408157, 421822, 421869, 451523, 460294, 483450, 486574, 483248, 483411, 514004, 516299, 523128, 453710, 393715, 555968, 580626, 503556, 453718, 453730, 554887, 555127, 555997, 591123, 593870, 597096, 794963, 504102, 492458, 515686, 620215, 454308, 409043, 550972, 557534, 668176, 577437, 597159, 612726, 631170, 445740, 459673, 464175, 510853, 523859, 515396, 96029, 512533, 559162, 591022, 422211, 421573, 514375, 569415, 586616, 662412, 526587, 562790);

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
  96029
  393715
  408157
  409043
  421573
  421822
  421869
  422211
  445740
  451523
  453710
  453718
  453730
  454308
  459673
  460294
  464175
  483248
  483411
  483450
  486574
  487753
  492458
  503556
  504102
  510853
  512533
  514004
  514375
  515396
  515686
  516299
  523128
  523859
  525200
  526587
  542508
  549680
  550972
  554887
  555127
  555968
  555997
  557534
  559162
  559165
  559546
  559818
  561379
  562790
  569415
  573911
  577437
  580626
  586616
  591022
  591123
  593870
  597096
  597159
  599491
  604835
  612726
  620215
  629766
  631170
  662412
  668176
  687190
  712534
  729627
  794963
  799743
]

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 (96029, 393715, 408157, 409043, 421573, 421822, 421869, 422211, 445740, 451523, 453710, 453718, 453730, 454308, 459673, 460294, 464175, 483248, 483411, 483450, 486574, 487753, 492458, 503556, 504102, 510853, 512533, 514004, 514375, 515396, 515686, 516299, 523128, 523859, 525200, 526587, 542508, 549680, 550972, 554887, 555127, 555968, 555997, 557534, 559162, 559165, 559546, 559818, 561379, 562790, 569415, 573911, 577437, 580626, 586616, 591022, 591123, 593870, 597096, 597159, 599491, 604835, 612726, 620215, 629766, 631170, 662412, 668176, 687190, 712534, 729627, 794963, 799743);

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
  96029
  393715
  408157
  409043
  421573
  421822
  421869
  422211
  445740
  451523
  453710
  453718
  453730
  454308
  459673
  460294
  464175
  483248
  483411
  483450
  486574
  487753
  492458
  503556
  504102
  510853
  512533
  514004
  514375
  515396
  515686
  516299
  523128
  523859
  525200
  526587
  542508
  549680
  550972
  554887
  555127
  555968
  555997
  557534
  559162
  559165
  559546
  559818
  561379
  562790
  569415
  573911
  577437
  580626
  586616
  591022
  591123
  593870
  597096
  597159
  599491
  604835
  612726
  620215
  629766
  631170
  662412
  668176
  687190
  712534
  729627
  794963
  799743
]

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 (96029, 393715, 408157, 409043, 421573, 421822, 421869, 422211, 445740, 451523, 453710, 453718, 453730, 454308, 459673, 460294, 464175, 483248, 483411, 483450, 486574, 487753, 492458, 503556, 504102, 510853, 512533, 514004, 514375, 515396, 515686, 516299, 523128, 523859, 525200, 526587, 542508, 549680, 550972, 554887, 555127, 555968, 555997, 557534, 559162, 559165, 559546, 559818, 561379, 562790, 569415, 573911, 577437, 580626, 586616, 591022, 591123, 593870, 597096, 597159, 599491, 604835, 612726, 620215, 629766, 631170, 662412, 668176, 687190, 712534, 729627, 794963, 799743);

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

[
  "mature sucks cock"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature sucks cock';

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

[
  "mature sucks cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature sucks 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 ?

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