Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.01 ms
(84.21%)
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
  390139
  391943
  392600
  409938
  411353
  439638
  439767
  440693
  444144
  452940
  454193
  454517
  455132
  457417
  457434
  460143
  460406
  460476
  460585
  460601
  460900
  462290
  462489
  462536
  463790
  465375
  466151
  466279
  466495
  468497
  469347
  469427
  470225
  470920
  471055
  472609
  474480
  477934
  477966
  477967
  479124
  481199
  481254
  484577
  485821
  485921
  486209
  488431
  489225
  491104
  495562
  497343
  506466
  506860
  507245
  508253
  508382
  509437
  511057
  513632
  513670
  516478
  519361
  520904
  521134
  523674
  524780
  536433
  555103
  556519
  556901
  564549
  578815
  583097
  620228
  620258
  628661
  644861
  666361
  672903
  697249
  712563
  714459
  714474
  714484
  725170
  728170
  733251
  733371
  733661
  734487
  735929
  735974
  737015
  740826
  741759
  741772
  741777
  741778
  741781
  741788
  742349
  742352
  743780
  746604
  754649
  757541
  758509
  759849
  762274
  777727
  784315
  789570
  789748
  793186
  807353
  816177
  817293
  825585
  827973
]
15.21 ms
(8.96%)
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
  477967
  497343
  488431
  644861
  789570
  793186
  746604
  735974
  789748
  513670
  506466
  513632
  697249
  628661
  481254
  523674
  470225
  460143
  454193
  460476
  470920
  462536
  479124
  481199
  460406
  444144
  466495
  511057
  491104
  524780
  439638
  460900
  486209
  817293
  508253
  666361
  578815
  734487
  743780
  728170
  737015
  714474
  519361
  484577
  471055
  455132
  495562
  409938
  825585
  454517
  556519
  807353
  777727
  733371
  758509
  759849
  733251
  740826
  468497
  465375
  536433
  520904
  742352
  440693
  521134
  466151
  564549
  733661
  411353
  462290
  462489
  452940
  460601
  466279
  516478
  472609
  489225
  469427
  477934
  762274
  827973
  714484
  555103
  714459
  485921
  474480
  457434
  485821
  509437
  784315
  463790
  507245
  439767
  390139
  672903
  712563
  556901
  620258
  620228
  741772
  741777
  741778
  741788
  735929
  725170
  742349
  741781
  757541
  741759
  508382
  816177
  754649
  392600
  460585
  583097
  477966
  457417
  391943
  469347
  506860
]
3.64 ms
(2.14%)
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
  390139
  391943
  392600
  409938
  411353
  439638
  439767
  440693
  444144
  452940
  454193
  454517
  455132
  457417
  457434
  460143
  460406
  460476
  460585
  460601
  460900
  462290
  462489
  462536
  463790
  465375
  466151
  466279
  466495
  468497
  469347
  469427
  470225
  470920
  471055
  472609
  474480
  477934
  477966
  477967
  479124
  481199
  481254
  484577
  485821
  485921
  486209
  488431
  489225
  491104
  495562
  497343
  506466
  506860
  507245
  508253
  508382
  509437
  511057
  513632
  513670
  516478
  519361
  520904
  521134
  523674
  524780
  536433
  555103
  556519
  556901
  564549
  578815
  583097
  620228
  620258
  628661
  644861
  666361
  672903
  697249
  712563
  714459
  714474
  714484
  725170
  728170
  733251
  733371
  733661
  734487
  735929
  735974
  737015
  740826
  741759
  741772
  741777
  741778
  741781
  741788
  742349
  742352
  743780
  746604
  754649
  757541
  758509
  759849
  762274
  777727
  784315
  789570
  789748
  793186
  807353
  816177
  817293
  825585
  827973
]
2.42 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее зрелая русск…"
]
2.03 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск зрелая женщин русск"
]
1.80 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.00%)
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.