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

[
  "amateur bbw sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur bbw 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
  644849
  407423
  467029
  510425
  455353
  536481
  428174
  445607
  582694
  631878
  511086
  662879
  617659
  419979
  490304
  447942
  496662
  458974
  476339
  444940
  454224
  515572
  391287
  520666
  502841
  444915
  515350
  590418
  489868
  428697
  599631
  761039
  456720
  464985
  536637
  524903
  695163
  476015
  458761
  453408
  562030
  507640
  426600
  523169
  509439
  446964
  507643
  571823
  662896
  562973
  414369
  716811
  549754
  400826
  763136
  474923
  494282
  564244
  468165
  454968
  474089
  491436
  472943
  589290
  494291
  592979
  464359
  453203
  583371
  698124
  554770
  427543
  589671
  587833
  615978
]

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 (644849, 407423, 467029, 510425, 455353, 536481, 428174, 445607, 582694, 631878, 511086, 662879, 617659, 419979, 490304, 447942, 496662, 458974, 476339, 444940, 454224, 515572, 391287, 520666, 502841, 444915, 515350, 590418, 489868, 428697, 599631, 761039, 456720, 464985, 536637, 524903, 695163, 476015, 458761, 453408, 562030, 507640, 426600, 523169, 509439, 446964, 507643, 571823, 662896, 562973, 414369, 716811, 549754, 400826, 763136, 474923, 494282, 564244, 468165, 454968, 474089, 491436, 472943, 589290, 494291, 592979, 464359, 453203, 583371, 698124, 554770, 427543, 589671, 587833, 615978);

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
  391287
  400826
  407423
  414369
  419979
  426600
  427543
  428174
  428697
  444915
  444940
  445607
  446964
  447942
  453203
  453408
  454224
  454968
  455353
  456720
  458761
  458974
  464359
  464985
  467029
  468165
  472943
  474089
  474923
  476015
  476339
  489868
  490304
  491436
  494282
  494291
  496662
  502841
  507640
  507643
  509439
  510425
  511086
  515350
  515572
  520666
  523169
  524903
  536481
  536637
  549754
  554770
  562030
  562973
  564244
  571823
  582694
  583371
  587833
  589290
  589671
  590418
  592979
  599631
  615978
  617659
  631878
  644849
  662879
  662896
  695163
  698124
  716811
  761039
  763136
]

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 (391287, 400826, 407423, 414369, 419979, 426600, 427543, 428174, 428697, 444915, 444940, 445607, 446964, 447942, 453203, 453408, 454224, 454968, 455353, 456720, 458761, 458974, 464359, 464985, 467029, 468165, 472943, 474089, 474923, 476015, 476339, 489868, 490304, 491436, 494282, 494291, 496662, 502841, 507640, 507643, 509439, 510425, 511086, 515350, 515572, 520666, 523169, 524903, 536481, 536637, 549754, 554770, 562030, 562973, 564244, 571823, 582694, 583371, 587833, 589290, 589671, 590418, 592979, 599631, 615978, 617659, 631878, 644849, 662879, 662896, 695163, 698124, 716811, 761039, 763136);

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
  391287
  400826
  407423
  414369
  419979
  426600
  427543
  428174
  428697
  444915
  444940
  445607
  446964
  447942
  453203
  453408
  454224
  454968
  455353
  456720
  458761
  458974
  464359
  464985
  467029
  468165
  472943
  474089
  474923
  476015
  476339
  489868
  490304
  491436
  494282
  494291
  496662
  502841
  507640
  507643
  509439
  510425
  511086
  515350
  515572
  520666
  523169
  524903
  536481
  536637
  549754
  554770
  562030
  562973
  564244
  571823
  582694
  583371
  587833
  589290
  589671
  590418
  592979
  599631
  615978
  617659
  631878
  644849
  662879
  662896
  695163
  698124
  716811
  761039
  763136
]

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 (391287, 400826, 407423, 414369, 419979, 426600, 427543, 428174, 428697, 444915, 444940, 445607, 446964, 447942, 453203, 453408, 454224, 454968, 455353, 456720, 458761, 458974, 464359, 464985, 467029, 468165, 472943, 474089, 474923, 476015, 476339, 489868, 490304, 491436, 494282, 494291, 496662, 502841, 507640, 507643, 509439, 510425, 511086, 515350, 515572, 520666, 523169, 524903, 536481, 536637, 549754, 554770, 562030, 562973, 564244, 571823, 582694, 583371, 587833, 589290, 589671, 590418, 592979, 599631, 615978, 617659, 631878, 644849, 662879, 662896, 695163, 698124, 716811, 761039, 763136);

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

[
  "любительск bbw секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск bbw секс';

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

[
  "любительск bbw секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск bbw секс';