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

[
  "blowjob sloppy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blowjob sloppy' 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
  635422
  402678
  616630
  606987
  424237
  493842
  414327
  421569
  420741
  422290
  472119
  519657
  510832
  424190
  487816
  456297
  431913
  447718
  454074
  528006
  478540
  451772
  489257
  514842
  567154
  497230
  485059
  518636
  533950
  466376
  458614
  529229
  571841
  704339
  529271
  556664
  455793
  716811
  514959
  520701
  450441
  501714
  489258
  530761
  505795
  502554
  501209
  444313
  521666
  516607
  591413
  532380
  520205
  764233
  524141
  503310
  620225
  615491
  509713
  507312
  471380
  527222
  544012
  620250
  524417
  505794
  508494
  520448
  522238
  419370
  560199
  480194
  517345
  543659
  617153
  527933
  488823
  584514
  626014
  591176
]

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 (635422, 402678, 616630, 606987, 424237, 493842, 414327, 421569, 420741, 422290, 472119, 519657, 510832, 424190, 487816, 456297, 431913, 447718, 454074, 528006, 478540, 451772, 489257, 514842, 567154, 497230, 485059, 518636, 533950, 466376, 458614, 529229, 571841, 704339, 529271, 556664, 455793, 716811, 514959, 520701, 450441, 501714, 489258, 530761, 505795, 502554, 501209, 444313, 521666, 516607, 591413, 532380, 520205, 764233, 524141, 503310, 620225, 615491, 509713, 507312, 471380, 527222, 544012, 620250, 524417, 505794, 508494, 520448, 522238, 419370, 560199, 480194, 517345, 543659, 617153, 527933, 488823, 584514, 626014, 591176);

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
  402678
  414327
  419370
  420741
  421569
  422290
  424190
  424237
  431913
  444313
  447718
  450441
  451772
  454074
  455793
  456297
  458614
  466376
  471380
  472119
  478540
  480194
  485059
  487816
  488823
  489257
  489258
  493842
  497230
  501209
  501714
  502554
  503310
  505795
  507312
  508494
  509713
  510832
  514842
  514959
  516607
  517345
  518636
  519657
  520205
  520448
  520701
  521666
  522238
  524141
  524417
  527222
  527933
  528006
  529229
  529271
  530761
  532380
  533950
  543659
  544012
  556664
  560199
  567154
  571841
  584514
  591176
  591413
  606987
  615491
  616630
  617153
  620225
  620250
  626014
  635422
  704339
  716811
  764233
]

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 (402678, 414327, 419370, 420741, 421569, 422290, 424190, 424237, 431913, 444313, 447718, 450441, 451772, 454074, 455793, 456297, 458614, 466376, 471380, 472119, 478540, 480194, 485059, 487816, 488823, 489257, 489258, 493842, 497230, 501209, 501714, 502554, 503310, 505795, 507312, 508494, 509713, 510832, 514842, 514959, 516607, 517345, 518636, 519657, 520205, 520448, 520701, 521666, 522238, 524141, 524417, 527222, 527933, 528006, 529229, 529271, 530761, 532380, 533950, 543659, 544012, 556664, 560199, 567154, 571841, 584514, 591176, 591413, 606987, 615491, 616630, 617153, 620225, 620250, 626014, 635422, 704339, 716811, 764233);

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
  402678
  414327
  419370
  420741
  421569
  422290
  424190
  424237
  431913
  444313
  447718
  450441
  451772
  454074
  455793
  456297
  458614
  466376
  471380
  472119
  478540
  480194
  485059
  487816
  488823
  489257
  489258
  493842
  497230
  501209
  501714
  502554
  503310
  505795
  507312
  508494
  509713
  510832
  514842
  514959
  516607
  517345
  518636
  519657
  520205
  520448
  520701
  521666
  522238
  524141
  524417
  527222
  527933
  528006
  529229
  529271
  530761
  532380
  533950
  543659
  544012
  556664
  560199
  567154
  571841
  584514
  591176
  591413
  606987
  615491
  616630
  617153
  620225
  620250
  626014
  635422
  704339
  716811
  764233
]

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 (402678, 414327, 419370, 420741, 421569, 422290, 424190, 424237, 431913, 444313, 447718, 450441, 451772, 454074, 455793, 456297, 458614, 466376, 471380, 472119, 478540, 480194, 485059, 487816, 488823, 489257, 489258, 493842, 497230, 501209, 501714, 502554, 503310, 505795, 507312, 508494, 509713, 510832, 514842, 514959, 516607, 517345, 518636, 519657, 520205, 520448, 520701, 521666, 522238, 524141, 524417, 527222, 527933, 528006, 529229, 529271, 530761, 532380, 533950, 543659, 544012, 556664, 560199, 567154, 571841, 584514, 591176, 591413, 606987, 615491, 616630, 617153, 620225, 620250, 626014, 635422, 704339, 716811, 764233);

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

[
  "минет оральн секс sloppy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'минет оральн секс sloppy';

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

[
  "минет оральн секс sloppy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'минет оральн секс sloppy';