Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.04 ms
(83.95%)
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
  182766
  275759
  383217
  386077
  392422
  398121
  398123
  398269
  401642
  403439
  405690
  407398
  413098
  414119
  417430
  418135
  421518
  424606
  430372
  434327
  434330
  434332
  434345
  434350
  440639
  440641
  443250
  448000
  448412
  448898
  450262
  452576
  452829
  452846
  453204
  453997
  454688
  455887
  455914
  456943
  457650
  458527
  458772
  460381
  460382
  460384
  461312
  463621
  466360
  468244
  468255
  468813
  468818
  469054
  469086
  469092
  469125
  469139
  469158
  469162
  469176
  471686
  473873
  475319
  475425
  476051
  476650
  476654
  476670
  476672
  476699
  476710
  478519
  479832
  480351
  481960
  481961
  483658
  486772
  498200
  499914
  502765
  502780
  509776
  509984
  516028
  522579
  531879
  535367
  545677
  555236
  555771
  564040
  564170
  570115
  590806
  593053
  596402
  623277
  630470
  638829
  651700
  652772
  655211
  678964
  704334
  720160
  756105
  756687
  779710
  779720
  779765
  784790
  790461
  790479
  790483
  791484
  800551
  807562
  827633
]
17.05 ms
(10.15%)
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
  827633
  479832
  535367
  476650
  655211
  638829
  386077
  398121
  275759
  480351
  383217
  486772
  452846
  455887
  456943
  531879
  678964
  590806
  779765
  800551
  791484
  756105
  756687
  779710
  784790
  790461
  398269
  182766
  421518
  448412
  502765
  555236
  555771
  652772
  790479
  790483
  779720
  413098
  448898
  469158
  458527
  483658
  476699
  405690
  407398
  476672
  469162
  460382
  476710
  469086
  545677
  651700
  704334
  593053
  623277
  630470
  596402
  401642
  469139
  468244
  498200
  502780
  398123
  516028
  392422
  418135
  453997
  466360
  476670
  452576
  469176
  450262
  475425
  509776
  564040
  570115
  720160
  564170
  807562
  434332
  453204
  460384
  468255
  468813
  469125
  440641
  471686
  476051
  458772
  468818
  473873
  475319
  430372
  434327
  478519
  481961
  509984
  463621
  403439
  476654
  461312
  499914
  414119
  417430
  424606
  434345
  443250
  434330
  434350
  440639
  455914
  469054
  454688
  457650
  460381
  469092
  448000
  452829
  481960
  522579
]
2.69 ms
(1.60%)
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
  182766
  275759
  383217
  386077
  392422
  398121
  398123
  398269
  401642
  403439
  405690
  407398
  413098
  414119
  417430
  418135
  421518
  424606
  430372
  434327
  434330
  434332
  434345
  434350
  440639
  440641
  443250
  448000
  448412
  448898
  450262
  452576
  452829
  452846
  453204
  453997
  454688
  455887
  455914
  456943
  457650
  458527
  458772
  460381
  460382
  460384
  461312
  463621
  466360
  468244
  468255
  468813
  468818
  469054
  469086
  469092
  469125
  469139
  469158
  469162
  469176
  471686
  473873
  475319
  475425
  476051
  476650
  476654
  476670
  476672
  476699
  476710
  478519
  479832
  480351
  481960
  481961
  483658
  486772
  498200
  499914
  502765
  502780
  509776
  509984
  516028
  522579
  531879
  535367
  545677
  555236
  555771
  564040
  564170
  570115
  590806
  593053
  596402
  623277
  630470
  638829
  651700
  652772
  655211
  678964
  704334
  720160
  756105
  756687
  779710
  779720
  779765
  784790
  790461
  790479
  790483
  791484
  800551
  807562
  827633
]
1.96 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен сексмашин"
]
1.89 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен сексмашин"
]
1.78 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife sex machine"
]
1.59 ms
(0.94%)
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.