Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.98 ms
(83.05%)
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
  7871
  108094
  393670
  393790
  394391
  396636
  397524
  398648
  400679
  401688
  411471
  413115
  418746
  418835
  419401
  420367
  420898
  422707
  424017
  424904
  428822
  430928
  438973
  441764
  444027
  444378
  445012
  445364
  449541
  451650
  451678
  452920
  453517
  455728
  456251
  456906
  456934
  457800
  457814
  458201
  461575
  463277
  464655
  469094
  469654
  476666
  477235
  477913
  478275
  478873
  483708
  487216
  489478
  489954
  493483
  494522
  498479
  499793
  507968
  509978
  512663
  514978
  515743
  516036
  520069
  520158
  525543
  526917
  528122
  534107
  535336
  539810
  540601
  545703
  548779
  551211
  552107
  558834
  558948
  560927
  564633
  565497
  570029
  571084
  572519
  573572
  573653
  573656
  573723
  576280
  576357
  581607
  584750
  588846
  591819
  593113
  593156
  594118
  595519
  596585
  598029
  598450
  603103
  604064
  612396
  660930
  691335
  693408
  741989
  746480
  747341
  774099
  774957
  780199
  781012
  788182
  789926
  791595
  791920
  801901
]
22.65 ms
(10.81%)
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
  598029
  534107
  693408
  545703
  516036
  413115
  573572
  573723
  477235
  420898
  565497
  564633
  552107
  560927
  573653
  573656
  584750
  393670
  451678
  457814
  428822
  451650
  478275
  449541
  453517
  456251
  494522
  520158
  498479
  445364
  660930
  612396
  747341
  780199
  781012
  791595
  791920
  746480
  774099
  108094
  455728
  469654
  489478
  512663
  788182
  789926
  394391
  418835
  509978
  487216
  441764
  464655
  539810
  691335
  444027
  461575
  525543
  397524
  424017
  603103
  469094
  396636
  400679
  401688
  452920
  463277
  456906
  478873
  551211
  576280
  576357
  571084
  548779
  558834
  570029
  588846
  596585
  593113
  593156
  591819
  398648
  445012
  456934
  430928
  457800
  476666
  477913
  420367
  438973
  444378
  520069
  483708
  515743
  528122
  514978
  489954
  493483
  499793
  535336
  540601
  422707
  558948
  801901
  774957
  604064
  594118
  741989
  7871
  526917
  572519
  581607
  598450
  595519
  424904
  411471
  418746
  458201
  393790
  419401
  507968
]
5.65 ms
(2.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
  7871
  108094
  393670
  393790
  394391
  396636
  397524
  398648
  400679
  401688
  411471
  413115
  418746
  418835
  419401
  420367
  420898
  422707
  424017
  424904
  428822
  430928
  438973
  441764
  444027
  444378
  445012
  445364
  449541
  451650
  451678
  452920
  453517
  455728
  456251
  456906
  456934
  457800
  457814
  458201
  461575
  463277
  464655
  469094
  469654
  476666
  477235
  477913
  478275
  478873
  483708
  487216
  489478
  489954
  493483
  494522
  498479
  499793
  507968
  509978
  512663
  514978
  515743
  516036
  520069
  520158
  525543
  526917
  528122
  534107
  535336
  539810
  540601
  545703
  548779
  551211
  552107
  558834
  558948
  560927
  564633
  565497
  570029
  571084
  572519
  573572
  573653
  573656
  573723
  576280
  576357
  581607
  584750
  588846
  591819
  593113
  593156
  594118
  595519
  596585
  598029
  598450
  603103
  604064
  612396
  660930
  691335
  693408
  741989
  746480
  747341
  774099
  774957
  780199
  781012
  788182
  789926
  791595
  791920
  801901
]
2.22 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð║ÐÇð░Ðüð©ð▓ÐïðÁ ð▒ÐÇð©ÐéÐïðÁ ð┐ð©ÐüÐîð%ÔǪ"
]
1.80 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая бритая вагин"
]
1.72 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.70%)
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.