Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
250.75 ms
(89.21%)
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
  102147
  212183
  383344
  385761
  390492
  392597
  395781
  396510
  408136
  409933
  411004
  411073
  411334
  411343
  411675
  412975
  414761
  415935
  424495
  426238
  426364
  426429
  427152
  430240
  438397
  440689
  443732
  444131
  444848
  445060
  447043
  447513
  447745
  450286
  450935
  453858
  460904
  464440
  464628
  465757
  466046
  467302
  468304
  469225
  470544
  473960
  475532
  475825
  475878
  480912
  482566
  482579
  485062
  491907
  491956
  494823
  499967
  504142
  504823
  508246
  509972
  510351
  513404
  513418
  515621
  516622
  517350
  521793
  522953
  523989
  540490
  543434
  549222
  552652
  552679
  553306
  554951
  560640
  565921
  568053
  568851
  570118
  573127
  573227
  573514
  576685
  578462
  581351
  593002
  606036
  644688
  674632
  675104
  675139
  689808
  698491
  715559
  716375
  719117
  720530
  721721
  727451
  730191
  730396
  736834
  747959
  760418
  760632
  760668
  770883
  777118
  777882
  782773
  785361
  786119
  799387
  800111
  800145
  802755
  803008
]
20.96 ms
(7.46%)
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
  482579
  464628
  516622
  392597
  485062
  453858
  447745
  468304
  411073
  509972
  720530
  411343
  450286
  802755
  212183
  552652
  475532
  414761
  517350
  782773
  800145
  390492
  573514
  411675
  482566
  499967
  444131
  411004
  427152
  560640
  460904
  396510
  573127
  576685
  522953
  513404
  424495
  411334
  508246
  736834
  470544
  469225
  383344
  510351
  606036
  491956
  689808
  409933
  777882
  426364
  466046
  786119
  430240
  543434
  800111
  568053
  573227
  716375
  674632
  747959
  513418
  568851
  412975
  443732
  465757
  415935
  553306
  540490
  554951
  385761
  438397
  504823
  785361
  727451
  565921
  473960
  447513
  444848
  730396
  721721
  426238
  467302
  475878
  570118
  581351
  593002
  803008
  445060
  675104
  675139
  450935
  521793
  494823
  395781
  464440
  715559
  426429
  730191
  644688
  440689
  475825
  102147
  552679
  770883
  523989
  504142
  480912
  578462
  447043
  491907
  408136
  515621
  698491
  719117
  777118
  760418
  760668
  799387
  549222
  760632
]
2.55 ms
(0.91%)
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
  102147
  212183
  383344
  385761
  390492
  392597
  395781
  396510
  408136
  409933
  411004
  411073
  411334
  411343
  411675
  412975
  414761
  415935
  424495
  426238
  426364
  426429
  427152
  430240
  438397
  440689
  443732
  444131
  444848
  445060
  447043
  447513
  447745
  450286
  450935
  453858
  460904
  464440
  464628
  465757
  466046
  467302
  468304
  469225
  470544
  473960
  475532
  475825
  475878
  480912
  482566
  482579
  485062
  491907
  491956
  494823
  499967
  504142
  504823
  508246
  509972
  510351
  513404
  513418
  515621
  516622
  517350
  521793
  522953
  523989
  540490
  543434
  549222
  552652
  552679
  553306
  554951
  560640
  565921
  568053
  568851
  570118
  573127
  573227
  573514
  576685
  578462
  581351
  593002
  606036
  644688
  674632
  675104
  675139
  689808
  698491
  715559
  716375
  719117
  720530
  721721
  727451
  730191
  730396
  736834
  747959
  760418
  760632
  760668
  770883
  777118
  777882
  782773
  785361
  786119
  799387
  800111
  800145
  802755
  803008
]
1.95 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни в трус"
]
1.63 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс в трусик нижн бел"
]
1.33 ms
(0.47%)
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.