Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.24 ms
(84.61%)
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
  44495
  98749
  285231
  385296
  387203
  394772
  395516
  402260
  405252
  415602
  416184
  417914
  419539
  421065
  426378
  426536
  426765
  428858
  429383
  429441
  430023
  433217
  433359
  435930
  439519
  439746
  442233
  444044
  444083
  445596
  446275
  450315
  450811
  451849
  452297
  453494
  453660
  454911
  456612
  459158
  459661
  460071
  460794
  462462
  462656
  463877
  464857
  465169
  465485
  465593
  466025
  466208
  466897
  467402
  467661
  467952
  469832
  470523
  472336
  472948
  473846
  474457
  474975
  475852
  475883
  476088
  477373
  477963
  477981
  478155
  478525
  479247
  480399
  480515
  483022
  484057
  484521
  484611
  484668
  484672
  484737
  485803
  485835
  490166
  491209
  491962
  493807
  497793
  499487
  499788
  501487
  501499
  502775
  504091
  506779
  509376
  512084
  513857
  515370
  516178
  517239
  517833
  517874
  518128
  518589
  520283
  522501
  524200
  525095
  527444
  528925
  531423
  535934
  536446
  554927
  555120
  565360
  580022
  586652
  590633
]
16.71 ms
(9.60%)
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
  522501
  446275
  466897
  501487
  491209
  402260
  421065
  459158
  474457
  428858
  480515
  465593
  477963
  484611
  535934
  490166
  484672
  474975
  456612
  554927
  555120
  419539
  480399
  467402
  475883
  478525
  433359
  426378
  439746
  452297
  466025
  477981
  472336
  483022
  517874
  531423
  497793
  515370
  453494
  395516
  466208
  462462
  504091
  484737
  501499
  484668
  536446
  385296
  429383
  426536
  464857
  499788
  590633
  426765
  459661
  517833
  98749
  387203
  485835
  465485
  394772
  506779
  44495
  429441
  433217
  435930
  439519
  444083
  442233
  453660
  460794
  467661
  469832
  451849
  454911
  484521
  450315
  450811
  465169
  467952
  473846
  509376
  513857
  460071
  472948
  580022
  565360
  586652
  415602
  462656
  476088
  405252
  463877
  475852
  285231
  430023
  444044
  470523
  478155
  479247
  416184
  445596
  477373
  417914
  516178
  524200
  525095
  527444
  517239
  518589
  520283
  528925
  484057
  485803
  493807
  499487
  502775
  512084
  518128
  491962
]
3.11 ms
(1.79%)
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
  44495
  98749
  285231
  385296
  387203
  394772
  395516
  402260
  405252
  415602
  416184
  417914
  419539
  421065
  426378
  426536
  426765
  428858
  429383
  429441
  430023
  433217
  433359
  435930
  439519
  439746
  442233
  444044
  444083
  445596
  446275
  450315
  450811
  451849
  452297
  453494
  453660
  454911
  456612
  459158
  459661
  460071
  460794
  462462
  462656
  463877
  464857
  465169
  465485
  465593
  466025
  466208
  466897
  467402
  467661
  467952
  469832
  470523
  472336
  472948
  473846
  474457
  474975
  475852
  475883
  476088
  477373
  477963
  477981
  478155
  478525
  479247
  480399
  480515
  483022
  484057
  484521
  484611
  484668
  484672
  484737
  485803
  485835
  490166
  491209
  491962
  493807
  497793
  499487
  499788
  501487
  501499
  502775
  504091
  506779
  509376
  512084
  513857
  515370
  516178
  517239
  517833
  517874
  518128
  518589
  520283
  522501
  524200
  525095
  527444
  528925
  531423
  535934
  536446
  554927
  555120
  565360
  580022
  586652
  590633
]
1.95 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "потрахал маму"
]
1.74 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "потраха мам женщин"
]
1.71 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "потраха мам женщин"
]
1.57 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.