Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.54 ms
(85.60%)
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
  397686
  398009
  421762
  421763
  441301
  449472
  450929
  451879
  452737
  452744
  452756
  459090
  464655
  469768
  485220
  493079
  496467
  499911
  507481
  508696
  529124
  536216
  538619
  546850
  550913
  551662
  554846
  558265
  559318
  571946
  587967
  588731
  592066
  600235
  614900
  616312
  617552
  622304
  624649
  627362
  628942
  644883
  647249
  669309
  675159
  678238
  699519
  699543
  703314
  714953
  715779
  716934
  719233
  719972
  720083
  720084
  730341
  732200
  732752
  733594
  734293
  734465
  736112
  738463
  738514
  739887
  740280
  740814
  741266
  742987
  748642
  749303
  757914
  759791
  760278
  761437
  761784
  762525
  762529
  762564
  765386
  767663
  767740
  769057
  772345
  772362
  772364
  772389
  773757
  779946
  780260
  781441
  783830
  783876
  784958
  785299
  786729
  787647
  790558
  790769
  791780
  793971
  795698
  795862
  797174
  797929
  797948
  798619
  799393
  805256
  805258
  808601
  809590
  811027
  813193
  813214
  824336
  825452
  825891
]
15.77 ms
(8.35%)
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
  767663
  767740
  749303
  761437
  614900
  715779
  791780
  811027
  450929
  398009
  785299
  805256
  587967
  742987
  421762
  464655
  529124
  538619
  571946
  554846
  699519
  647249
  703314
  719233
  699543
  714953
  716934
  719972
  622304
  616312
  600235
  783830
  797174
  779946
  797929
  760278
  761784
  769057
  772345
  781441
  738514
  740280
  741266
  762525
  772389
  738463
  757914
  772364
  730341
  732200
  736112
  762529
  765386
  773757
  624649
  720084
  780260
  793971
  798619
  813214
  496467
  825452
  828018
  644883
  536216
  628942
  809590
  787647
  732752
  739887
  452756
  397686
  824336
  783876
  795698
  762564
  813193
  825891
  805258
  627362
  733594
  421763
  441301
  449472
  459090
  485220
  451879
  452737
  469768
  452744
  499911
  507481
  508696
  493079
  546850
  551662
  558265
  550913
  559318
  669309
  675159
  678238
  720083
  592066
  617552
  588731
  790769
  795862
  799393
  808601
  784958
  734465
  740814
  772362
  790558
  797948
  734293
  748642
  759791
  786729
]
4.08 ms
(2.16%)
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
  397686
  398009
  421762
  421763
  441301
  449472
  450929
  451879
  452737
  452744
  452756
  459090
  464655
  469768
  485220
  493079
  496467
  499911
  507481
  508696
  529124
  536216
  538619
  546850
  550913
  551662
  554846
  558265
  559318
  571946
  587967
  588731
  592066
  600235
  614900
  616312
  617552
  622304
  624649
  627362
  628942
  644883
  647249
  669309
  675159
  678238
  699519
  699543
  703314
  714953
  715779
  716934
  719233
  719972
  720083
  720084
  730341
  732200
  732752
  733594
  734293
  734465
  736112
  738463
  738514
  739887
  740280
  740814
  741266
  742987
  748642
  749303
  757914
  759791
  760278
  761437
  761784
  762525
  762529
  762564
  765386
  767663
  767740
  769057
  772345
  772362
  772364
  772389
  773757
  779946
  780260
  781441
  783830
  783876
  784958
  785299
  786729
  787647
  790558
  790769
  791780
  793971
  795698
  795862
  797174
  797929
  797948
  798619
  799393
  805256
  805258
  808601
  809590
  811027
  813193
  813214
  824336
  825452
  825891
]
1.95 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "close up cum"
]
1.90 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "close up cum"
]
1.76 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "close up cum"
]
1.72 ms
(0.91%)
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.