Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.58 ms
(84.34%)
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
  48159
  55349
  78786
  79720
  79765
  97445
  122488
  132148
  187709
  358849
  382089
  382182
  384585
  385787
  388132
  390022
  391108
  391931
  391932
  391959
  392952
  395662
  395924
  397666
  398527
  398746
  400653
  403973
  415777
  417130
  419537
  426531
  426549
  439658
  439709
  440933
  443837
  444156
  444708
  445460
  454548
  454551
  456010
  457605
  460318
  465677
  468096
  468354
  468359
  469253
  470722
  472677
  473325
  474969
  475266
  478582
  479094
  487993
  493172
  494454
  496514
  496831
  497344
  502108
  503836
  506833
  509192
  511827
  514205
  517069
  520908
  521137
  523835
  526050
  526526
  526737
  536995
  537263
  537264
  538864
  540799
  544190
  545891
  547423
  549231
  555066
  555927
  588911
  599676
  627361
  710510
  710531
  726756
  726984
  726996
  727034
  727732
  733117
  734015
  734332
  736207
  739994
  740991
  742389
  757240
  757241
  757277
  782508
  788518
  788520
  790860
  791916
  796051
  797252
  797254
  799357
  801096
  803498
  803522
  823351
]
14.00 ms
(9.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
  48159
  417130
  397666
  78786
  479094
  526737
  511827
  384585
  382089
  382182
  97445
  55349
  390022
  788520
  796051
  757241
  801096
  726756
  734015
  757240
  733117
  742389
  788518
  797252
  797254
  358849
  475266
  132148
  395924
  392952
  79765
  440933
  460318
  468096
  469253
  473325
  445460
  457605
  502108
  496514
  468359
  549231
  555066
  710510
  799357
  803498
  803522
  727732
  739994
  757277
  791916
  391959
  395662
  79720
  454551
  470722
  478582
  388132
  403973
  474969
  439709
  444156
  494454
  503836
  517069
  537263
  487993
  496831
  509192
  520908
  523835
  547423
  536995
  426531
  521137
  187709
  444708
  588911
  734332
  736207
  726984
  710531
  385787
  419537
  398527
  465677
  415777
  426549
  454548
  506833
  627361
  526050
  526526
  493172
  391931
  391932
  823351
  472677
  400653
  456010
  443837
  538864
  544190
  555927
  727034
  740991
  514205
  122488
  391108
  398746
  726996
  545891
  439658
  497344
  540799
  537264
  599676
  782508
  790860
  468354
]
2.89 ms
(1.90%)
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
  48159
  55349
  78786
  79720
  79765
  97445
  122488
  132148
  187709
  358849
  382089
  382182
  384585
  385787
  388132
  390022
  391108
  391931
  391932
  391959
  392952
  395662
  395924
  397666
  398527
  398746
  400653
  403973
  415777
  417130
  419537
  426531
  426549
  439658
  439709
  440933
  443837
  444156
  444708
  445460
  454548
  454551
  456010
  457605
  460318
  465677
  468096
  468354
  468359
  469253
  470722
  472677
  473325
  474969
  475266
  478582
  479094
  487993
  493172
  494454
  496514
  496831
  497344
  502108
  503836
  506833
  509192
  511827
  514205
  517069
  520908
  521137
  523835
  526050
  526526
  526737
  536995
  537263
  537264
  538864
  540799
  544190
  545891
  547423
  549231
  555066
  555927
  588911
  599676
  627361
  710510
  710531
  726756
  726984
  726996
  727034
  727732
  733117
  734015
  734332
  736207
  739994
  740991
  742389
  757240
  757241
  757277
  782508
  788518
  788520
  790860
  791916
  796051
  797252
  797254
  799357
  801096
  803498
  803522
  823351
]
1.90 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "измены зрелых жен"
]
1.81 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен зрелая женщин жен"
]
1.49 ms
(0.98%)
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.