Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.96 ms
(54.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член огромный"
]
151.82 ms
(39.01%)
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
  154675
  382934
  388144
  388973
  399224
  424672
  429793
  435922
  435934
  442410
  449125
  453298
  454293
  455573
  455870
  464755
  471859
  477809
  479954
  481570
  482140
  482676
  483139
  483190
  485666
  489258
  489353
  494270
  500221
  504085
  508759
  508882
  509174
  509578
  509669
  510834
  510869
  511749
  515705
  523398
  525497
  528525
  528877
  530039
  530383
  530476
  530623
  530681
  531173
  531183
  531206
  531208
  532351
  532737
  532962
  533051
  533982
  534150
  535094
  535255
  536872
  540944
  542524
  545117
  548525
  551886
  554185
  554519
  561931
  563559
  568541
  568677
  568909
  572019
  572022
  574763
  577468
  577535
  580160
  582802
  586219
  591600
  593279
  598667
  598833
  601435
  602698
  603652
  606574
  607454
  613180
  613908
  615839
  629333
  629630
  631478
  632687
  639735
  642033
  651051
  676111
  677917
  678125
  679317
  707706
  707740
  726315
  773963
  775802
  779037
  787944
  791679
  797445
  801906
  803596
  807170
  807542
  813029
  813265
  813579
]
17.29 ms
(4.44%)
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
  775802
  779037
  791679
  813029
  773963
  787944
  523398
  482140
  582802
  563559
  577468
  607454
  631478
  598833
  797445
  602698
  813265
  471859
  424672
  536872
  388144
  510869
  545117
  593279
  455870
  509578
  510834
  485666
  568541
  606574
  726315
  479954
  511749
  435934
  613908
  388973
  494270
  483139
  489353
  154675
  442410
  574763
  629333
  429793
  453298
  528525
  540944
  707740
  677917
  613180
  435922
  449125
  483190
  509174
  509669
  515705
  382934
  548525
  807170
  508759
  580160
  803596
  525497
  532962
  531183
  577535
  551886
  679317
  598667
  477809
  554519
  508882
  572019
  399224
  455573
  601435
  531206
  534150
  532351
  533051
  530623
  568909
  568677
  676111
  707706
  651051
  678125
  639735
  591600
  801906
  632687
  533982
  572022
  542524
  586219
  813579
  561931
  642033
  615839
  603652
  554185
  464755
  629630
  500221
  535255
  454293
  489258
  528877
  482676
  504085
  807542
  481570
  535094
  530039
  530383
  531208
  530681
  532737
  530476
  531173
]
2.95 ms
(0.76%)
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
  154675
  382934
  388144
  388973
  399224
  424672
  429793
  435922
  435934
  442410
  449125
  453298
  454293
  455573
  455870
  464755
  471859
  477809
  479954
  481570
  482140
  482676
  483139
  483190
  485666
  489258
  489353
  494270
  500221
  504085
  508759
  508882
  509174
  509578
  509669
  510834
  510869
  511749
  515705
  523398
  525497
  528525
  528877
  530039
  530383
  530476
  530623
  530681
  531173
  531183
  531206
  531208
  532351
  532737
  532962
  533051
  533982
  534150
  535094
  535255
  536872
  540944
  542524
  545117
  548525
  551886
  554185
  554519
  561931
  563559
  568541
  568677
  568909
  572019
  572022
  574763
  577468
  577535
  580160
  582802
  586219
  591600
  593279
  598667
  598833
  601435
  602698
  603652
  606574
  607454
  613180
  613908
  615839
  629333
  629630
  631478
  632687
  639735
  642033
  651051
  676111
  677917
  678125
  679317
  707706
  707740
  726315
  773963
  775802
  779037
  787944
  791679
  797445
  801906
  803596
  807170
  807542
  813029
  813265
  813579
]
1.81 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дрочка члена огромным"
]
1.80 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член огромный"
]
1.57 ms
(0.40%)
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.