Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
247.98 ms
(90.23%)
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
  146112
  357595
  381853
  382569
  382724
  382971
  383390
  388722
  388785
  398769
  405859
  407637
  407769
  411540
  411630
  411926
  412985
  413461
  414038
  431762
  451445
  454253
  454259
  455026
  456897
  459919
  462101
  462106
  462562
  464325
  464917
  465363
  466069
  466792
  466979
  466997
  467240
  469336
  471062
  472151
  472593
  474382
  474399
  474818
  474833
  474870
  475220
  476257
  476260
  476353
  476856
  479063
  480731
  483139
  484379
  485706
  485714
  485725
  485727
  485733
  486821
  487338
  488308
  496524
  496552
  498300
  502025
  502030
  502932
  505642
  506847
  513833
  514335
  518874
  518875
  519145
  519705
  520141
  521131
  523367
  524882
  529390
  531531
  544464
  549583
  549880
  554519
  558295
  559328
  563431
  565578
  580884
  592951
  593532
  593535
  601904
  665254
  666163
  666811
  667319
  667320
  667486
  667850
  707282
  712806
  712825
  716254
  716470
  723377
  726591
  731193
  743406
  744987
  781667
  781729
  810773
  810775
  814125
  817406
  818656
]
17.42 ms
(6.34%)
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
  520141
  523367
  514335
  531531
  474382
  558295
  723377
  744987
  743406
  726591
  398769
  474833
  357595
  464325
  467240
  476353
  474399
  411540
  485706
  502932
  518874
  554519
  462101
  476856
  466069
  814125
  549880
  707282
  712825
  466979
  474818
  488308
  524882
  382724
  405859
  411926
  407637
  412985
  413461
  454253
  456897
  469336
  472151
  474870
  502025
  496524
  475220
  479063
  559328
  544464
  563431
  666811
  667320
  593535
  810773
  381853
  462106
  388785
  454259
  465363
  383390
  455026
  462562
  388722
  472593
  480731
  471062
  519705
  485714
  485725
  486821
  487338
  513833
  484379
  817406
  781667
  712806
  529390
  601904
  464917
  521131
  818656
  665254
  716470
  666163
  667319
  667850
  781729
  731193
  716254
  146112
  382569
  382971
  407769
  411630
  414038
  431762
  476257
  483139
  485727
  466792
  476260
  485733
  502030
  506847
  518875
  519145
  498300
  505642
  496552
  459919
  466997
  549583
  565578
  580884
  667486
  592951
  593532
  810775
  451445
]
3.09 ms
(1.12%)
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
  146112
  357595
  381853
  382569
  382724
  382971
  383390
  388722
  388785
  398769
  405859
  407637
  407769
  411540
  411630
  411926
  412985
  413461
  414038
  431762
  451445
  454253
  454259
  455026
  456897
  459919
  462101
  462106
  462562
  464325
  464917
  465363
  466069
  466792
  466979
  466997
  467240
  469336
  471062
  472151
  472593
  474382
  474399
  474818
  474833
  474870
  475220
  476257
  476260
  476353
  476856
  479063
  480731
  483139
  484379
  485706
  485714
  485725
  485727
  485733
  486821
  487338
  488308
  496524
  496552
  498300
  502025
  502030
  502932
  505642
  506847
  513833
  514335
  518874
  518875
  519145
  519705
  520141
  521131
  523367
  524882
  529390
  531531
  544464
  549583
  549880
  554519
  558295
  559328
  563431
  565578
  580884
  592951
  593532
  593535
  601904
  665254
  666163
  666811
  667319
  667320
  667486
  667850
  707282
  712806
  712825
  716254
  716470
  723377
  726591
  731193
  743406
  744987
  781667
  781729
  810773
  810775
  814125
  817406
  818656
]
1.97 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старые бабки"
]
1.58 ms
(0.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старые бабушк"
]
1.47 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.49%)
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.