Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.72 ms
(51.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая gangbang"
]
169.56 ms
(42.00%)
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
  123921
  282858
  318318
  387287
  388474
  389765
  390362
  393314
  397192
  398634
  400936
  401840
  404415
  404732
  419560
  429088
  437470
  438057
  445735
  447036
  453032
  461532
  476103
  483548
  490762
  499718
  500363
  500364
  500369
  513215
  514722
  524183
  525626
  530020
  530796
  530935
  531126
  531136
  536538
  536586
  537894
  543658
  543669
  545383
  551065
  552010
  562823
  562828
  575752
  592034
  594431
  595819
  599941
  599990
  603132
  603204
  603213
  604460
  606515
  614995
  622045
  622217
  622817
  623519
  628374
  632639
  632663
  637032
  645207
  647994
  649545
  651287
  652829
  654473
  654486
  654625
  655088
  655344
  655734
  657706
  658005
  659496
  660481
  660910
  660967
  666546
  670113
  675007
  678117
  681307
  683301
  689642
  697971
  698140
  704872
  709421
  721982
  724179
  734117
  739062
  773993
  775607
  775835
  775878
  775952
  788262
  788973
  801960
  802062
  808511
  816938
  818537
  820348
  821263
  822454
  823721
  826012
  826231
]
16.93 ms
(4.19%)
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
  388474
  775835
  393314
  808511
  704872
  709421
  398634
  404732
  429088
  447036
  476103
  445735
  536586
  545383
  562828
  670113
  649545
  637032
  599941
  599990
  801960
  604460
  788262
  500369
  514722
  826012
  659496
  654625
  657706
  658005
  660910
  660967
  603204
  773993
  739062
  622045
  419560
  397192
  775952
  390362
  400936
  530796
  525626
  500364
  531126
  537894
  499718
  530935
  562823
  552010
  647994
  666546
  603132
  632639
  437470
  490762
  123921
  575752
  595819
  788973
  724179
  461532
  826231
  828276
  828531
  655344
  654473
  654486
  775878
  734117
  483548
  530020
  513215
  531136
  524183
  678117
  675007
  592034
  594431
  628374
  632663
  438057
  823721
  543658
  651287
  660481
  655734
  652829
  622217
  606515
  721982
  387287
  404415
  453032
  683301
  623519
  401840
  282858
  389765
  500363
  536538
  614995
  622817
  816938
  820348
  818537
  645207
  697971
  603213
  318318
  821263
  822454
  551065
  543669
  689642
  698140
  655088
  681307
  802062
  775607
]
2.84 ms
(0.70%)
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
  123921
  282858
  318318
  387287
  388474
  389765
  390362
  393314
  397192
  398634
  400936
  401840
  404415
  404732
  419560
  429088
  437470
  438057
  445735
  447036
  453032
  461532
  476103
  483548
  490762
  499718
  500363
  500364
  500369
  513215
  514722
  524183
  525626
  530020
  530796
  530935
  531126
  531136
  536538
  536586
  537894
  543658
  543669
  545383
  551065
  552010
  562823
  562828
  575752
  592034
  594431
  595819
  599941
  599990
  603132
  603204
  603213
  604460
  606515
  614995
  622045
  622217
  622817
  623519
  628374
  632639
  632663
  637032
  645207
  647994
  649545
  651287
  652829
  654473
  654486
  654625
  655088
  655344
  655734
  657706
  658005
  659496
  660481
  660910
  660967
  666546
  670113
  675007
  678117
  681307
  683301
  689642
  697971
  698140
  704872
  709421
  721982
  724179
  734117
  739062
  773993
  775607
  775835
  775878
  775952
  788262
  788973
  801960
  802062
  808511
  816938
  818537
  820348
  821263
  822454
  823721
  826012
  826231
]
2.03 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette gangbang"
]
1.91 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая gangbang"
]
1.71 ms
(0.42%)
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.