Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.02 ms
(85.65%)
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
  70167
  147128
  337234
  383348
  397120
  398679
  406658
  407432
  410428
  414702
  414808
  418345
  420136
  423564
  428764
  438495
  457845
  466415
  466685
  469149
  469189
  473553
  480099
  486371
  486684
  490820
  491466
  496510
  497386
  497478
  508800
  509593
  512832
  513920
  540253
  557084
  563382
  568513
  568516
  570861
  579390
  588148
  590254
  600575
  603615
  603708
  604457
  606511
  607277
  608773
  609233
  613240
  622651
  629870
  629887
  632668
  635179
  636553
  636557
  652540
  662062
  662195
  673664
  675839
  678182
  678259
  680373
  682321
  709445
  710891
  714166
  714826
  715543
  718856
  719040
  727413
  728131
  728895
  730088
  731062
  731317
  731697
  733789
  734524
  744842
  747571
  748816
  749538
  750224
  752499
  771538
  772920
  775163
  775513
  777567
  777627
  778619
  779008
  779015
  779077
  779084
  781065
  784103
  786160
  787614
  790398
  791067
  793739
  800029
  801987
  804675
  807845
  809634
  810373
  810736
  816709
  817209
  820213
  825173
]
14.95 ms
(8.42%)
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
  414702
  397120
  469189
  466415
  715543
  606511
  744842
  466685
  680373
  817209
  414808
  632668
  762336
  787614
  383348
  480099
  410428
  607277
  714166
  733789
  622651
  636553
  748816
  682321
  540253
  588148
  457845
  613240
  407432
  428764
  418345
  579390
  714826
  710891
  791067
  810373
  568513
  718856
  662195
  777627
  779084
  790398
  727413
  786160
  801987
  730088
  734524
  728131
  749538
  750224
  752499
  609233
  438495
  512832
  771538
  423564
  496510
  709445
  652540
  678182
  604457
  635179
  629870
  629887
  497386
  509593
  673664
  603615
  508800
  398679
  816709
  825173
  469149
  800029
  497478
  147128
  70167
  675839
  810736
  747571
  778619
  804675
  563382
  603708
  820213
  406658
  590254
  486684
  570861
  719040
  678259
  600575
  775513
  777567
  779008
  779015
  793739
  809634
  779077
  781065
  784103
  728895
  731317
  772920
  731062
  731697
  636557
  775163
  807845
  486371
  513920
  337234
  557084
  473553
  420136
  568516
  490820
  608773
  491466
  662062
]
2.89 ms
(1.63%)
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
  70167
  147128
  337234
  383348
  397120
  398679
  406658
  407432
  410428
  414702
  414808
  418345
  420136
  423564
  428764
  438495
  457845
  466415
  466685
  469149
  469189
  473553
  480099
  486371
  486684
  490820
  491466
  496510
  497386
  497478
  508800
  509593
  512832
  513920
  540253
  557084
  563382
  568513
  568516
  570861
  579390
  588148
  590254
  600575
  603615
  603708
  604457
  606511
  607277
  608773
  609233
  613240
  622651
  629870
  629887
  632668
  635179
  636553
  636557
  652540
  662062
  662195
  673664
  675839
  678182
  678259
  680373
  682321
  709445
  710891
  714166
  714826
  715543
  718856
  719040
  727413
  728131
  728895
  730088
  731062
  731317
  731697
  733789
  734524
  744842
  747571
  748816
  749538
  750224
  752499
  771538
  772920
  775163
  775513
  777567
  777627
  778619
  779008
  779015
  779077
  779084
  781065
  784103
  786160
  787614
  790398
  791067
  793739
  800029
  801987
  804675
  807845
  809634
  810373
  810736
  816709
  817209
  820213
  825173
]
2.24 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "отсос сперма подборка…"
]
1.86 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс сперм подборк"
]
1.80 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.