Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.57 ms
(56.33%)
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
  73571
  183401
  256371
  384315
  388312
  388322
  398444
  441798
  480593
  490324
  496709
  512217
  545735
  561488
  566459
  567737
  574090
  574524
  579507
  580361
  589604
  590441
  591780
  598592
  613710
  617115
  617968
  621412
  627052
  627961
  628340
  635133
  638949
  650669
  652734
  668023
  670815
  680650
  683679
  689399
  697587
  697763
  698233
  700860
  701059
  703255
  711918
  715291
  715469
  717697
  720900
  724806
  724920
  730967
  732247
  735481
  739186
  740082
  742540
  743188
  744713
  746624
  747273
  748107
  752112
  752912
  753304
  753327
  753405
  754654
  759051
  761918
  763524
  768699
  770729
  770820
  771606
  771873
  773596
  773809
  776823
  777835
  778600
  779132
  780412
  782025
  786069
  788477
  791657
  791676
  793674
  793826
  794623
  795885
  796937
  797606
  799398
  800648
  801398
  801859
  801881
  805106
  805394
  807380
  810655
  814723
  815848
  818465
  818927
  819978
  820534
  820561
  823605
  823977
  824958
  825916
  826017
  826988
  827167
  828398
]
142.39 ms
(37.91%)
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
  73571
  183401
  256371
  384315
  388312
  388322
  398444
  441798
  480593
  490324
  496709
  512217
  545735
  561488
  566459
  567737
  574090
  574524
  579507
  580361
  589604
  590441
  591780
  598592
  613710
  617115
  617968
  621412
  627052
  627961
  628340
  635133
  638949
  650669
  652734
  668023
  670815
  680650
  683679
  689399
  697587
  697763
  698233
  700860
  701059
  703255
  711918
  715291
  715469
  717697
  720900
  724806
  724920
  730967
  732247
  735481
  739186
  740082
  742540
  743188
  744713
  746624
  747273
  748107
  752112
  752912
  753304
  753327
  753405
  754654
  759051
  761918
  763524
  768699
  770729
  770820
  771606
  771873
  773596
  773809
  776823
  777835
  778600
  779132
  780412
  782025
  786069
  788477
  791657
  791676
  793674
  793826
  794623
  795885
  796937
  797606
  799398
  800648
  801398
  801859
  801881
  805106
  805394
  807380
  810655
  814723
  815848
  818465
  818927
  819978
  820534
  820561
  823605
  823977
  824958
  825916
  826017
  826988
  827167
  828398
]
14.26 ms
(3.80%)
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
  759051
  773596
  730967
  746624
  742540
  753405
  795885
  797606
  810655
  73571
  598592
  388312
  398444
  815848
  814723
  818465
  580361
  650669
  680650
  715291
  590441
  617968
  782025
  793826
  788477
  793674
  801881
  724920
  735481
  441798
  388322
  490324
  512217
  561488
  566459
  617115
  621412
  384315
  256371
  183401
  820561
  825916
  826017
  819978
  820534
  823977
  826988
  827167
  818927
  823605
  828398
  824958
  496709
  480593
  545735
  579507
  574090
  683679
  697763
  701059
  668023
  689399
  715469
  720900
  652734
  670815
  698233
  700860
  717697
  567737
  574524
  635133
  638949
  591780
  613710
  627961
  589604
  628340
  777835
  778600
  779132
  780412
  794623
  796937
  799398
  776823
  786069
  791676
  801398
  801859
  805106
  805394
  807380
  791657
  800648
  753304
  753327
  761918
  771606
  743188
  747273
  752112
  754654
  732247
  739186
  763524
  768699
  771873
  724806
  740082
  744713
  748107
  752912
  770729
  770820
  773809
  627052
  697587
  703255
  711918
]
2.24 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy hot"
]
1.80 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy hot"
]
1.69 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy hot"
]
1.61 ms
(0.43%)
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.