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

[
  "stunning 18"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'stunning 18' 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
  566653
  617076
  407687
  429305
  495025
  414427
  427314
  465194
  674340
  692074
  581607
  807277
  758224
  632749
  400167
  444296
  580237
  482530
  503213
  563150
  576716
  801965
  500431
  518217
  562128
  405016
  456942
  406558
  492575
  506561
  529268
  469611
  559191
  605936
  810685
  419137
  457059
  513250
  508555
  490694
  405542
  479866
  420878
  516449
  404779
  821605
  446148
  426152
  419509
  464706
  434728
  445026
  452681
  453364
  521375
  521425
  558119
  517784
  593114
  506143
  676090
  581720
  516291
  655647
  586429
  649080
  561410
  511920
  598142
  560114
  675012
  415419
  616024
]

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 (566653, 617076, 407687, 429305, 495025, 414427, 427314, 465194, 674340, 692074, 581607, 807277, 758224, 632749, 400167, 444296, 580237, 482530, 503213, 563150, 576716, 801965, 500431, 518217, 562128, 405016, 456942, 406558, 492575, 506561, 529268, 469611, 559191, 605936, 810685, 419137, 457059, 513250, 508555, 490694, 405542, 479866, 420878, 516449, 404779, 821605, 446148, 426152, 419509, 464706, 434728, 445026, 452681, 453364, 521375, 521425, 558119, 517784, 593114, 506143, 676090, 581720, 516291, 655647, 586429, 649080, 561410, 511920, 598142, 560114, 675012, 415419, 616024);

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
  400167
  404779
  405016
  405542
  406558
  407687
  414427
  415419
  419137
  419509
  420878
  426152
  427314
  429305
  434728
  444296
  445026
  446148
  452681
  453364
  456942
  457059
  464706
  465194
  469611
  479866
  482530
  490694
  492575
  495025
  500431
  503213
  506143
  506561
  508555
  511920
  513250
  516291
  516449
  517784
  518217
  521375
  521425
  529268
  558119
  559191
  560114
  561410
  562128
  563150
  566653
  576716
  580237
  581607
  581720
  586429
  593114
  598142
  605936
  616024
  617076
  632749
  649080
  655647
  674340
  675012
  676090
  692074
  758224
  801965
  807277
  810685
  821605
]

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 (400167, 404779, 405016, 405542, 406558, 407687, 414427, 415419, 419137, 419509, 420878, 426152, 427314, 429305, 434728, 444296, 445026, 446148, 452681, 453364, 456942, 457059, 464706, 465194, 469611, 479866, 482530, 490694, 492575, 495025, 500431, 503213, 506143, 506561, 508555, 511920, 513250, 516291, 516449, 517784, 518217, 521375, 521425, 529268, 558119, 559191, 560114, 561410, 562128, 563150, 566653, 576716, 580237, 581607, 581720, 586429, 593114, 598142, 605936, 616024, 617076, 632749, 649080, 655647, 674340, 675012, 676090, 692074, 758224, 801965, 807277, 810685, 821605);

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
  400167
  404779
  405016
  405542
  406558
  407687
  414427
  415419
  419137
  419509
  420878
  426152
  427314
  429305
  434728
  444296
  445026
  446148
  452681
  453364
  456942
  457059
  464706
  465194
  469611
  479866
  482530
  490694
  492575
  495025
  500431
  503213
  506143
  506561
  508555
  511920
  513250
  516291
  516449
  517784
  518217
  521375
  521425
  529268
  558119
  559191
  560114
  561410
  562128
  563150
  566653
  576716
  580237
  581607
  581720
  586429
  593114
  598142
  605936
  616024
  617076
  632749
  649080
  655647
  674340
  675012
  676090
  692074
  758224
  801965
  807277
  810685
  821605
]

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 (400167, 404779, 405016, 405542, 406558, 407687, 414427, 415419, 419137, 419509, 420878, 426152, 427314, 429305, 434728, 444296, 445026, 446148, 452681, 453364, 456942, 457059, 464706, 465194, 469611, 479866, 482530, 490694, 492575, 495025, 500431, 503213, 506143, 506561, 508555, 511920, 513250, 516291, 516449, 517784, 518217, 521375, 521425, 529268, 558119, 559191, 560114, 561410, 562128, 563150, 566653, 576716, 580237, 581607, 581720, 586429, 593114, 598142, 605936, 616024, 617076, 632749, 649080, 655647, 674340, 675012, 676090, 692074, 758224, 801965, 807277, 810685, 821605);

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

[
  "stunning 18"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'stunning 18';

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

[
  "stunning 18"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'stunning 18';

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 ?

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