Query Metrics

7 Database Queries
7 Different statements
142.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
118.12 ms
(82.63%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  30767
  101986
  120074
  233504
  311005
  382468
  385370
  385809
  387291
  387610
  388542
  389517
  390304
  391697
  395170
  395224
  395522
  395926
  397416
  399355
  401866
  404247
  407250
  410874
  412907
  413583
  414427
  416785
  417891
  418897
  419150
  419731
  419882
  420727
  422219
  422291
  423593
  425784
  426026
  426250
  435973
  437748
  441669
  443498
  446902
  447838
  448634
  448969
  449019
  449848
  451420
  452295
  452508
  453218
  453968
  455160
  455530
  455702
  456482
  456543
  456615
  457128
  458521
  459060
  459289
  459655
  461029
  461147
  461783
  462214
  463099
  464307
  464643
  466431
  468586
  468811
  469721
  471804
  472765
  474889
  476438
  479265
  479426
  479613
  480108
  480966
  481214
  482676
  482840
  486278
  486387
  487252
  490314
  490634
  495103
  495442
  496690
  498126
  507455
  508990
  511209
  512713
  513736
  528168
  528785
  543549
  551674
  552851
  557479
  565281
  571799
  571852
  575804
  603488
  624935
  672858
  677847
  686652
  703328
  735901
]
15.26 ms
(10.68%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  390304
  385370
  686652
  311005
  389517
  448969
  387291
  412907
  422219
  461783
  388542
  490314
  474889
  404247
  387610
  677847
  441669
  451420
  418897
  382468
  101986
  413583
  453968
  495442
  423593
  480966
  120074
  455160
  459289
  443498
  463099
  458521
  459655
  391697
  482676
  459060
  511209
  479265
  466431
  395926
  486278
  395224
  462214
  448634
  233504
  419731
  472765
  512713
  507455
  420727
  455702
  395522
  414427
  447838
  449848
  468811
  453218
  456543
  416785
  437748
  464307
  449019
  446902
  575804
  455530
  452508
  481214
  401866
  399355
  571852
  528785
  482840
  571799
  385809
  464643
  552851
  417891
  456482
  425784
  486387
  528168
  456615
  476438
  419882
  565281
  468586
  672858
  426026
  30767
  624935
  513736
  703328
  496690
  735901
  603488
  498126
  397416
  508990
  480108
  487252
  551674
  495103
  407250
  471804
  479613
  490634
  422291
  469721
  461147
  457128
  461029
  543549
  435973
  410874
  395170
  419150
  452295
  557479
  426250
  479426
]
2.77 ms
(1.94%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  30767
  101986
  120074
  233504
  311005
  382468
  385370
  385809
  387291
  387610
  388542
  389517
  390304
  391697
  395170
  395224
  395522
  395926
  397416
  399355
  401866
  404247
  407250
  410874
  412907
  413583
  414427
  416785
  417891
  418897
  419150
  419731
  419882
  420727
  422219
  422291
  423593
  425784
  426026
  426250
  435973
  437748
  441669
  443498
  446902
  447838
  448634
  448969
  449019
  449848
  451420
  452295
  452508
  453218
  453968
  455160
  455530
  455702
  456482
  456543
  456615
  457128
  458521
  459060
  459289
  459655
  461029
  461147
  461783
  462214
  463099
  464307
  464643
  466431
  468586
  468811
  469721
  471804
  472765
  474889
  476438
  479265
  479426
  479613
  480108
  480966
  481214
  482676
  482840
  486278
  486387
  487252
  490314
  490634
  495103
  495442
  496690
  498126
  507455
  508990
  511209
  512713
  513736
  528168
  528785
  543549
  551674
  552851
  557479
  565281
  571799
  571852
  575804
  603488
  624935
  672858
  677847
  686652
  703328
  735901
]
1.97 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстый член в вагине%…"
]
1.66 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "толстый член в вагин"
]
1.59 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "толстый член в вагин"
]
1.57 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.