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

[
  "brianna beach sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'brianna beach 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
  482300
  571059
  807475
  476904
  576265
  807483
  807442
  780675
  807470
  807499
  576264
  807480
  773681
  727205
  433965
  807489
  581723
  807477
  807490
  507884
  520683
  450759
  570396
  571058
  557892
  475035
  498342
  548844
  807485
  450767
  576267
  498431
  600965
  382662
  424982
  507885
  573390
  827833
  827857
  411038
  430247
  428468
  417018
  410177
  450821
  450764
  450773
  827903
  429584
  429528
  447937
  384298
  464559
  466711
  446114
  450771
  452986
  460182
  450816
  417990
  482303
  413097
  450761
  450801
  449243
  498411
  481945
  450813
  507895
  433958
  482305
  450760
  450811
  464335
  428803
  447276
  499896
  450766
  450770
  450786
  489325
]

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 (482300, 571059, 807475, 476904, 576265, 807483, 807442, 780675, 807470, 807499, 576264, 807480, 773681, 727205, 433965, 807489, 581723, 807477, 807490, 507884, 520683, 450759, 570396, 571058, 557892, 475035, 498342, 548844, 807485, 450767, 576267, 498431, 600965, 382662, 424982, 507885, 573390, 827833, 827857, 411038, 430247, 428468, 417018, 410177, 450821, 450764, 450773, 827903, 429584, 429528, 447937, 384298, 464559, 466711, 446114, 450771, 452986, 460182, 450816, 417990, 482303, 413097, 450761, 450801, 449243, 498411, 481945, 450813, 507895, 433958, 482305, 450760, 450811, 464335, 428803, 447276, 499896, 450766, 450770, 450786, 489325);

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
  382662
  384298
  410177
  411038
  413097
  417018
  417990
  424982
  428468
  428803
  429528
  429584
  430247
  433958
  433965
  446114
  447276
  447937
  449243
  450759
  450760
  450761
  450764
  450766
  450767
  450770
  450771
  450773
  450786
  450801
  450811
  450813
  450816
  450821
  452986
  460182
  464335
  464559
  466711
  475035
  476904
  481945
  482300
  482303
  482305
  489325
  498342
  498411
  498431
  499896
  507884
  507885
  507895
  520683
  548844
  557892
  570396
  571058
  571059
  573390
  576264
  576265
  576267
  581723
  600965
  727205
  773681
  780675
  807442
  807470
  807475
  807477
  807480
  807483
  807485
  807489
  807490
  807499
  827833
  827857
  827903
]

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 (382662, 384298, 410177, 411038, 413097, 417018, 417990, 424982, 428468, 428803, 429528, 429584, 430247, 433958, 433965, 446114, 447276, 447937, 449243, 450759, 450760, 450761, 450764, 450766, 450767, 450770, 450771, 450773, 450786, 450801, 450811, 450813, 450816, 450821, 452986, 460182, 464335, 464559, 466711, 475035, 476904, 481945, 482300, 482303, 482305, 489325, 498342, 498411, 498431, 499896, 507884, 507885, 507895, 520683, 548844, 557892, 570396, 571058, 571059, 573390, 576264, 576265, 576267, 581723, 600965, 727205, 773681, 780675, 807442, 807470, 807475, 807477, 807480, 807483, 807485, 807489, 807490, 807499, 827833, 827857, 827903);

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
  382662
  384298
  410177
  411038
  413097
  417018
  417990
  424982
  428468
  428803
  429528
  429584
  430247
  433958
  433965
  446114
  447276
  447937
  449243
  450759
  450760
  450761
  450764
  450766
  450767
  450770
  450771
  450773
  450786
  450801
  450811
  450813
  450816
  450821
  452986
  460182
  464335
  464559
  466711
  475035
  476904
  481945
  482300
  482303
  482305
  489325
  498342
  498411
  498431
  499896
  507884
  507885
  507895
  520683
  548844
  557892
  570396
  571058
  571059
  573390
  576264
  576265
  576267
  581723
  600965
  727205
  773681
  780675
  807442
  807470
  807475
  807477
  807480
  807483
  807485
  807489
  807490
  807499
  827833
  827857
  827903
]

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 (382662, 384298, 410177, 411038, 413097, 417018, 417990, 424982, 428468, 428803, 429528, 429584, 430247, 433958, 433965, 446114, 447276, 447937, 449243, 450759, 450760, 450761, 450764, 450766, 450767, 450770, 450771, 450773, 450786, 450801, 450811, 450813, 450816, 450821, 452986, 460182, 464335, 464559, 466711, 475035, 476904, 481945, 482300, 482303, 482305, 489325, 498342, 498411, 498431, 499896, 507884, 507885, 507895, 520683, 548844, 557892, 570396, 571058, 571059, 573390, 576264, 576265, 576267, 581723, 600965, 727205, 773681, 780675, 807442, 807470, 807475, 807477, 807480, 807483, 807485, 807489, 807490, 807499, 827833, 827857, 827903);

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

[
  "briannabeach секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'briannabeach секс';

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

[
  "briannabeach секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'briannabeach секс';