Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.05 ms
(85.34%)
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
  2808
  191199
  382359
  388228
  390455
  394173
  396048
  396314
  396534
  416020
  421009
  421745
  427432
  428083
  428920
  432381
  441662
  443925
  449894
  453989
  455965
  455978
  456130
  457664
  460396
  460864
  461902
  464035
  464407
  466655
  467119
  469269
  470866
  471654
  472159
  472580
  473334
  474226
  475826
  475839
  478148
  479083
  482326
  485694
  485952
  489169
  490813
  497906
  503020
  507829
  507834
  508705
  510229
  514339
  514657
  516574
  517121
  517617
  517638
  519678
  525130
  525301
  526684
  527842
  528460
  531718
  535050
  535698
  536887
  537122
  538949
  544552
  544752
  545679
  546517
  548907
  549250
  555027
  555203
  555448
  558903
  559441
  560686
  561567
  563827
  568594
  569811
  572287
  572703
  574756
  575302
  578701
  580953
  583572
  584773
  587554
  587619
  588662
  588804
  592388
  596449
  599152
  604644
  606223
  607286
  607697
  621492
  622309
  624986
  665889
  674269
  687506
  690139
  691178
  701554
  719642
  784983
  814992
  827199
]
13.60 ms
(8.66%)
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
  428920
  460396
  473334
  466655
  517617
  510229
  510295
  536887
  517638
  535050
  549250
  558903
  578701
  548907
  559441
  561567
  575302
  544752
  555027
  604644
  607697
  621492
  592388
  588804
  455978
  470866
  471654
  443925
  460864
  514657
  516574
  519678
  527842
  485952
  497906
  507829
  191199
  432381
  441662
  535698
  449894
  453989
  455965
  475826
  456130
  457664
  485694
  464035
  467119
  525301
  517121
  568594
  690139
  665889
  555203
  555448
  572287
  587554
  606223
  587619
  784983
  469269
  382359
  394173
  421745
  474226
  396534
  428083
  396048
  427432
  475839
  421009
  478148
  508705
  526684
  528460
  489169
  514339
  525130
  490813
  827199
  607286
  2808
  537122
  624986
  482326
  388228
  390455
  396314
  416020
  461902
  538949
  472159
  563827
  574756
  674269
  583572
  599152
  596449
  464407
  479083
  507834
  814992
  472580
  503020
  531718
  580953
  544552
  545679
  546517
  560686
  569811
  584773
  691178
  701554
  719642
  687506
  572703
  622309
  588662
]
2.70 ms
(1.72%)
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
  2808
  191199
  382359
  388228
  390455
  394173
  396048
  396314
  396534
  416020
  421009
  421745
  427432
  428083
  428920
  432381
  441662
  443925
  449894
  453989
  455965
  455978
  456130
  457664
  460396
  460864
  461902
  464035
  464407
  466655
  467119
  469269
  470866
  471654
  472159
  472580
  473334
  474226
  475826
  475839
  478148
  479083
  482326
  485694
  485952
  489169
  490813
  497906
  503020
  507829
  507834
  508705
  510229
  514339
  514657
  516574
  517121
  517617
  517638
  519678
  525130
  525301
  526684
  527842
  528460
  531718
  535050
  535698
  536887
  537122
  538949
  544552
  544752
  545679
  546517
  548907
  549250
  555027
  555203
  555448
  558903
  559441
  560686
  561567
  563827
  568594
  569811
  572287
  572703
  574756
  575302
  578701
  580953
  583572
  584773
  587554
  587619
  588662
  588804
  592388
  596449
  599152
  604644
  606223
  607286
  607697
  621492
  622309
  624986
  665889
  674269
  687506
  690139
  691178
  701554
  719642
  784983
  814992
  827199
]
1.87 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин наездниц поз"
]
1.67 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женщин наездниц поз"
]
1.66 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщин сверху"
]
1.53 ms
(0.97%)
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.