Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.96 ms
(86.01%)
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
  233622
  388542
  391873
  396312
  409651
  414753
  432358
  441577
  452789
  457309
  464809
  477942
  490664
  492468
  495641
  495707
  497853
  498171
  507921
  510008
  510326
  523889
  527981
  530259
  533111
  534402
  534827
  535277
  535801
  535865
  536015
  538159
  538521
  539213
  539650
  541335
  544943
  545170
  545599
  545810
  546335
  546849
  547653
  547711
  548082
  552690
  552726
  552727
  556088
  556993
  557726
  557910
  559105
  560342
  562751
  565622
  566258
  567656
  568962
  569496
  572714
  572896
  574146
  574390
  574970
  575342
  575575
  576494
  577272
  577653
  577655
  578572
  580748
  581038
  581186
  582036
  583598
  584183
  588794
  588937
  591087
  591568
  591857
  593566
  595619
  596427
  601413
  603787
  606757
  617882
  618430
  618599
  627252
  627552
  628349
  630554
  631483
  631563
  634326
  637176
  637494
  641560
  647911
  650867
  652752
  653885
  655558
  662865
  667025
  679618
  680650
  691171
  693364
  713226
  727611
  733672
  753462
  758868
  775445
  784722
]
14.61 ms
(8.27%)
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
  490664
  536015
  539213
  533111
  538159
  530259
  464809
  545810
  552726
  557726
  560342
  566258
  574970
  581186
  541335
  545599
  574390
  575342
  582036
  568962
  679618
  653885
  680650
  691171
  545170
  556088
  576494
  577272
  577655
  584183
  601413
  603787
  618430
  627552
  631483
  637176
  588937
  591857
  617882
  634326
  775445
  627252
  713226
  784722
  233622
  388542
  495641
  498171
  527981
  567656
  662865
  546849
  753462
  628349
  409651
  457309
  574146
  581038
  693364
  569496
  583598
  595619
  606757
  637494
  591568
  452789
  477942
  510008
  539650
  535801
  535865
  497853
  534402
  510326
  575575
  544943
  547653
  580748
  652752
  647911
  548082
  556993
  565622
  596427
  618599
  593566
  588794
  591087
  630554
  631563
  641560
  727611
  758868
  733672
  432358
  391873
  414753
  492468
  396312
  441577
  495707
  507921
  538521
  523889
  534827
  535277
  547711
  557910
  562751
  572896
  546335
  572714
  552690
  552727
  559105
  577653
  578572
  667025
  650867
  655558
]
3.03 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
  233622
  388542
  391873
  396312
  409651
  414753
  432358
  441577
  452789
  457309
  464809
  477942
  490664
  492468
  495641
  495707
  497853
  498171
  507921
  510008
  510326
  523889
  527981
  530259
  533111
  534402
  534827
  535277
  535801
  535865
  536015
  538159
  538521
  539213
  539650
  541335
  544943
  545170
  545599
  545810
  546335
  546849
  547653
  547711
  548082
  552690
  552726
  552727
  556088
  556993
  557726
  557910
  559105
  560342
  562751
  565622
  566258
  567656
  568962
  569496
  572714
  572896
  574146
  574390
  574970
  575342
  575575
  576494
  577272
  577653
  577655
  578572
  580748
  581038
  581186
  582036
  583598
  584183
  588794
  588937
  591087
  591568
  591857
  593566
  595619
  596427
  601413
  603787
  606757
  617882
  618430
  618599
  627252
  627552
  628349
  630554
  631483
  631563
  634326
  637176
  637494
  641560
  647911
  650867
  652752
  653885
  655558
  662865
  667025
  679618
  680650
  691171
  693364
  713226
  727611
  733672
  753462
  758868
  775445
  784722
]
1.89 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "telephone sex"
]
1.88 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "телефон секс"
]
1.47 ms
(0.83%)
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.