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

[
  "moms teach sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'moms teach sex' 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
  557551
  398402
  395541
  400157
  397255
  395577
  411236
  396768
  395427
  400125
  421085
  394243
  422261
  451967
  452130
  561558
  400156
  392748
  400178
  400243
  413870
  428450
  813913
  531523
  560229
  400138
  420227
  400195
  401223
  413908
  400137
  519480
  395564
  397372
  400233
  400106
  413890
  557549
  400148
  400191
  407379
  408293
  400237
  469061
  393865
  400166
  400254
  430072
  522926
  562376
  400196
  397369
  425800
  533965
  413888
  428477
  425809
  452028
  501338
  488123
  476909
  421000
  472734
  430204
  509712
  503194
  438278
  482507
  519278
  531943
  469476
  510299
]

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 (557551, 398402, 395541, 400157, 397255, 395577, 411236, 396768, 395427, 400125, 421085, 394243, 422261, 451967, 452130, 561558, 400156, 392748, 400178, 400243, 413870, 428450, 813913, 531523, 560229, 400138, 420227, 400195, 401223, 413908, 400137, 519480, 395564, 397372, 400233, 400106, 413890, 557549, 400148, 400191, 407379, 408293, 400237, 469061, 393865, 400166, 400254, 430072, 522926, 562376, 400196, 397369, 425800, 533965, 413888, 428477, 425809, 452028, 501338, 488123, 476909, 421000, 472734, 430204, 509712, 503194, 438278, 482507, 519278, 531943, 469476, 510299);

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
  392748
  393865
  394243
  395427
  395541
  395564
  395577
  396768
  397255
  397369
  397372
  398402
  400106
  400125
  400137
  400138
  400148
  400156
  400157
  400166
  400178
  400191
  400195
  400196
  400233
  400237
  400243
  400254
  401223
  407379
  408293
  411236
  413870
  413888
  413890
  413908
  420227
  421000
  421085
  422261
  425800
  425809
  428450
  428477
  430072
  430204
  438278
  451967
  452028
  452130
  469061
  469476
  472734
  476909
  482507
  488123
  501338
  503194
  509712
  510299
  519278
  519480
  522926
  531523
  531943
  533965
  557549
  557551
  560229
  561558
  562376
  813913
]

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 (392748, 393865, 394243, 395427, 395541, 395564, 395577, 396768, 397255, 397369, 397372, 398402, 400106, 400125, 400137, 400138, 400148, 400156, 400157, 400166, 400178, 400191, 400195, 400196, 400233, 400237, 400243, 400254, 401223, 407379, 408293, 411236, 413870, 413888, 413890, 413908, 420227, 421000, 421085, 422261, 425800, 425809, 428450, 428477, 430072, 430204, 438278, 451967, 452028, 452130, 469061, 469476, 472734, 476909, 482507, 488123, 501338, 503194, 509712, 510299, 519278, 519480, 522926, 531523, 531943, 533965, 557549, 557551, 560229, 561558, 562376, 813913);

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
  392748
  393865
  394243
  395427
  395541
  395564
  395577
  396768
  397255
  397369
  397372
  398402
  400106
  400125
  400137
  400138
  400148
  400156
  400157
  400166
  400178
  400191
  400195
  400196
  400233
  400237
  400243
  400254
  401223
  407379
  408293
  411236
  413870
  413888
  413890
  413908
  420227
  421000
  421085
  422261
  425800
  425809
  428450
  428477
  430072
  430204
  438278
  451967
  452028
  452130
  469061
  469476
  472734
  476909
  482507
  488123
  501338
  503194
  509712
  510299
  519278
  519480
  522926
  531523
  531943
  533965
  557549
  557551
  560229
  561558
  562376
  813913
]

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 (392748, 393865, 394243, 395427, 395541, 395564, 395577, 396768, 397255, 397369, 397372, 398402, 400106, 400125, 400137, 400138, 400148, 400156, 400157, 400166, 400178, 400191, 400195, 400196, 400233, 400237, 400243, 400254, 401223, 407379, 408293, 411236, 413870, 413888, 413890, 413908, 420227, 421000, 421085, 422261, 425800, 425809, 428450, 428477, 430072, 430204, 438278, 451967, 452028, 452130, 469061, 469476, 472734, 476909, 482507, 488123, 501338, 503194, 509712, 510299, 519278, 519480, 522926, 531523, 531943, 533965, 557549, 557551, 560229, 561558, 562376, 813913);

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

[
  "momsteachsex"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'momsteachsex';

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

[
  "momsteachsex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'momsteachsex';

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 ?

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