Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.71 ms
(79.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
  95837
  96272
  96495
  192968
  387221
  387544
  389116
  390437
  396588
  397946
  399141
  400694
  400838
  401933
  402885
  403010
  403348
  411047
  418845
  420190
  420478
  420576
  420760
  421153
  421160
  424923
  427087
  432363
  432730
  442685
  443879
  444238
  446937
  447883
  448878
  451569
  451587
  453032
  457089
  457798
  458205
  460694
  464886
  466937
  467559
  467572
  469011
  469604
  469611
  470242
  470958
  472589
  472916
  473238
  473241
  473362
  473791
  474648
  474767
  475227
  475367
  476529
  478484
  480941
  481877
  483560
  484402
  484739
  487719
  488825
  489738
  491520
  491724
  494329
  497406
  497581
  502575
  502851
  504194
  506551
  506825
  510596
  511617
  512314
  517749
  518870
  519184
  520793
  522056
  522838
  523579
  523966
  523989
  525846
  527099
  527792
  528145
  532950
  533703
  544296
  546846
  556882
  558209
  559080
  560597
  571939
  571979
  578365
  581626
  601536
  608407
  611986
  612066
  622824
  631600
  650291
  654472
  691244
  702286
  817917
]
19.54 ms
(12.69%)
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
  654472
  469604
  427087
  444238
  520793
  487719
  387544
  396588
  397946
  464886
  497406
  546846
  578365
  558209
  399141
  473238
  475367
  389116
  420576
  457798
  466937
  472589
  473241
  476529
  512314
  523989
  527792
  488825
  497581
  506825
  491724
  502851
  522838
  523966
  96495
  432730
  442685
  817917
  453032
  528145
  533703
  473362
  478484
  702286
  691244
  581626
  601536
  387221
  400694
  420478
  192968
  451569
  402885
  470958
  504194
  420190
  484739
  523579
  519184
  571979
  470242
  400838
  474648
  518870
  494329
  522056
  611986
  622824
  650291
  432363
  484402
  420760
  467572
  401933
  467559
  474767
  95837
  96272
  390437
  443879
  421153
  491520
  481877
  480941
  532950
  506551
  469611
  472916
  556882
  560597
  559080
  612066
  460694
  473791
  403348
  447883
  457089
  469011
  475227
  403010
  418845
  446937
  451587
  458205
  411047
  483560
  517749
  527099
  571939
  525846
  510596
  424923
  511617
  502575
  544296
  608407
  448878
  631600
  421160
  489738
]
3.45 ms
(2.24%)
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
  95837
  96272
  96495
  192968
  387221
  387544
  389116
  390437
  396588
  397946
  399141
  400694
  400838
  401933
  402885
  403010
  403348
  411047
  418845
  420190
  420478
  420576
  420760
  421153
  421160
  424923
  427087
  432363
  432730
  442685
  443879
  444238
  446937
  447883
  448878
  451569
  451587
  453032
  457089
  457798
  458205
  460694
  464886
  466937
  467559
  467572
  469011
  469604
  469611
  470242
  470958
  472589
  472916
  473238
  473241
  473362
  473791
  474648
  474767
  475227
  475367
  476529
  478484
  480941
  481877
  483560
  484402
  484739
  487719
  488825
  489738
  491520
  491724
  494329
  497406
  497581
  502575
  502851
  504194
  506551
  506825
  510596
  511617
  512314
  517749
  518870
  519184
  520793
  522056
  522838
  523579
  523966
  523989
  525846
  527099
  527792
  528145
  532950
  533703
  544296
  546846
  556882
  558209
  559080
  560597
  571939
  571979
  578365
  581626
  601536
  608407
  611986
  612066
  622824
  631600
  650291
  654472
  691244
  702286
  817917
]
2.78 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "два девушк парен"
]
1.95 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "два девушк парен"
]
1.83 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "2 girls boy"
]

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.