Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.53 ms
(89.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
  206202
  359918
  373852
  383266
  383531
  386596
  389124
  390024
  390533
  391027
  395446
  396708
  400932
  402546
  410934
  410935
  413833
  416319
  417367
  418724
  420559
  421520
  426386
  431675
  443662
  448552
  448982
  448993
  454365
  456430
  460297
  474642
  475799
  475933
  476259
  478548
  478555
  478779
  478784
  481145
  482936
  484411
  492273
  497590
  503213
  506195
  508445
  509425
  516307
  521823
  522851
  531237
  531777
  536394
  537673
  541252
  541875
  543821
  544833
  545602
  546668
  550305
  558124
  583670
  598686
  605003
  606540
  609568
  614344
  620130
  632034
  633454
  633804
  634213
  637033
  637087
  638561
  641965
  642715
  644689
  645263
  648836
  660963
  665681
  665926
  670820
  671677
  676024
  678942
  678943
  682521
  684048
  684543
  684547
  684560
  690859
  696212
  696352
  696951
  699554
  707889
  710832
  714530
  719391
  720301
  720823
  720871
  720882
  721180
  722809
  756405
  760957
  766626
  805023
  813873
  814069
  814888
  814975
  817033
  817448
]
13.96 ms
(6.55%)
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
  402546
  817448
  448993
  660963
  671677
  684048
  690859
  558124
  605003
  642715
  389124
  391027
  814888
  536394
  478548
  478784
  497590
  416319
  482936
  417367
  413833
  400932
  481145
  478555
  503213
  541875
  756405
  766626
  383266
  390024
  478779
  521823
  454365
  460297
  418724
  544833
  648836
  359918
  676024
  696212
  420559
  390533
  516307
  474642
  492273
  583670
  410935
  410934
  614344
  431675
  620130
  508445
  506195
  598686
  448552
  682521
  699554
  373852
  545602
  606540
  541252
  421520
  206202
  670820
  710832
  396708
  443662
  531777
  543821
  641965
  395446
  475933
  426386
  813873
  456430
  475799
  448982
  484411
  509425
  684543
  720882
  645263
  678942
  721180
  722809
  684547
  609568
  632034
  644689
  634213
  760957
  696951
  386596
  522851
  383531
  814975
  817033
  814069
  531237
  537673
  476259
  550305
  665681
  684560
  696352
  714530
  665926
  678943
  719391
  720301
  720823
  707889
  720871
  546668
  633454
  637033
  633804
  638561
  637087
  805023
]
3.03 ms
(1.42%)
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
  206202
  359918
  373852
  383266
  383531
  386596
  389124
  390024
  390533
  391027
  395446
  396708
  400932
  402546
  410934
  410935
  413833
  416319
  417367
  418724
  420559
  421520
  426386
  431675
  443662
  448552
  448982
  448993
  454365
  456430
  460297
  474642
  475799
  475933
  476259
  478548
  478555
  478779
  478784
  481145
  482936
  484411
  492273
  497590
  503213
  506195
  508445
  509425
  516307
  521823
  522851
  531237
  531777
  536394
  537673
  541252
  541875
  543821
  544833
  545602
  546668
  550305
  558124
  583670
  598686
  605003
  606540
  609568
  614344
  620130
  632034
  633454
  633804
  634213
  637033
  637087
  638561
  641965
  642715
  644689
  645263
  648836
  660963
  665681
  665926
  670820
  671677
  676024
  678942
  678943
  682521
  684048
  684543
  684547
  684560
  690859
  696212
  696352
  696951
  699554
  707889
  710832
  714530
  719391
  720301
  720823
  720871
  720882
  721180
  722809
  756405
  760957
  766626
  805023
  813873
  814069
  814888
  814975
  817033
  817448
]
1.53 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen мжм секс втро анал"
]
1.43 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen mmf anal"
]
1.38 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen мжм секс втро анал"
]
1.33 ms
(0.62%)
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.