Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.44 ms
(87.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
  34645
  80536
  350700
  382957
  390723
  390832
  396013
  397290
  401476
  401479
  406433
  409948
  411555
  415189
  416384
  418421
  419794
  421235
  447529
  449254
  456792
  469675
  470839
  471609
  476366
  479800
  484355
  489110
  489151
  489618
  501720
  501805
  505062
  507165
  508562
  508568
  510043
  516536
  517998
  518032
  519594
  519848
  522014
  524003
  525533
  531471
  533000
  551289
  551292
  551320
  551321
  551384
  551422
  551435
  554777
  558617
  559958
  563796
  566321
  572010
  572016
  573400
  573776
  575730
  576039
  576401
  578478
  591115
  595837
  599433
  601115
  603583
  603736
  607139
  618284
  618883
  624722
  625452
  636520
  640676
  643050
  643731
  651883
  653239
  653247
  653253
  654148
  666321
  669220
  672540
  672547
  672561
  672564
  676576
  679088
  681024
  682493
  701449
  701469
  712726
  737535
  758980
  772188
  774090
  776724
  788602
  789745
  799635
  800066
  801666
  801892
  814511
  815482
  815739
  815751
  815756
  815958
  817028
  818254
  818394
]
15.10 ms
(7.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
  418421
  470839
  643731
  643050
  409948
  701449
  815958
  551292
  653253
  654148
  672540
  651883
  672547
  672561
  551435
  801666
  776724
  789745
  800066
  774090
  799635
  737535
  758980
  401476
  505062
  401479
  551289
  551384
  554777
  558617
  573400
  576039
  551321
  563796
  572016
  575730
  551422
  572010
  653247
  682493
  601115
  591115
  788602
  603583
  625452
  640676
  447529
  508562
  489110
  518032
  489151
  501805
  525533
  533000
  559958
  607139
  471609
  479800
  507165
  519594
  519848
  815756
  681024
  636520
  772188
  603736
  80536
  34645
  421235
  419794
  815751
  676576
  672564
  701469
  350700
  382957
  456792
  390832
  397290
  416384
  476366
  411555
  815482
  624722
  396013
  814511
  484355
  510043
  566321
  573776
  576401
  595837
  599433
  618883
  390723
  469675
  415189
  449254
  406433
  508568
  516536
  501720
  517998
  522014
  489618
  524003
  531471
  818254
  818394
  712726
  817028
  666321
  669220
  618284
  801892
  815739
  551320
  578478
  653239
  679088
]
3.38 ms
(1.65%)
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
  34645
  80536
  350700
  382957
  390723
  390832
  396013
  397290
  401476
  401479
  406433
  409948
  411555
  415189
  416384
  418421
  419794
  421235
  447529
  449254
  456792
  469675
  470839
  471609
  476366
  479800
  484355
  489110
  489151
  489618
  501720
  501805
  505062
  507165
  508562
  508568
  510043
  516536
  517998
  518032
  519594
  519848
  522014
  524003
  525533
  531471
  533000
  551289
  551292
  551320
  551321
  551384
  551422
  551435
  554777
  558617
  559958
  563796
  566321
  572010
  572016
  573400
  573776
  575730
  576039
  576401
  578478
  591115
  595837
  599433
  601115
  603583
  603736
  607139
  618284
  618883
  624722
  625452
  636520
  640676
  643050
  643731
  651883
  653239
  653247
  653253
  654148
  666321
  669220
  672540
  672547
  672561
  672564
  676576
  679088
  681024
  682493
  701449
  701469
  712726
  737535
  758980
  772188
  774090
  776724
  788602
  789745
  799635
  800066
  801666
  801892
  814511
  815482
  815739
  815751
  815756
  815958
  817028
  818254
  818394
]
1.85 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage beauty"
]
1.58 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж beauty"
]
1.41 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "массаж beauty"
]

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.