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

[
  "hairy girl hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy girl hard' 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
  786525
  623364
  528380
  445945
  695178
  801610
  405123
  446639
  612281
  739705
  473453
  475915
  464971
  543812
  690785
  615851
  586518
  615748
  618460
  400958
  423650
  415005
  560152
  425332
  464162
  434376
  528258
  495014
  551125
  570759
  543920
  677259
  592170
  445903
  452834
  582790
  472531
  396087
  461275
  631972
  478832
  499498
  418102
  409894
  475781
  471631
  512980
  487348
  446027
  517068
  561073
  587311
  509997
  350425
  481463
  515916
  469950
  421566
  507651
  486835
  520354
  517008
  419370
  428224
  562001
  448816
  615382
  642016
  603493
  490511
]

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 (786525, 623364, 528380, 445945, 695178, 801610, 405123, 446639, 612281, 739705, 473453, 475915, 464971, 543812, 690785, 615851, 586518, 615748, 618460, 400958, 423650, 415005, 560152, 425332, 464162, 434376, 528258, 495014, 551125, 570759, 543920, 677259, 592170, 445903, 452834, 582790, 472531, 396087, 461275, 631972, 478832, 499498, 418102, 409894, 475781, 471631, 512980, 487348, 446027, 517068, 561073, 587311, 509997, 350425, 481463, 515916, 469950, 421566, 507651, 486835, 520354, 517008, 419370, 428224, 562001, 448816, 615382, 642016, 603493, 490511);

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
  350425
  396087
  400958
  405123
  409894
  415005
  418102
  419370
  421566
  423650
  425332
  428224
  434376
  445903
  445945
  446027
  446639
  448816
  452834
  461275
  464162
  464971
  469950
  471631
  472531
  473453
  475781
  475915
  478832
  481463
  486835
  487348
  490511
  495014
  499498
  507651
  509997
  512980
  515916
  517008
  517068
  520354
  528258
  528380
  543812
  543920
  551125
  560152
  561073
  562001
  570759
  582790
  586518
  587311
  592170
  603493
  612281
  615382
  615748
  615851
  618460
  623364
  631972
  642016
  677259
  690785
  695178
  739705
  786525
  801610
]

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 (350425, 396087, 400958, 405123, 409894, 415005, 418102, 419370, 421566, 423650, 425332, 428224, 434376, 445903, 445945, 446027, 446639, 448816, 452834, 461275, 464162, 464971, 469950, 471631, 472531, 473453, 475781, 475915, 478832, 481463, 486835, 487348, 490511, 495014, 499498, 507651, 509997, 512980, 515916, 517008, 517068, 520354, 528258, 528380, 543812, 543920, 551125, 560152, 561073, 562001, 570759, 582790, 586518, 587311, 592170, 603493, 612281, 615382, 615748, 615851, 618460, 623364, 631972, 642016, 677259, 690785, 695178, 739705, 786525, 801610);

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
  350425
  396087
  400958
  405123
  409894
  415005
  418102
  419370
  421566
  423650
  425332
  428224
  434376
  445903
  445945
  446027
  446639
  448816
  452834
  461275
  464162
  464971
  469950
  471631
  472531
  473453
  475781
  475915
  478832
  481463
  486835
  487348
  490511
  495014
  499498
  507651
  509997
  512980
  515916
  517008
  517068
  520354
  528258
  528380
  543812
  543920
  551125
  560152
  561073
  562001
  570759
  582790
  586518
  587311
  592170
  603493
  612281
  615382
  615748
  615851
  618460
  623364
  631972
  642016
  677259
  690785
  695178
  739705
  786525
  801610
]

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 (350425, 396087, 400958, 405123, 409894, 415005, 418102, 419370, 421566, 423650, 425332, 428224, 434376, 445903, 445945, 446027, 446639, 448816, 452834, 461275, 464162, 464971, 469950, 471631, 472531, 473453, 475781, 475915, 478832, 481463, 486835, 487348, 490511, 495014, 499498, 507651, 509997, 512980, 515916, 517008, 517068, 520354, 528258, 528380, 543812, 543920, 551125, 560152, 561073, 562001, 570759, 582790, 586518, 587311, 592170, 603493, 612281, 615382, 615748, 615851, 618460, 623364, 631972, 642016, 677259, 690785, 695178, 739705, 786525, 801610);

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

[
  "волосатая девушк hard"
]

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

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

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

[
  "волосатая девушк hard"
]

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

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