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

[
  "blonde girl masturbating"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blonde girl masturbating' 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
  643969
  781381
  55146
  387806
  779335
  754496
  780408
  633434
  785759
  186392
  714112
  636372
  744057
  662803
  389596
  645388
  786264
  769317
  754577
  803114
  591530
  774117
  743218
  628359
  575958
  740269
  672310
  591626
  808965
  752944
  777713
  756120
  423711
  391993
  754436
  819766
  607507
  604118
  715175
  621079
  736020
  477227
  589824
  768884
  781185
  381828
  413106
  800074
  790764
  525776
  439260
  452934
  627007
  643005
  408998
  550451
  420313
  551484
  527795
  384400
  465138
  533599
  385977
  451502
  388184
  809260
  474575
  514073
  424624
  560325
  524598
  418069
  455577
  518086
  523458
  414767
  615838
  423760
  478186
]

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 (643969, 781381, 55146, 387806, 779335, 754496, 780408, 633434, 785759, 186392, 714112, 636372, 744057, 662803, 389596, 645388, 786264, 769317, 754577, 803114, 591530, 774117, 743218, 628359, 575958, 740269, 672310, 591626, 808965, 752944, 777713, 756120, 423711, 391993, 754436, 819766, 607507, 604118, 715175, 621079, 736020, 477227, 589824, 768884, 781185, 381828, 413106, 800074, 790764, 525776, 439260, 452934, 627007, 643005, 408998, 550451, 420313, 551484, 527795, 384400, 465138, 533599, 385977, 451502, 388184, 809260, 474575, 514073, 424624, 560325, 524598, 418069, 455577, 518086, 523458, 414767, 615838, 423760, 478186);

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
  55146
  186392
  381828
  384400
  385977
  387806
  388184
  389596
  391993
  408998
  413106
  414767
  418069
  420313
  423711
  423760
  424624
  439260
  451502
  452934
  455577
  465138
  474575
  477227
  478186
  514073
  518086
  523458
  524598
  525776
  527795
  533599
  550451
  551484
  560325
  575958
  589824
  591530
  591626
  604118
  607507
  615838
  621079
  627007
  628359
  633434
  636372
  643005
  643969
  645388
  662803
  672310
  714112
  715175
  736020
  740269
  743218
  744057
  752944
  754436
  754496
  754577
  756120
  768884
  769317
  774117
  777713
  779335
  780408
  781185
  781381
  785759
  786264
  790764
  800074
  803114
  808965
  809260
  819766
]

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 (55146, 186392, 381828, 384400, 385977, 387806, 388184, 389596, 391993, 408998, 413106, 414767, 418069, 420313, 423711, 423760, 424624, 439260, 451502, 452934, 455577, 465138, 474575, 477227, 478186, 514073, 518086, 523458, 524598, 525776, 527795, 533599, 550451, 551484, 560325, 575958, 589824, 591530, 591626, 604118, 607507, 615838, 621079, 627007, 628359, 633434, 636372, 643005, 643969, 645388, 662803, 672310, 714112, 715175, 736020, 740269, 743218, 744057, 752944, 754436, 754496, 754577, 756120, 768884, 769317, 774117, 777713, 779335, 780408, 781185, 781381, 785759, 786264, 790764, 800074, 803114, 808965, 809260, 819766);

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
  55146
  186392
  381828
  384400
  385977
  387806
  388184
  389596
  391993
  408998
  413106
  414767
  418069
  420313
  423711
  423760
  424624
  439260
  451502
  452934
  455577
  465138
  474575
  477227
  478186
  514073
  518086
  523458
  524598
  525776
  527795
  533599
  550451
  551484
  560325
  575958
  589824
  591530
  591626
  604118
  607507
  615838
  621079
  627007
  628359
  633434
  636372
  643005
  643969
  645388
  662803
  672310
  714112
  715175
  736020
  740269
  743218
  744057
  752944
  754436
  754496
  754577
  756120
  768884
  769317
  774117
  777713
  779335
  780408
  781185
  781381
  785759
  786264
  790764
  800074
  803114
  808965
  809260
  819766
]

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 (55146, 186392, 381828, 384400, 385977, 387806, 388184, 389596, 391993, 408998, 413106, 414767, 418069, 420313, 423711, 423760, 424624, 439260, 451502, 452934, 455577, 465138, 474575, 477227, 478186, 514073, 518086, 523458, 524598, 525776, 527795, 533599, 550451, 551484, 560325, 575958, 589824, 591530, 591626, 604118, 607507, 615838, 621079, 627007, 628359, 633434, 636372, 643005, 643969, 645388, 662803, 672310, 714112, 715175, 736020, 740269, 743218, 744057, 752944, 754436, 754496, 754577, 756120, 768884, 769317, 774117, 777713, 779335, 780408, 781185, 781381, 785759, 786264, 790764, 800074, 803114, 808965, 809260, 819766);

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

[
  "беловолосая девушк masturbating"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'беловолосая девушк masturbating';

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

[
  "беловолосая девушк masturbating"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'беловолосая девушк masturbating';