Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.03 ms
(83.90%)
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
  341596
  396349
  410934
  420427
  424060
  426416
  426459
  428397
  431262
  434055
  444238
  450239
  451974
  452136
  453841
  456451
  457781
  460733
  462321
  463175
  465336
  465394
  466316
  466994
  468044
  468630
  468717
  470028
  470622
  474643
  475630
  478557
  480290
  482313
  483549
  484706
  485270
  485313
  486569
  494567
  495022
  496934
  499112
  499324
  502283
  502538
  502890
  504456
  505814
  508725
  508860
  511345
  512927
  513607
  514435
  514717
  514980
  516397
  516874
  517033
  518090
  519198
  520005
  520354
  520697
  522013
  524943
  525511
  526052
  527608
  528041
  530808
  531540
  541650
  542747
  545642
  549225
  550434
  553190
  556047
  560497
  562029
  562531
  562832
  562879
  563441
  564203
  567281
  567748
  572711
  576726
  578397
  581809
  584708
  590579
  590628
  591959
  597240
  603002
  603255
  604298
  604478
  605117
  609958
  612434
  612792
  614273
  617212
  621317
  621764
  623716
  625239
  626892
  641127
  643316
  659347
  666405
  666438
  670951
  673589
]
22.05 ms
(11.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
  470028
  428397
  508860
  482313
  513607
  468630
  673589
  560497
  511345
  420427
  520005
  483549
  450239
  556047
  463175
  434055
  581809
  410934
  623716
  341596
  466994
  562832
  670951
  452136
  591959
  465394
  495022
  486569
  431262
  621317
  572711
  502283
  396349
  499324
  518090
  562029
  545642
  468717
  444238
  466316
  524943
  457781
  485270
  496934
  426416
  453841
  505814
  530808
  621764
  626892
  641127
  474643
  480290
  462321
  528041
  502890
  605117
  604298
  549225
  502538
  584708
  520354
  460733
  504456
  484706
  517033
  512927
  465336
  562531
  590628
  516397
  542747
  567748
  478557
  470622
  456451
  666438
  666405
  508725
  550434
  609958
  578397
  485313
  541650
  526052
  527608
  576726
  494567
  516874
  531540
  590579
  426459
  562879
  514980
  520697
  614273
  643316
  617212
  659347
  553190
  563441
  625239
  451974
  567281
  603002
  468044
  424060
  514435
  514717
  612434
  522013
  604478
  603255
  525511
  519198
  499112
  564203
  475630
  597240
  612792
]
2.54 ms
(1.31%)
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
  341596
  396349
  410934
  420427
  424060
  426416
  426459
  428397
  431262
  434055
  444238
  450239
  451974
  452136
  453841
  456451
  457781
  460733
  462321
  463175
  465336
  465394
  466316
  466994
  468044
  468630
  468717
  470028
  470622
  474643
  475630
  478557
  480290
  482313
  483549
  484706
  485270
  485313
  486569
  494567
  495022
  496934
  499112
  499324
  502283
  502538
  502890
  504456
  505814
  508725
  508860
  511345
  512927
  513607
  514435
  514717
  514980
  516397
  516874
  517033
  518090
  519198
  520005
  520354
  520697
  522013
  524943
  525511
  526052
  527608
  528041
  530808
  531540
  541650
  542747
  545642
  549225
  550434
  553190
  556047
  560497
  562029
  562531
  562832
  562879
  563441
  564203
  567281
  567748
  572711
  576726
  578397
  581809
  584708
  590579
  590628
  591959
  597240
  603002
  603255
  604298
  604478
  605117
  609958
  612434
  612792
  614273
  617212
  621317
  621764
  623716
  625239
  626892
  641127
  643316
  659347
  666405
  666438
  670951
  673589
]
1.98 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщина с двумя пиздами"
]
1.72 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин двум вагин"
]
1.37 ms
(0.71%)
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.