Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.82 ms
(85.67%)
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
  239112
  323088
  384810
  388434
  395862
  397111
  397530
  399700
  399739
  399824
  402008
  407168
  410090
  410218
  413889
  416332
  424364
  425028
  425784
  431022
  433212
  433231
  445248
  446084
  446105
  446906
  447835
  448832
  449362
  451893
  464378
  467614
  471494
  472124
  474120
  475033
  478084
  481581
  483392
  486596
  487435
  492267
  492605
  493420
  494266
  497923
  499498
  501226
  505023
  505041
  509879
  511239
  512263
  512821
  514700
  514841
  517865
  520347
  520639
  521907
  522883
  523859
  523863
  524897
  525704
  525866
  528571
  531072
  550681
  554004
  559029
  559766
  560113
  560462
  561816
  565061
  565163
  565395
  565539
  567159
  571629
  574538
  575722
  576024
  576043
  576412
  581821
  584711
  587901
  590866
  593343
  593743
  596990
  598122
  598386
  603536
  603663
  609276
  614739
  622005
  622229
  644636
  649150
  652263
  672584
  716298
  721738
  721795
  725409
  726589
  745939
  746889
  763313
  770278
  802109
  810685
  815982
  818447
  823242
  827940
]
16.99 ms
(9.05%)
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
  425784
  492605
  565539
  567159
  481581
  593743
  399824
  560113
  523859
  413889
  517865
  475033
  433231
  514841
  399700
  483392
  388434
  565395
  559029
  448832
  581821
  523863
  522883
  802109
  512263
  576043
  472124
  501226
  416332
  565163
  486596
  745939
  598386
  449362
  431022
  487435
  397530
  402008
  499498
  445248
  576412
  598122
  531072
  474120
  554004
  574538
  493420
  451893
  407168
  410218
  520639
  424364
  464378
  524897
  446084
  525866
  525704
  492267
  575722
  587901
  818447
  239112
  622005
  590866
  721738
  395862
  323088
  471494
  770278
  763313
  514700
  384810
  399739
  593343
  512821
  827940
  478084
  447835
  397111
  721795
  550681
  746889
  716298
  810685
  649150
  815982
  596990
  410090
  571629
  576024
  672584
  521907
  565061
  511239
  446906
  528571
  644636
  614739
  560462
  505041
  823242
  584711
  725409
  497923
  559766
  505023
  494266
  425028
  603663
  726589
  467614
  433212
  446105
  561816
  509879
  609276
  603536
  520347
  622229
  652263
]
2.32 ms
(1.24%)
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
  239112
  323088
  384810
  388434
  395862
  397111
  397530
  399700
  399739
  399824
  402008
  407168
  410090
  410218
  413889
  416332
  424364
  425028
  425784
  431022
  433212
  433231
  445248
  446084
  446105
  446906
  447835
  448832
  449362
  451893
  464378
  467614
  471494
  472124
  474120
  475033
  478084
  481581
  483392
  486596
  487435
  492267
  492605
  493420
  494266
  497923
  499498
  501226
  505023
  505041
  509879
  511239
  512263
  512821
  514700
  514841
  517865
  520347
  520639
  521907
  522883
  523859
  523863
  524897
  525704
  525866
  528571
  531072
  550681
  554004
  559029
  559766
  560113
  560462
  561816
  565061
  565163
  565395
  565539
  567159
  571629
  574538
  575722
  576024
  576043
  576412
  581821
  584711
  587901
  590866
  593343
  593743
  596990
  598122
  598386
  603536
  603663
  609276
  614739
  622005
  622229
  644636
  649150
  652263
  672584
  716298
  721738
  721795
  725409
  726589
  745939
  746889
  763313
  770278
  802109
  810685
  815982
  818447
  823242
  827940
]
2.30 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс втроем с красоткой"
]
1.93 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро красивая"
]
1.57 ms
(0.84%)
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.