Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.00 ms
(86.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
  7196
  388281
  397982
  403797
  417021
  419492
  422271
  423612
  423633
  426571
  434670
  435398
  436139
  436437
  437610
  439151
  440655
  443202
  445022
  446560
  447790
  447888
  453337
  457569
  460450
  466747
  467558
  468548
  468579
  470011
  470813
  472321
  472962
  474914
  478514
  478548
  480207
  483737
  487506
  492571
  493047
  495163
  499776
  501650
  502190
  503361
  507601
  508430
  509672
  510573
  512189
  512830
  512855
  513324
  514357
  514574
  515572
  515847
  516693
  517832
  518270
  519084
  523003
  523540
  525058
  527177
  527412
  528459
  532152
  532370
  533917
  536766
  537926
  538963
  548548
  554912
  558820
  559095
  559159
  563259
  563823
  565201
  567957
  569249
  576270
  581683
  584474
  585767
  586890
  597947
  598786
  598794
  600565
  602532
  615608
  616013
  616315
  617412
  628069
  629411
  630221
  633524
  635225
  635900
  637065
  637105
  637168
  640708
  640783
  642750
  650379
  650767
  656319
  672711
  679808
  687330
  714109
  762213
  770382
  790878
]
14.45 ms
(8.58%)
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
  569249
  567957
  687330
  650379
  679808
  635225
  637105
  642750
  790878
  422271
  426571
  466747
  436437
  397982
  478548
  503361
  512830
  502190
  517832
  515847
  581683
  633524
  472962
  423612
  419492
  443202
  492571
  501650
  478514
  483737
  523540
  519084
  537926
  714109
  586890
  637065
  640708
  616013
  472321
  467558
  474914
  439151
  480207
  493047
  453337
  635900
  630221
  468579
  533917
  554912
  576270
  598786
  598794
  417021
  470011
  445022
  434670
  487506
  514574
  508430
  548548
  628069
  527412
  437610
  457569
  510573
  527177
  512189
  515572
  563823
  585767
  600565
  597947
  637168
  440655
  460450
  446560
  470813
  423633
  436139
  447790
  512855
  516693
  532370
  563259
  672711
  616315
  762213
  617412
  629411
  435398
  7196
  388281
  468548
  514357
  538963
  584474
  559159
  558820
  656319
  640783
  770382
  447888
  509672
  513324
  495163
  523003
  499776
  518270
  403797
  507601
  532152
  559095
  565201
  650767
  602532
  615608
  528459
  525058
  536766
]
2.91 ms
(1.72%)
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
  7196
  388281
  397982
  403797
  417021
  419492
  422271
  423612
  423633
  426571
  434670
  435398
  436139
  436437
  437610
  439151
  440655
  443202
  445022
  446560
  447790
  447888
  453337
  457569
  460450
  466747
  467558
  468548
  468579
  470011
  470813
  472321
  472962
  474914
  478514
  478548
  480207
  483737
  487506
  492571
  493047
  495163
  499776
  501650
  502190
  503361
  507601
  508430
  509672
  510573
  512189
  512830
  512855
  513324
  514357
  514574
  515572
  515847
  516693
  517832
  518270
  519084
  523003
  523540
  525058
  527177
  527412
  528459
  532152
  532370
  533917
  536766
  537926
  538963
  548548
  554912
  558820
  559095
  559159
  563259
  563823
  565201
  567957
  569249
  576270
  581683
  584474
  585767
  586890
  597947
  598786
  598794
  600565
  602532
  615608
  616013
  616315
  617412
  628069
  629411
  630221
  633524
  635225
  635900
  637065
  637105
  637168
  640708
  640783
  642750
  650379
  650767
  656319
  672711
  679808
  687330
  714109
  762213
  770382
  790878
]
1.72 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 teen cute"
]
1.61 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 teen cute"
]
1.46 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 teen cute"
]

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.