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 face"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf face' 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
  488391
  534670
  487583
  516852
  520709
  526886
  455922
  411227
  486217
  501259
  519851
  542533
  567066
  598190
  624003
  633312
  413084
  453522
  400508
  439578
  439606
  460744
  418879
  439625
  440581
  477454
  500803
  514693
  511308
  527742
  507682
  522690
  625437
  498056
  537247
  525378
  526805
  531407
  507376
  508425
  526891
  474706
  564647
  584013
  605762
  617633
  626885
  427182
  470100
  516025
  814903
  533950
  516711
  567757
  696499
  586554
  470074
  599967
  505132
  516714
  569929
  598158
  439534
  662020
  582277
  620001
  639258
  601485
  507872
  620232
  613318
  616779
  534376
  457676
]

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 (488391, 534670, 487583, 516852, 520709, 526886, 455922, 411227, 486217, 501259, 519851, 542533, 567066, 598190, 624003, 633312, 413084, 453522, 400508, 439578, 439606, 460744, 418879, 439625, 440581, 477454, 500803, 514693, 511308, 527742, 507682, 522690, 625437, 498056, 537247, 525378, 526805, 531407, 507376, 508425, 526891, 474706, 564647, 584013, 605762, 617633, 626885, 427182, 470100, 516025, 814903, 533950, 516711, 567757, 696499, 586554, 470074, 599967, 505132, 516714, 569929, 598158, 439534, 662020, 582277, 620001, 639258, 601485, 507872, 620232, 613318, 616779, 534376, 457676);

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
  400508
  411227
  413084
  418879
  427182
  439534
  439578
  439606
  439625
  440581
  453522
  455922
  457676
  460744
  470074
  470100
  474706
  477454
  486217
  487583
  488391
  498056
  500803
  501259
  505132
  507376
  507682
  507872
  508425
  511308
  514693
  516025
  516711
  516714
  516852
  519851
  520709
  522690
  525378
  526805
  526886
  526891
  527742
  531407
  533950
  534376
  534670
  537247
  542533
  564647
  567066
  567757
  569929
  582277
  584013
  586554
  598158
  598190
  599967
  601485
  605762
  613318
  616779
  617633
  620001
  620232
  624003
  625437
  626885
  633312
  639258
  662020
  696499
  814903
]

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 (400508, 411227, 413084, 418879, 427182, 439534, 439578, 439606, 439625, 440581, 453522, 455922, 457676, 460744, 470074, 470100, 474706, 477454, 486217, 487583, 488391, 498056, 500803, 501259, 505132, 507376, 507682, 507872, 508425, 511308, 514693, 516025, 516711, 516714, 516852, 519851, 520709, 522690, 525378, 526805, 526886, 526891, 527742, 531407, 533950, 534376, 534670, 537247, 542533, 564647, 567066, 567757, 569929, 582277, 584013, 586554, 598158, 598190, 599967, 601485, 605762, 613318, 616779, 617633, 620001, 620232, 624003, 625437, 626885, 633312, 639258, 662020, 696499, 814903);

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
  400508
  411227
  413084
  418879
  427182
  439534
  439578
  439606
  439625
  440581
  453522
  455922
  457676
  460744
  470074
  470100
  474706
  477454
  486217
  487583
  488391
  498056
  500803
  501259
  505132
  507376
  507682
  507872
  508425
  511308
  514693
  516025
  516711
  516714
  516852
  519851
  520709
  522690
  525378
  526805
  526886
  526891
  527742
  531407
  533950
  534376
  534670
  537247
  542533
  564647
  567066
  567757
  569929
  582277
  584013
  586554
  598158
  598190
  599967
  601485
  605762
  613318
  616779
  617633
  620001
  620232
  624003
  625437
  626885
  633312
  639258
  662020
  696499
  814903
]

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 (400508, 411227, 413084, 418879, 427182, 439534, 439578, 439606, 439625, 440581, 453522, 455922, 457676, 460744, 470074, 470100, 474706, 477454, 486217, 487583, 488391, 498056, 500803, 501259, 505132, 507376, 507682, 507872, 508425, 511308, 514693, 516025, 516711, 516714, 516852, 519851, 520709, 522690, 525378, 526805, 526886, 526891, 527742, 531407, 533950, 534376, 534670, 537247, 542533, 564647, 567066, 567757, 569929, 582277, 584013, 586554, 598158, 598190, 599967, 601485, 605762, 613318, 616779, 617633, 620001, 620232, 624003, 625437, 626885, 633312, 639258, 662020, 696499, 814903);

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

[
  "milf face"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'milf face';

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

[
  "milf face"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'milf face';

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