Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.95 ms
(81.97%)
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
  31015
  45799
  191160
  263900
  382071
  382154
  382959
  383495
  384124
  384298
  384798
  385220
  386545
  388789
  389623
  390892
  392024
  392604
  392984
  397456
  402926
  402955
  404429
  405188
  405191
  406109
  407458
  408299
  409774
  409882
  409936
  410724
  411182
  411406
  413518
  413836
  415882
  416346
  419535
  420259
  424426
  424457
  425960
  426000
  430235
  432154
  434361
  435505
  443326
  443709
  443808
  444670
  445056
  446536
  449092
  450286
  451500
  452145
  452161
  453716
  454017
  454270
  456682
  456984
  458523
  462469
  465214
  465412
  465719
  465788
  465954
  466198
  466261
  466327
  466350
  468957
  469071
  469343
  469532
  470933
  472628
  475952
  476376
  477795
  477959
  482603
  484569
  486253
  486416
  489943
  490013
  498834
  500725
  504290
  508782
  519578
  520919
  521223
  521233
  528522
  543543
  547764
  552585
  560081
  566222
  576648
  598795
  613901
  681646
  705277
  743027
  755401
  755465
  756818
  766698
  790978
  800080
  804409
  808021
  811332
]
24.29 ms
(12.45%)
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
  405191
  445056
  424426
  406109
  416346
  443326
  382959
  31015
  466350
  409936
  386545
  451500
  452161
  454270
  500725
  470933
  613901
  432154
  454017
  382071
  411182
  484569
  465412
  390892
  402926
  385220
  456984
  388789
  384124
  486253
  469532
  681646
  466261
  476376
  755465
  756818
  475952
  519578
  415882
  405188
  755401
  409774
  808021
  402955
  443709
  489943
  466198
  490013
  456682
  466327
  392984
  477959
  392024
  426000
  411406
  410724
  521233
  547764
  453716
  811332
  435505
  508782
  450286
  452145
  384298
  397456
  409882
  465214
  504290
  413836
  407458
  413518
  469343
  705277
  420259
  446536
  462469
  528522
  477795
  408299
  543543
  392604
  389623
  566222
  458523
  804409
  800080
  743027
  482603
  191160
  520919
  263900
  498834
  560081
  552585
  444670
  384798
  383495
  576648
  45799
  468957
  472628
  766698
  465719
  425960
  419535
  486416
  404429
  382154
  465954
  430235
  598795
  790978
  449092
  521223
  469071
  424457
  443808
  434361
  465788
]
3.79 ms
(1.94%)
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
  31015
  45799
  191160
  263900
  382071
  382154
  382959
  383495
  384124
  384298
  384798
  385220
  386545
  388789
  389623
  390892
  392024
  392604
  392984
  397456
  402926
  402955
  404429
  405188
  405191
  406109
  407458
  408299
  409774
  409882
  409936
  410724
  411182
  411406
  413518
  413836
  415882
  416346
  419535
  420259
  424426
  424457
  425960
  426000
  430235
  432154
  434361
  435505
  443326
  443709
  443808
  444670
  445056
  446536
  449092
  450286
  451500
  452145
  452161
  453716
  454017
  454270
  456682
  456984
  458523
  462469
  465214
  465412
  465719
  465788
  465954
  466198
  466261
  466327
  466350
  468957
  469071
  469343
  469532
  470933
  472628
  475952
  476376
  477795
  477959
  482603
  484569
  486253
  486416
  489943
  490013
  498834
  500725
  504290
  508782
  519578
  520919
  521223
  521233
  528522
  543543
  547764
  552585
  560081
  566222
  576648
  598795
  613901
  681646
  705277
  743027
  755401
  755465
  756818
  766698
  790978
  800080
  804409
  808021
  811332
]
2.02 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кун мам"
]
1.79 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс мам женщин"
]
1.44 ms
(0.74%)
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.