Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.31 ms
(87.49%)
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
  44871
  53962
  135726
  191315
  191601
  232978
  234067
  300984
  310133
  336058
  336085
  381226
  383360
  383434
  385496
  385939
  390470
  393315
  396322
  396830
  406986
  412537
  413247
  414782
  416982
  421389
  422415
  424020
  428301
  429221
  433137
  433192
  433433
  435748
  439500
  448939
  449416
  450929
  455976
  456019
  456151
  456158
  457061
  458497
  459139
  461070
  462041
  462476
  463490
  463545
  464401
  467025
  467262
  468418
  474000
  476003
  476892
  477220
  477873
  478250
  478764
  479181
  479182
  479606
  482052
  482242
  483565
  485294
  487068
  490392
  491032
  491160
  493168
  493451
  494591
  494987
  495044
  495458
  496252
  496814
  501991
  502743
  506062
  506842
  507429
  508687
  508759
  510465
  510535
  510655
  511395
  513682
  515031
  519542
  521194
  522113
  530605
  531725
  533845
  538432
  549350
  558905
  561881
  563731
  565886
  572361
  573600
  579850
  597456
  598712
  604364
  613275
  679601
  679613
  707606
  736875
  757603
  780773
  780793
  814394
]
15.21 ms
(7.18%)
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
  463545
  521194
  780773
  780793
  561881
  679601
  463490
  421389
  491160
  396830
  44871
  814394
  433137
  462476
  558905
  439500
  515031
  519542
  390470
  300984
  506842
  433192
  428301
  613275
  502743
  477220
  506062
  597456
  422415
  494987
  474000
  467025
  490392
  433433
  511395
  495458
  461070
  530605
  491032
  396322
  604364
  414782
  573600
  53962
  416982
  496814
  406986
  508759
  459139
  483565
  531725
  336058
  135726
  563731
  413247
  457061
  736875
  476892
  482052
  383434
  456151
  393315
  510535
  383360
  579850
  429221
  508687
  477873
  462041
  385496
  598712
  381226
  455976
  476003
  412537
  456158
  478764
  507429
  479606
  485294
  458497
  493451
  493168
  191315
  565886
  449416
  456019
  479182
  510465
  487068
  707606
  310133
  191601
  533845
  679613
  510655
  538432
  549350
  424020
  468418
  513682
  385939
  336085
  450929
  234067
  495044
  232978
  464401
  757603
  435748
  467262
  448939
  496252
  572361
  478250
  479181
  482242
  522113
  494591
  501991
]
3.20 ms
(1.51%)
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
  44871
  53962
  135726
  191315
  191601
  232978
  234067
  300984
  310133
  336058
  336085
  381226
  383360
  383434
  385496
  385939
  390470
  393315
  396322
  396830
  406986
  412537
  413247
  414782
  416982
  421389
  422415
  424020
  428301
  429221
  433137
  433192
  433433
  435748
  439500
  448939
  449416
  450929
  455976
  456019
  456151
  456158
  457061
  458497
  459139
  461070
  462041
  462476
  463490
  463545
  464401
  467025
  467262
  468418
  474000
  476003
  476892
  477220
  477873
  478250
  478764
  479181
  479182
  479606
  482052
  482242
  483565
  485294
  487068
  490392
  491032
  491160
  493168
  493451
  494591
  494987
  495044
  495458
  496252
  496814
  501991
  502743
  506062
  506842
  507429
  508687
  508759
  510465
  510535
  510655
  511395
  513682
  515031
  519542
  521194
  522113
  530605
  531725
  533845
  538432
  549350
  558905
  561881
  563731
  565886
  572361
  573600
  579850
  597456
  598712
  604364
  613275
  679601
  679613
  707606
  736875
  757603
  780773
  780793
  814394
]
2.19 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╗ð░Ðüð║ð░ðÁÐé Ðçð╗ðÁð¢ð¥ð╝ ð▓ð░ð│ð©ð¢ÐÔǪ"
]
2.06 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ласка член вагин"
]
1.92 ms
(0.91%)
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.