Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.61 ms
(80.35%)
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
  384119
  397396
  402357
  418139
  424646
  426220
  430355
  430374
  443333
  446028
  446543
  449234
  450385
  462071
  473778
  478833
  479008
  488224
  492275
  500321
  504592
  505803
  509108
  509163
  511348
  515571
  528385
  531129
  531214
  533010
  535597
  546465
  554104
  557828
  571304
  577638
  579101
  581938
  590788
  590806
  594221
  595605
  599117
  602259
  604364
  605399
  613038
  613172
  615679
  618190
  618921
  621765
  625186
  628377
  632156
  632435
  633780
  633788
  634151
  635900
  637016
  640772
  640789
  640793
  641318
  643100
  650155
  650725
  664532
  668780
  670208
  673093
  673874
  675188
  676455
  681490
  687844
  689542
  693925
  702320
  708301
  710033
  710189
  711860
  720828
  721811
  722627
  722984
  723820
  724698
  726135
  737992
  740854
  741060
  743654
  744790
  747474
  747492
  751422
  755125
  757298
  759648
  760338
  768716
  775043
  778285
  778593
  781485
  785226
  789854
  791097
  791283
  791484
  796384
  800471
  801259
  801316
  802328
  804413
  826874
]
24.58 ms
(14.05%)
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
  759648
  757298
  747474
  710189
  515571
  693925
  643100
  602259
  402357
  664532
  632435
  590806
  800471
  791283
  791484
  796384
  747492
  755125
  804413
  478833
  670208
  571304
  802328
  557828
  579101
  577638
  689542
  778285
  723820
  751422
  632156
  641318
  535597
  640789
  628377
  500321
  397396
  492275
  650725
  687844
  613038
  744790
  710033
  446543
  531129
  633780
  640772
  634151
  676455
  668780
  675188
  722627
  581938
  613172
  618921
  595605
  789854
  741060
  737992
  702320
  711860
  781485
  479008
  511348
  504592
  801316
  640793
  635900
  726135
  450385
  509108
  785226
  740854
  724698
  720828
  462071
  673093
  594221
  778593
  505803
  488224
  599117
  621765
  615679
  426220
  430374
  528385
  650155
  604364
  775043
  743654
  443333
  801259
  424646
  473778
  533010
  531214
  384119
  760338
  554104
  625186
  418139
  826874
  446028
  590788
  430355
  509163
  721811
  791097
  633788
  637016
  449234
  673874
  681490
  708301
  722984
  618190
  768716
  546465
  605399
]
2.68 ms
(1.53%)
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
  384119
  397396
  402357
  418139
  424646
  426220
  430355
  430374
  443333
  446028
  446543
  449234
  450385
  462071
  473778
  478833
  479008
  488224
  492275
  500321
  504592
  505803
  509108
  509163
  511348
  515571
  528385
  531129
  531214
  533010
  535597
  546465
  554104
  557828
  571304
  577638
  579101
  581938
  590788
  590806
  594221
  595605
  599117
  602259
  604364
  605399
  613038
  613172
  615679
  618190
  618921
  621765
  625186
  628377
  632156
  632435
  633780
  633788
  634151
  635900
  637016
  640772
  640789
  640793
  641318
  643100
  650155
  650725
  664532
  668780
  670208
  673093
  673874
  675188
  676455
  681490
  687844
  689542
  693925
  702320
  708301
  710033
  710189
  711860
  720828
  721811
  722627
  722984
  723820
  724698
  726135
  737992
  740854
  741060
  743654
  744790
  747474
  747492
  751422
  755125
  757298
  759648
  760338
  768716
  775043
  778285
  778593
  781485
  785226
  789854
  791097
  791283
  791484
  796384
  800471
  801259
  801316
  802328
  804413
  826874
]
2.34 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оргазм впервые"
]
1.76 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "оргазм вперв"
]
1.39 ms
(0.79%)
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.