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

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'stunning mature' 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
  3826
  409942
  824456
  462022
  586950
  824454
  800724
  381813
  720534
  770116
  213692
  817062
  565625
  815905
  607688
  790958
  740890
  816545
  815165
  469582
  480497
  817878
  670349
  767187
  815798
  716245
  482530
  563150
  407687
  464157
  408196
  814333
  820423
  446630
  596897
  640858
  779744
  799595
  742728
  795163
  478265
  430701
  814753
  530713
  800876
  810980
  451462
  472631
  518218
  386759
  561415
  467914
  481820
  485548
  517784
  405542
  814908
  518223
  536287
  520176
  448806
  406558
  419824
  446148
  536285
  553448
  568177
  522363
  521586
  588624
  527998
  623262
  527990
]

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 (3826, 409942, 824456, 462022, 586950, 824454, 800724, 381813, 720534, 770116, 213692, 817062, 565625, 815905, 607688, 790958, 740890, 816545, 815165, 469582, 480497, 817878, 670349, 767187, 815798, 716245, 482530, 563150, 407687, 464157, 408196, 814333, 820423, 446630, 596897, 640858, 779744, 799595, 742728, 795163, 478265, 430701, 814753, 530713, 800876, 810980, 451462, 472631, 518218, 386759, 561415, 467914, 481820, 485548, 517784, 405542, 814908, 518223, 536287, 520176, 448806, 406558, 419824, 446148, 536285, 553448, 568177, 522363, 521586, 588624, 527998, 623262, 527990);

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
  3826
  213692
  381813
  386759
  405542
  406558
  407687
  408196
  409942
  419824
  430701
  446148
  446630
  448806
  451462
  462022
  464157
  467914
  469582
  472631
  478265
  480497
  481820
  482530
  485548
  517784
  518218
  518223
  520176
  521586
  522363
  527990
  527998
  530713
  536285
  536287
  553448
  561415
  563150
  565625
  568177
  586950
  588624
  596897
  607688
  623262
  640858
  670349
  716245
  720534
  740890
  742728
  767187
  770116
  779744
  790958
  795163
  799595
  800724
  800876
  810980
  814333
  814753
  814908
  815165
  815798
  815905
  816545
  817062
  817878
  820423
  824454
  824456
]

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 (3826, 213692, 381813, 386759, 405542, 406558, 407687, 408196, 409942, 419824, 430701, 446148, 446630, 448806, 451462, 462022, 464157, 467914, 469582, 472631, 478265, 480497, 481820, 482530, 485548, 517784, 518218, 518223, 520176, 521586, 522363, 527990, 527998, 530713, 536285, 536287, 553448, 561415, 563150, 565625, 568177, 586950, 588624, 596897, 607688, 623262, 640858, 670349, 716245, 720534, 740890, 742728, 767187, 770116, 779744, 790958, 795163, 799595, 800724, 800876, 810980, 814333, 814753, 814908, 815165, 815798, 815905, 816545, 817062, 817878, 820423, 824454, 824456);

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
  3826
  213692
  381813
  386759
  405542
  406558
  407687
  408196
  409942
  419824
  430701
  446148
  446630
  448806
  451462
  462022
  464157
  467914
  469582
  472631
  478265
  480497
  481820
  482530
  485548
  517784
  518218
  518223
  520176
  521586
  522363
  527990
  527998
  530713
  536285
  536287
  553448
  561415
  563150
  565625
  568177
  586950
  588624
  596897
  607688
  623262
  640858
  670349
  716245
  720534
  740890
  742728
  767187
  770116
  779744
  790958
  795163
  799595
  800724
  800876
  810980
  814333
  814753
  814908
  815165
  815798
  815905
  816545
  817062
  817878
  820423
  824454
  824456
]

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 (3826, 213692, 381813, 386759, 405542, 406558, 407687, 408196, 409942, 419824, 430701, 446148, 446630, 448806, 451462, 462022, 464157, 467914, 469582, 472631, 478265, 480497, 481820, 482530, 485548, 517784, 518218, 518223, 520176, 521586, 522363, 527990, 527998, 530713, 536285, 536287, 553448, 561415, 563150, 565625, 568177, 586950, 588624, 596897, 607688, 623262, 640858, 670349, 716245, 720534, 740890, 742728, 767187, 770116, 779744, 790958, 795163, 799595, 800724, 800876, 810980, 814333, 814753, 814908, 815165, 815798, 815905, 816545, 817062, 817878, 820423, 824454, 824456);

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

[
  "stunning mature"
]

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

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

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

[
  "stunning mature"
]

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

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

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