Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.60 ms
(85.79%)
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
  73070
  382434
  390040
  390574
  391808
  393789
  401981
  402131
  408940
  409383
  411615
  411690
  413035
  421841
  423056
  423684
  426549
  428769
  429669
  432510
  438329
  438759
  439582
  439599
  439634
  439745
  440345
  442844
  443459
  443635
  446050
  447040
  447276
  449191
  449289
  449677
  449710
  450239
  450442
  453651
  453686
  454444
  455479
  455923
  456432
  456738
  457058
  458285
  458794
  459612
  459826
  460325
  460735
  460810
  460924
  462314
  462335
  462398
  463175
  465074
  466373
  467628
  467749
  469110
  469823
  470019
  470256
  470593
  470607
  471407
  471886
  471959
  472421
  472870
  476007
  476628
  478121
  478293
  478503
  478530
  479487
  481159
  483228
  483371
  485507
  485750
  486268
  486750
  486863
  488164
  490498
  491468
  495817
  497344
  499740
  501425
  503400
  504165
  504365
  506255
  507224
  507717
  508159
  510174
  511308
  511826
  512529
  513583
  514125
  514155
  517258
  519336
  522733
  523597
  525941
  527203
  529171
  530216
  543400
  546626
]
20.50 ms
(9.90%)
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
  462398
  511826
  530216
  449191
  470593
  453686
  499740
  503400
  488164
  497344
  413035
  459826
  511308
  391808
  443459
  411690
  438759
  447040
  465074
  458794
  479487
  470607
  486750
  490498
  527203
  472870
  543400
  453651
  456738
  466373
  450442
  472421
  438329
  401981
  409383
  411615
  478121
  442844
  523597
  485750
  529171
  483228
  449289
  476628
  439745
  467749
  501425
  517258
  504365
  73070
  408940
  446050
  504165
  457058
  460325
  514125
  393789
  423684
  510174
  426549
  478503
  460810
  456432
  462335
  449710
  507224
  513583
  439582
  455479
  454444
  450239
  459612
  491468
  486268
  519336
  481159
  382434
  402131
  423056
  462314
  463175
  470019
  439634
  469110
  470256
  471959
  421841
  439599
  460924
  512529
  507717
  483371
  522733
  443635
  471886
  485507
  449677
  390040
  486863
  432510
  440345
  455923
  469823
  525941
  476007
  508159
  478530
  460735
  390574
  428769
  429669
  447276
  506255
  514155
  495817
  546626
  471407
  458285
  467628
  478293
]
2.49 ms
(1.20%)
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
  73070
  382434
  390040
  390574
  391808
  393789
  401981
  402131
  408940
  409383
  411615
  411690
  413035
  421841
  423056
  423684
  426549
  428769
  429669
  432510
  438329
  438759
  439582
  439599
  439634
  439745
  440345
  442844
  443459
  443635
  446050
  447040
  447276
  449191
  449289
  449677
  449710
  450239
  450442
  453651
  453686
  454444
  455479
  455923
  456432
  456738
  457058
  458285
  458794
  459612
  459826
  460325
  460735
  460810
  460924
  462314
  462335
  462398
  463175
  465074
  466373
  467628
  467749
  469110
  469823
  470019
  470256
  470593
  470607
  471407
  471886
  471959
  472421
  472870
  476007
  476628
  478121
  478293
  478503
  478530
  479487
  481159
  483228
  483371
  485507
  485750
  486268
  486750
  486863
  488164
  490498
  491468
  495817
  497344
  499740
  501425
  503400
  504165
  504365
  506255
  507224
  507717
  508159
  510174
  511308
  511826
  512529
  513583
  514125
  514155
  517258
  519336
  522733
  523597
  525941
  527203
  529171
  530216
  543400
  546626
]
1.96 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в ротик жене"
]
1.65 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в ротик жен"
]
1.28 ms
(0.62%)
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.