Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.66 ms
(79.94%)
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
  44998
  118109
  145335
  151014
  186948
  311237
  382591
  384143
  385007
  388037
  390303
  391075
  393087
  397217
  405124
  406574
  407288
  407707
  408175
  409184
  409882
  411941
  411971
  425646
  439490
  443704
  451877
  453300
  453716
  465214
  465840
  470995
  473806
  474122
  474528
  482987
  484612
  486192
  489138
  490409
  493224
  505813
  541618
  544506
  549247
  557340
  560079
  561759
  573231
  589551
  601599
  613470
  620126
  641671
  642371
  645600
  645822
  647682
  668743
  689699
  696308
  703062
  703556
  707318
  707418
  710592
  716055
  717689
  718576
  721822
  722127
  724194
  724283
  724302
  725576
  726786
  727757
  727814
  730076
  733079
  733097
  733098
  733380
  734730
  736295
  737522
  740185
  741437
  742656
  744575
  747468
  748246
  750554
  756216
  758432
  761557
  770888
  786537
  789659
  790640
  790978
  795143
  801396
  802337
  802453
  804030
  804681
  805526
  806239
  807636
  811490
  814794
  815804
  815806
  816502
  817269
  818450
  819151
  820052
  823566
]
23.38 ms
(13.10%)
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
  388037
  823566
  722127
  804030
  726786
  740185
  725576
  744575
  804681
  186948
  484612
  790978
  727757
  397217
  814794
  758432
  721822
  717689
  384143
  815806
  817269
  818450
  645600
  589551
  620126
  642371
  601599
  786537
  761557
  811490
  724194
  756216
  805526
  390303
  407707
  411941
  489138
  816502
  703062
  573231
  385007
  439490
  465840
  770888
  647682
  561759
  482987
  696308
  710592
  453300
  741437
  807636
  44998
  549247
  151014
  802453
  493224
  411971
  409882
  465214
  405124
  425646
  443704
  391075
  748246
  490409
  145335
  409184
  557340
  311237
  819151
  541618
  707318
  689699
  703556
  795143
  801396
  474122
  473806
  645822
  747468
  486192
  544506
  406574
  407288
  474528
  733079
  451877
  806239
  641671
  820052
  815804
  453716
  668743
  718576
  802337
  707418
  724283
  505813
  742656
  736295
  727814
  733097
  733098
  393087
  382591
  470995
  118109
  560079
  716055
  789659
  790640
  750554
  737522
  724302
  730076
  733380
  734730
  408175
  613470
]
3.12 ms
(1.75%)
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
  44998
  118109
  145335
  151014
  186948
  311237
  382591
  384143
  385007
  388037
  390303
  391075
  393087
  397217
  405124
  406574
  407288
  407707
  408175
  409184
  409882
  411941
  411971
  425646
  439490
  443704
  451877
  453300
  453716
  465214
  465840
  470995
  473806
  474122
  474528
  482987
  484612
  486192
  489138
  490409
  493224
  505813
  541618
  544506
  549247
  557340
  560079
  561759
  573231
  589551
  601599
  613470
  620126
  641671
  642371
  645600
  645822
  647682
  668743
  689699
  696308
  703062
  703556
  707318
  707418
  710592
  716055
  717689
  718576
  721822
  722127
  724194
  724283
  724302
  725576
  726786
  727757
  727814
  730076
  733079
  733097
  733098
  733380
  734730
  736295
  737522
  740185
  741437
  742656
  744575
  747468
  748246
  750554
  756216
  758432
  761557
  770888
  786537
  789659
  790640
  790978
  795143
  801396
  802337
  802453
  804030
  804681
  805526
  806239
  807636
  811490
  814794
  815804
  815806
  816502
  817269
  818450
  819151
  820052
  823566
]
3.01 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "матюры куни"
]
2.54 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин куннилингус оральн секс"
]
1.84 ms
(1.03%)
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.