Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.57 ms
(86.19%)
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
  246506
  357782
  382234
  383818
  386357
  390178
  420032
  422233
  422252
  428961
  434281
  441005
  447350
  447476
  447548
  447562
  457018
  457953
  458778
  461696
  462673
  466219
  466940
  467273
  469675
  471347
  471916
  476366
  481284
  487010
  487712
  490790
  492197
  499444
  501720
  501732
  501749
  501760
  501799
  503064
  503215
  503887
  505042
  509675
  509780
  510362
  513072
  513396
  516536
  516542
  519841
  521888
  524003
  524380
  528066
  545809
  551419
  552232
  554146
  568081
  568369
  573776
  576014
  576280
  576379
  576381
  576384
  576401
  595493
  595516
  595519
  596618
  596629
  597503
  598087
  598774
  599433
  600403
  601313
  602725
  604116
  609731
  609896
  610183
  637037
  641711
  651924
  653239
  653248
  653254
  653516
  660522
  660959
  663536
  665645
  672475
  672485
  672486
  672564
  676927
  677006
  677029
  677400
  679088
  681525
  716127
  720985
  721225
  721408
  721447
  722820
  735625
  753343
  755587
  767504
  770579
  790569
  795696
  799778
  813419
]
15.13 ms
(7.93%)
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
  447476
  503215
  513396
  672485
  596629
  458778
  357782
  422252
  501799
  595519
  610183
  469675
  641711
  596618
  576401
  447350
  447548
  501720
  524003
  595493
  672564
  722820
  767504
  509780
  602725
  573776
  637037
  653239
  679088
  653516
  499444
  382234
  813419
  568081
  599433
  516536
  653248
  545809
  246506
  462673
  466940
  665645
  501732
  598087
  598774
  487712
  501760
  521888
  528066
  481284
  476366
  390178
  677006
  663536
  490790
  576384
  441005
  519841
  721447
  428961
  386357
  509675
  466219
  516542
  551419
  720985
  721408
  660522
  799778
  492197
  554146
  651924
  677029
  576014
  601313
  434281
  383818
  420032
  721225
  576280
  677400
  568369
  609896
  524380
  457018
  487010
  600403
  597503
  576381
  503887
  753343
  672486
  672475
  609731
  471347
  457953
  447562
  501749
  676927
  461696
  505042
  576379
  660959
  716127
  755587
  653254
  595516
  422233
  513072
  790569
  795696
  735625
  604116
  503064
  510362
  681525
  770579
  471916
  552232
  467273
]
4.30 ms
(2.25%)
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
  246506
  357782
  382234
  383818
  386357
  390178
  420032
  422233
  422252
  428961
  434281
  441005
  447350
  447476
  447548
  447562
  457018
  457953
  458778
  461696
  462673
  466219
  466940
  467273
  469675
  471347
  471916
  476366
  481284
  487010
  487712
  490790
  492197
  499444
  501720
  501732
  501749
  501760
  501799
  503064
  503215
  503887
  505042
  509675
  509780
  510362
  513072
  513396
  516536
  516542
  519841
  521888
  524003
  524380
  528066
  545809
  551419
  552232
  554146
  568081
  568369
  573776
  576014
  576280
  576379
  576381
  576384
  576401
  595493
  595516
  595519
  596618
  596629
  597503
  598087
  598774
  599433
  600403
  601313
  602725
  604116
  609731
  609896
  610183
  637037
  641711
  651924
  653239
  653248
  653254
  653516
  660522
  660959
  663536
  665645
  672475
  672485
  672486
  672564
  676927
  677006
  677029
  677400
  679088
  681525
  716127
  720985
  721225
  721408
  721447
  722820
  735625
  753343
  755587
  767504
  770579
  790569
  795696
  799778
  813419
]
2.10 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian massage girl"
]
1.71 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск массаж девушк"
]
1.60 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.80%)
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.