Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.44 ms
(86.38%)
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
  78479
  188242
  203645
  305931
  387398
  388773
  389264
  391036
  391517
  396259
  397218
  397255
  397708
  411335
  417006
  419616
  421820
  424986
  426245
  427339
  437583
  443403
  444740
  449859
  455324
  462751
  463310
  465791
  467663
  472574
  473458
  476252
  482392
  483485
  483601
  484611
  485223
  496928
  505818
  505826
  509215
  513525
  514114
  515631
  517238
  517446
  520398
  524780
  530937
  541359
  543448
  548081
  555738
  560576
  566858
  570405
  573304
  574442
  575714
  576482
  579740
  581332
  582503
  582887
  582941
  584355
  588325
  589522
  591276
  591627
  606594
  614819
  630494
  649059
  663891
  669515
  672811
  682145
  703900
  708226
  718338
  720868
  727017
  727823
  740284
  742560
  744094
  745517
  751170
  752647
  758171
  758386
  759397
  760713
  760790
  762274
  763081
  763741
  764028
  770065
  773420
  773438
  776189
  780930
  787830
  791479
  792507
  794864
  794894
  804140
  804235
  806164
  807304
  811816
  811889
  814804
  820559
  825992
  826099
]
16.13 ms
(8.53%)
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
  792507
  804235
  484611
  517238
  745517
  203645
  391517
  581332
  576482
  548081
  682145
  449859
  505826
  543448
  573304
  763741
  444740
  437583
  465791
  505818
  541359
  555656
  763081
  520398
  305931
  388773
  396259
  426245
  814804
  820559
  566858
  630494
  591276
  614819
  794894
  794864
  752647
  807304
  759397
  762274
  727017
  742560
  727823
  740284
  758171
  760713
  780930
  78479
  411335
  483485
  473458
  517446
  584355
  555738
  663891
  589522
  776189
  764028
  791479
  773438
  773420
  806164
  397255
  463310
  514114
  476252
  579740
  389264
  513525
  387398
  391036
  397708
  455324
  530937
  560576
  582941
  582887
  672811
  649059
  669515
  720868
  708226
  574442
  588325
  606594
  787830
  804140
  744094
  758386
  770065
  751170
  760790
  718338
  811816
  811889
  419616
  825992
  826099
  575714
  397218
  417006
  427339
  424986
  443403
  483601
  472574
  467663
  582503
  570405
  591627
  515631
  496928
  509215
  485223
  524780
  421820
  462751
  482392
  703900
  188242
]
2.57 ms
(1.36%)
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
  78479
  188242
  203645
  305931
  387398
  388773
  389264
  391036
  391517
  396259
  397218
  397255
  397708
  411335
  417006
  419616
  421820
  424986
  426245
  427339
  437583
  443403
  444740
  449859
  455324
  462751
  463310
  465791
  467663
  472574
  473458
  476252
  482392
  483485
  483601
  484611
  485223
  496928
  505818
  505826
  509215
  513525
  514114
  515631
  517238
  517446
  520398
  524780
  530937
  541359
  543448
  548081
  555738
  560576
  566858
  570405
  573304
  574442
  575714
  576482
  579740
  581332
  582503
  582887
  582941
  584355
  588325
  589522
  591276
  591627
  606594
  614819
  630494
  649059
  663891
  669515
  672811
  682145
  703900
  708226
  718338
  720868
  727017
  727823
  740284
  742560
  744094
  745517
  751170
  752647
  758171
  758386
  759397
  760713
  760790
  762274
  763081
  763741
  764028
  770065
  773420
  773438
  776189
  780930
  787830
  791479
  792507
  794864
  794894
  804140
  804235
  806164
  807304
  811816
  811889
  814804
  820559
  825992
  826099
]
1.83 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн мам женщин ван"
]
1.82 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно тетя ванная"
]
1.78 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн мам женщин ван"
]
1.63 ms
(0.86%)
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.