Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.59 ms
(84.89%)
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
  155257
  234690
  352189
  370829
  393435
  424248
  424660
  430002
  435551
  440639
  446002
  449428
  460293
  468072
  468238
  469128
  472864
  473426
  474441
  479351
  479474
  480477
  481961
  485966
  486810
  496334
  504509
  506458
  509800
  511277
  512543
  513962
  514877
  515546
  521261
  523881
  529293
  529795
  529799
  531789
  532817
  534586
  537572
  537848
  538760
  545328
  546422
  546838
  547426
  547480
  547483
  547486
  547489
  548957
  554487
  554571
  554919
  555258
  555329
  555387
  555389
  555752
  558176
  558494
  559355
  561034
  561036
  562784
  565119
  573270
  576545
  576943
  578493
  581006
  590498
  591003
  592461
  595438
  599906
  603616
  604109
  605906
  621964
  624229
  624794
  625181
  625521
  628055
  629281
  641924
  646329
  650305
  654174
  660385
  666869
  668559
  669270
  671584
  671713
  676303
  680423
  700975
  713876
  717873
  720719
  725739
  761946
  776726
  777094
  781457
  797339
  801430
  815199
  816067
  817288
  817581
  818387
  819571
  820793
  823354
]
15.00 ms
(8.51%)
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
  629281
  777094
  797339
  155257
  352189
  479351
  480477
  460293
  469128
  481961
  506458
  511277
  521261
  595438
  725739
  537572
  473426
  370829
  446002
  430002
  504509
  554919
  646329
  669270
  641924
  776726
  761946
  538760
  650305
  548957
  801430
  424660
  449428
  468072
  509800
  817581
  820793
  823354
  554487
  624794
  628055
  781457
  558176
  513962
  529293
  234690
  393435
  435551
  424248
  440639
  668559
  816067
  818387
  815199
  819571
  817288
  486810
  472864
  485966
  529795
  532817
  537848
  523881
  529799
  534586
  515546
  496334
  512543
  514877
  531789
  468238
  474441
  479474
  546838
  547486
  555389
  562784
  573270
  576943
  578493
  581006
  545328
  546422
  547483
  547489
  547426
  547480
  554571
  555329
  555387
  555752
  559355
  561034
  561036
  565119
  671584
  700975
  660385
  666869
  680423
  713876
  717873
  720719
  654174
  671713
  676303
  555258
  558494
  576545
  591003
  592461
  599906
  624229
  625521
  603616
  621964
  590498
  604109
  605906
  625181
]
4.56 ms
(2.59%)
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
  155257
  234690
  352189
  370829
  393435
  424248
  424660
  430002
  435551
  440639
  446002
  449428
  460293
  468072
  468238
  469128
  472864
  473426
  474441
  479351
  479474
  480477
  481961
  485966
  486810
  496334
  504509
  506458
  509800
  511277
  512543
  513962
  514877
  515546
  521261
  523881
  529293
  529795
  529799
  531789
  532817
  534586
  537572
  537848
  538760
  545328
  546422
  546838
  547426
  547480
  547483
  547486
  547489
  548957
  554487
  554571
  554919
  555258
  555329
  555387
  555389
  555752
  558176
  558494
  559355
  561034
  561036
  562784
  565119
  573270
  576545
  576943
  578493
  581006
  590498
  591003
  592461
  595438
  599906
  603616
  604109
  605906
  621964
  624229
  624794
  625181
  625521
  628055
  629281
  641924
  646329
  650305
  654174
  660385
  666869
  668559
  669270
  671584
  671713
  676303
  680423
  700975
  713876
  717873
  720719
  725739
  761946
  776726
  777094
  781457
  797339
  801430
  815199
  816067
  817288
  817581
  818387
  819571
  820793
  823354
]
1.96 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скачать мастурбация зрелых"
]
1.83 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скача мастурбац зрелая женщин"
]
1.75 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.86%)
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.