Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.30 ms
(87.27%)
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
  7753
  8347
  152276
  185023
  185044
  185109
  185143
  185296
  185606
  185834
  185855
  205133
  357806
  386178
  386782
  388919
  389157
  389563
  393080
  395136
  395564
  395625
  395720
  397855
  398866
  399595
  401492
  402265
  402906
  404286
  404304
  404412
  405224
  406288
  407507
  407607
  410688
  411132
  411840
  413137
  415702
  417416
  419124
  425430
  430618
  431080
  446248
  446969
  454727
  454939
  456640
  464557
  464955
  465500
  472214
  473836
  474754
  475073
  476328
  482684
  486309
  486923
  492266
  493301
  507129
  513779
  513823
  518740
  520392
  527063
  528823
  534319
  538333
  538358
  542737
  551283
  551298
  551337
  551407
  564631
  564633
  568129
  570900
  572015
  576039
  578218
  589654
  590889
  603736
  608359
  610255
  613496
  614027
  620319
  623327
  628343
  628346
  640616
  661873
  663088
  672554
  682493
  688589
  693643
  698262
  703215
  715853
  720535
  725399
  727684
  727924
  732387
  742304
  771354
  772142
  774761
  798253
  799402
  814758
  814837
]
17.47 ms
(7.89%)
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
  623327
  401492
  798253
  564633
  720535
  152276
  393080
  185109
  446969
  628346
  456640
  672554
  693643
  608359
  386782
  411132
  454939
  8347
  486923
  551337
  688589
  715853
  727924
  405224
  814758
  407607
  564631
  185606
  7753
  771354
  406288
  727684
  492266
  663088
  774761
  486309
  411840
  474754
  518740
  534319
  551298
  551283
  472214
  357806
  507129
  185834
  446248
  386178
  185143
  799402
  402265
  404286
  476328
  682493
  572015
  628343
  185044
  410688
  399595
  576039
  520392
  493301
  703215
  538358
  395136
  570900
  725399
  772142
  185296
  398866
  527063
  473836
  425430
  395625
  613496
  698262
  417416
  430618
  404304
  388919
  413137
  402906
  482684
  464557
  404412
  464955
  640616
  732387
  475073
  465500
  589654
  620319
  578218
  407507
  742304
  513823
  454727
  528823
  205133
  419124
  185855
  814837
  542737
  395720
  568129
  415702
  395564
  590889
  614027
  551407
  513779
  603736
  538333
  661873
  185023
  610255
  389563
  397855
  431080
  389157
]
3.23 ms
(1.46%)
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
  7753
  8347
  152276
  185023
  185044
  185109
  185143
  185296
  185606
  185834
  185855
  205133
  357806
  386178
  386782
  388919
  389157
  389563
  393080
  395136
  395564
  395625
  395720
  397855
  398866
  399595
  401492
  402265
  402906
  404286
  404304
  404412
  405224
  406288
  407507
  407607
  410688
  411132
  411840
  413137
  415702
  417416
  419124
  425430
  430618
  431080
  446248
  446969
  454727
  454939
  456640
  464557
  464955
  465500
  472214
  473836
  474754
  475073
  476328
  482684
  486309
  486923
  492266
  493301
  507129
  513779
  513823
  518740
  520392
  527063
  528823
  534319
  538333
  538358
  542737
  551283
  551298
  551337
  551407
  564631
  564633
  568129
  570900
  572015
  576039
  578218
  589654
  590889
  603736
  608359
  610255
  613496
  614027
  620319
  623327
  628343
  628346
  640616
  661873
  663088
  672554
  682493
  688589
  693643
  698262
  703215
  715853
  720535
  725399
  727684
  727924
  732387
  742304
  771354
  772142
  774761
  798253
  799402
  814758
  814837
]
2.05 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage big"
]
1.90 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж большие"
]
1.65 ms
(0.75%)
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.