Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.97 ms
(84.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
  414212
  423498
  424679
  426632
  426911
  434491
  441110
  448078
  456215
  456333
  456743
  456818
  460209
  470087
  476652
  481357
  481920
  482573
  482616
  484023
  486969
  487422
  487768
  497904
  499042
  500146
  500494
  507780
  507945
  508989
  509066
  512766
  514088
  514147
  516985
  521211
  522521
  525869
  526233
  529870
  531574
  533056
  533118
  534466
  534928
  535076
  535606
  538269
  538919
  539131
  539788
  542347
  542386
  542391
  543657
  544783
  544869
  546252
  550557
  558620
  565890
  567223
  574431
  575596
  576131
  576556
  576901
  577023
  579851
  582728
  588048
  588798
  593003
  593843
  598859
  601472
  615658
  618531
  620843
  622746
  634850
  637486
  647003
  683012
  686271
  687021
  697494
  700895
  704180
  704955
  719829
  726241
  728482
  729666
  731444
  732816
  747597
  751411
  751437
  754424
  754700
  755237
  763276
  764034
  765356
  765752
  767033
  775587
  779468
  787820
  796727
  796734
  810582
  813253
  817101
  825516
  825762
  826863
  827308
  827488
]
12.93 ms
(8.58%)
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
  817101
  826863
  827308
  827488
  825516
  476652
  487422
  516985
  535606
  538919
  499042
  500494
  509066
  539131
  577023
  542347
  546252
  550557
  574431
  719829
  576556
  593843
  634850
  622746
  618531
  775587
  796727
  732816
  751437
  754424
  767033
  728482
  731444
  754700
  726241
  755237
  765356
  729666
  751411
  763276
  779468
  787820
  810582
  426632
  487768
  434491
  456743
  470087
  514147
  567223
  576901
  582728
  601472
  588048
  813253
  500146
  526233
  484023
  508989
  514088
  507945
  796734
  481920
  764034
  423498
  448078
  529870
  531574
  544783
  647003
  576131
  588798
  426911
  507780
  414212
  441110
  424679
  825762
  456818
  456215
  460209
  579851
  542386
  558620
  593003
  615658
  765752
  456333
  486969
  522521
  497904
  598859
  535076
  512766
  747597
  482573
  482616
  481357
  521211
  534466
  538269
  525869
  533118
  534928
  539788
  533056
  542391
  543657
  544869
  575596
  565890
  700895
  683012
  686271
  687021
  704180
  697494
  704955
  620843
  637486
]
3.33 ms
(2.21%)
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
  414212
  423498
  424679
  426632
  426911
  434491
  441110
  448078
  456215
  456333
  456743
  456818
  460209
  470087
  476652
  481357
  481920
  482573
  482616
  484023
  486969
  487422
  487768
  497904
  499042
  500146
  500494
  507780
  507945
  508989
  509066
  512766
  514088
  514147
  516985
  521211
  522521
  525869
  526233
  529870
  531574
  533056
  533118
  534466
  534928
  535076
  535606
  538269
  538919
  539131
  539788
  542347
  542386
  542391
  543657
  544783
  544869
  546252
  550557
  558620
  565890
  567223
  574431
  575596
  576131
  576556
  576901
  577023
  579851
  582728
  588048
  588798
  593003
  593843
  598859
  601472
  615658
  618531
  620843
  622746
  634850
  637486
  647003
  683012
  686271
  687021
  697494
  700895
  704180
  704955
  719829
  726241
  728482
  729666
  731444
  732816
  747597
  751411
  751437
  754424
  754700
  755237
  763276
  764034
  765356
  765752
  767033
  775587
  779468
  787820
  796727
  796734
  810582
  813253
  817101
  825516
  825762
  826863
  827308
  827488
]
2.19 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее частное бдсм…"
]
1.80 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск любительск бдсм"
]
1.77 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.