Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.67 ms
(52.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl bondage"
]
169.41 ms
(42.02%)
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
  395756
  410640
  413707
  414799
  417427
  422567
  422572
  422705
  423503
  425494
  426623
  426629
  427141
  429568
  431671
  443312
  447093
  448355
  453746
  464265
  464913
  468462
  468828
  475720
  476130
  477048
  477347
  478474
  479600
  480774
  491406
  491689
  492341
  493194
  496237
  497005
  497014
  498295
  499207
  500110
  500391
  506783
  508852
  510612
  511259
  511755
  512828
  514792
  515511
  516245
  516619
  516777
  517100
  519719
  520732
  521062
  521287
  522028
  522565
  524421
  526478
  532483
  535261
  539894
  542042
  543863
  545675
  546326
  546803
  547730
  548650
  549391
  549922
  550051
  550681
  550684
  551063
  551902
  551903
  554082
  557439
  558819
  558958
  559195
  560488
  565174
  565246
  565813
  565839
  567725
  572690
  573230
  573265
  574503
  575080
  575115
  575141
  575791
  576060
  577332
  579851
  585190
  590481
  597120
  598624
  599752
  604849
  612315
  619204
  623860
  624229
  705907
  720416
  762664
  765891
  779610
  788920
  814038
  815208
  825762
]
14.84 ms
(3.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
  548650
  560488
  575141
  575080
  576060
  565839
  623860
  765891
  431671
  479600
  477048
  426623
  519719
  508852
  516777
  498295
  512828
  516245
  522565
  565246
  579851
  425494
  426629
  427141
  443312
  413707
  814038
  448355
  475720
  476130
  511259
  524421
  535261
  539894
  464913
  478474
  480774
  545675
  554082
  573265
  557439
  574503
  550681
  565813
  720416
  551903
  604849
  585190
  597120
  705907
  414799
  514792
  500391
  521062
  526478
  496237
  511755
  521287
  497005
  516619
  532483
  546803
  549922
  549391
  598624
  624229
  612315
  779610
  762664
  447093
  453746
  477347
  492341
  517100
  825762
  410640
  429568
  815208
  468828
  515511
  499207
  506783
  558819
  551902
  573230
  551063
  619204
  788920
  468462
  520732
  567725
  590481
  550051
  575115
  575791
  493194
  565174
  542042
  464265
  491689
  423503
  491406
  417427
  547730
  558958
  577332
  510612
  500110
  522028
  550684
  543863
  422705
  599752
  497014
  395756
  546326
  572690
  422572
  559195
  422567
]
2.74 ms
(0.68%)
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
  395756
  410640
  413707
  414799
  417427
  422567
  422572
  422705
  423503
  425494
  426623
  426629
  427141
  429568
  431671
  443312
  447093
  448355
  453746
  464265
  464913
  468462
  468828
  475720
  476130
  477048
  477347
  478474
  479600
  480774
  491406
  491689
  492341
  493194
  496237
  497005
  497014
  498295
  499207
  500110
  500391
  506783
  508852
  510612
  511259
  511755
  512828
  514792
  515511
  516245
  516619
  516777
  517100
  519719
  520732
  521062
  521287
  522028
  522565
  524421
  526478
  532483
  535261
  539894
  542042
  543863
  545675
  546326
  546803
  547730
  548650
  549391
  549922
  550051
  550681
  550684
  551063
  551902
  551903
  554082
  557439
  558819
  558958
  559195
  560488
  565174
  565246
  565813
  565839
  567725
  572690
  573230
  573265
  574503
  575080
  575115
  575141
  575791
  576060
  577332
  579851
  585190
  590481
  597120
  598624
  599752
  604849
  612315
  619204
  623860
  624229
  705907
  720416
  762664
  765891
  779610
  788920
  814038
  815208
  825762
]
1.66 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк бдсм"
]
1.51 ms
(0.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.