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

[
  "homemade bbw"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'homemade bbw' 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
  529378
  496017
  563732
  577211
  582444
  584366
  590418
  407423
  475592
  463152
  467029
  398949
  509842
  510425
  562030
  507643
  413286
  443637
  428174
  453242
  454447
  496662
  514843
  477717
  578198
  582694
  651609
  631878
  588591
  459189
  464023
  458974
  400993
  476339
  420132
  444940
  511086
  490467
  527424
  536481
  662879
  489868
  507640
  781812
  401921
  443134
  549754
  458761
  490304
  502841
  571823
  761039
  456720
  464985
  447942
  520666
  515350
  523169
  562973
  695163
  476015
  446964
  509439
  419979
  564244
  662896
  716811
  472943
  491436
  453408
  468165
  454968
  763136
  463973
  474923
  592979
  698124
  589290
  474089
  427543
  583371
  589671
  587833
]

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 (529378, 496017, 563732, 577211, 582444, 584366, 590418, 407423, 475592, 463152, 467029, 398949, 509842, 510425, 562030, 507643, 413286, 443637, 428174, 453242, 454447, 496662, 514843, 477717, 578198, 582694, 651609, 631878, 588591, 459189, 464023, 458974, 400993, 476339, 420132, 444940, 511086, 490467, 527424, 536481, 662879, 489868, 507640, 781812, 401921, 443134, 549754, 458761, 490304, 502841, 571823, 761039, 456720, 464985, 447942, 520666, 515350, 523169, 562973, 695163, 476015, 446964, 509439, 419979, 564244, 662896, 716811, 472943, 491436, 453408, 468165, 454968, 763136, 463973, 474923, 592979, 698124, 589290, 474089, 427543, 583371, 589671, 587833);

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
  398949
  400993
  401921
  407423
  413286
  419979
  420132
  427543
  428174
  443134
  443637
  444940
  446964
  447942
  453242
  453408
  454447
  454968
  456720
  458761
  458974
  459189
  463152
  463973
  464023
  464985
  467029
  468165
  472943
  474089
  474923
  475592
  476015
  476339
  477717
  489868
  490304
  490467
  491436
  496017
  496662
  502841
  507640
  507643
  509439
  509842
  510425
  511086
  514843
  515350
  520666
  523169
  527424
  529378
  536481
  549754
  562030
  562973
  563732
  564244
  571823
  577211
  578198
  582444
  582694
  583371
  584366
  587833
  588591
  589290
  589671
  590418
  592979
  631878
  651609
  662879
  662896
  695163
  698124
  716811
  761039
  763136
  781812
]

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 (398949, 400993, 401921, 407423, 413286, 419979, 420132, 427543, 428174, 443134, 443637, 444940, 446964, 447942, 453242, 453408, 454447, 454968, 456720, 458761, 458974, 459189, 463152, 463973, 464023, 464985, 467029, 468165, 472943, 474089, 474923, 475592, 476015, 476339, 477717, 489868, 490304, 490467, 491436, 496017, 496662, 502841, 507640, 507643, 509439, 509842, 510425, 511086, 514843, 515350, 520666, 523169, 527424, 529378, 536481, 549754, 562030, 562973, 563732, 564244, 571823, 577211, 578198, 582444, 582694, 583371, 584366, 587833, 588591, 589290, 589671, 590418, 592979, 631878, 651609, 662879, 662896, 695163, 698124, 716811, 761039, 763136, 781812);

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
  398949
  400993
  401921
  407423
  413286
  419979
  420132
  427543
  428174
  443134
  443637
  444940
  446964
  447942
  453242
  453408
  454447
  454968
  456720
  458761
  458974
  459189
  463152
  463973
  464023
  464985
  467029
  468165
  472943
  474089
  474923
  475592
  476015
  476339
  477717
  489868
  490304
  490467
  491436
  496017
  496662
  502841
  507640
  507643
  509439
  509842
  510425
  511086
  514843
  515350
  520666
  523169
  527424
  529378
  536481
  549754
  562030
  562973
  563732
  564244
  571823
  577211
  578198
  582444
  582694
  583371
  584366
  587833
  588591
  589290
  589671
  590418
  592979
  631878
  651609
  662879
  662896
  695163
  698124
  716811
  761039
  763136
  781812
]

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 (398949, 400993, 401921, 407423, 413286, 419979, 420132, 427543, 428174, 443134, 443637, 444940, 446964, 447942, 453242, 453408, 454447, 454968, 456720, 458761, 458974, 459189, 463152, 463973, 464023, 464985, 467029, 468165, 472943, 474089, 474923, 475592, 476015, 476339, 477717, 489868, 490304, 490467, 491436, 496017, 496662, 502841, 507640, 507643, 509439, 509842, 510425, 511086, 514843, 515350, 520666, 523169, 527424, 529378, 536481, 549754, 562030, 562973, 563732, 564244, 571823, 577211, 578198, 582444, 582694, 583371, 584366, 587833, 588591, 589290, 589671, 590418, 592979, 631878, 651609, 662879, 662896, 695163, 698124, 716811, 761039, 763136, 781812);

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';