Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.59 ms
(86.41%)
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
  132836
  386548
  395456
  400096
  407487
  408830
  415875
  418464
  418754
  418856
  419280
  422017
  422064
  428847
  438672
  443329
  446405
  448585
  448903
  449112
  454906
  455315
  455450
  455929
  460118
  461077
  470740
  472355
  473331
  473611
  474889
  481036
  485818
  489156
  491648
  493242
  500700
  500745
  509863
  510391
  520167
  521196
  521878
  522842
  527507
  527526
  531588
  533464
  538231
  538401
  538510
  544880
  551382
  552151
  552696
  553092
  553775
  553776
  558231
  558360
  558655
  559474
  560181
  561069
  570248
  570276
  570526
  570528
  570530
  571555
  572137
  572151
  572364
  573430
  573648
  573667
  573685
  573720
  573866
  574532
  576017
  577382
  579204
  580735
  587091
  588615
  589218
  590830
  593076
  593999
  594108
  595077
  596997
  598599
  599766
  602662
  603459
  608091
  609649
  618432
  620967
  622068
  623960
  624078
  626212
  639960
  648360
  650731
  650765
  671077
  685892
  702509
  706465
  746935
  748634
  765448
  778514
  786458
  795120
  807967
]
14.48 ms
(8.09%)
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
  570526
  572151
  573430
  573667
  573720
  573866
  559474
  560181
  570248
  570528
  570530
  577382
  551382
  552151
  552696
  558360
  561069
  570276
  572364
  553092
  558231
  571555
  572137
  573648
  573685
  574532
  576017
  580735
  599766
  602662
  626212
  588615
  603459
  593076
  596997
  400096
  419280
  438672
  448585
  448903
  455315
  395456
  407487
  422064
  443329
  470740
  408830
  418464
  428847
  455450
  473331
  418754
  418856
  454906
  461077
  473611
  481036
  455929
  460118
  472355
  474889
  510391
  509863
  520167
  521196
  538231
  491648
  500700
  521878
  538401
  538510
  522842
  493242
  598599
  622068
  807967
  765448
  748634
  609649
  446405
  531588
  558655
  671077
  608091
  590830
  623960
  786458
  795120
  746935
  702509
  386548
  132836
  422017
  415875
  485818
  449112
  489156
  500745
  527507
  527526
  533464
  579204
  553776
  650731
  706465
  648360
  650765
  685892
  544880
  553775
  593999
  594108
  624078
  587091
  639960
  620967
  589218
  595077
  618432
  778514
]
2.62 ms
(1.47%)
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
  132836
  386548
  395456
  400096
  407487
  408830
  415875
  418464
  418754
  418856
  419280
  422017
  422064
  428847
  438672
  443329
  446405
  448585
  448903
  449112
  454906
  455315
  455450
  455929
  460118
  461077
  470740
  472355
  473331
  473611
  474889
  481036
  485818
  489156
  491648
  493242
  500700
  500745
  509863
  510391
  520167
  521196
  521878
  522842
  527507
  527526
  531588
  533464
  538231
  538401
  538510
  544880
  551382
  552151
  552696
  553092
  553775
  553776
  558231
  558360
  558655
  559474
  560181
  561069
  570248
  570276
  570526
  570528
  570530
  571555
  572137
  572151
  572364
  573430
  573648
  573667
  573685
  573720
  573866
  574532
  576017
  577382
  579204
  580735
  587091
  588615
  589218
  590830
  593076
  593999
  594108
  595077
  596997
  598599
  599766
  602662
  603459
  608091
  609649
  618432
  620967
  622068
  623960
  624078
  626212
  639960
  648360
  650731
  650765
  671077
  685892
  702509
  706465
  746935
  748634
  765448
  778514
  786458
  795120
  807967
]
2.38 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18-летние красотки"
]
1.69 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 19 лет красивая"
]
1.58 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 19 лет красивая"
]
1.57 ms
(0.88%)
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.