Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.01 ms
(86.08%)
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
  24993
  99145
  135519
  193895
  197358
  233369
  305931
  384553
  387965
  388411
  388773
  395439
  396259
  397199
  401288
  421790
  423943
  426245
  438614
  441956
  445892
  456435
  456794
  459239
  459273
  462189
  465675
  473005
  485810
  493149
  496713
  523838
  523847
  526767
  532118
  537539
  538459
  541626
  547323
  549705
  549709
  551963
  553155
  555301
  557254
  566627
  566858
  567313
  573219
  574077
  577257
  578007
  581196
  583190
  585419
  591276
  603054
  604488
  611343
  614819
  621200
  621682
  627344
  630494
  633092
  637318
  639788
  658492
  678780
  684150
  710833
  712703
  714594
  715426
  727017
  727482
  727945
  740545
  742560
  744764
  751560
  752647
  759146
  759397
  762274
  769137
  769438
  776775
  777292
  779069
  781928
  785432
  787064
  787092
  792826
  794864
  794894
  797176
  797298
  801420
  802019
  802488
  803306
  807304
  807523
  812936
  813769
  814804
  814851
  815230
  815529
  817278
  817878
  818353
  818499
  820559
  820847
  821493
  823891
  826783
]
12.53 ms
(7.54%)
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
  384553
  24993
  388411
  441956
  473005
  135519
  193895
  395439
  99145
  397199
  401288
  462189
  526767
  658492
  678780
  611343
  637318
  769137
  801420
  633092
  802019
  421790
  818353
  465675
  538459
  557254
  566627
  567313
  573219
  551963
  581196
  585419
  621200
  627344
  802488
  787064
  740545
  759146
  769438
  781928
  423943
  197358
  438614
  445892
  578007
  456435
  814851
  817878
  815529
  817278
  459273
  532118
  583190
  710833
  621682
  604488
  779069
  807523
  727482
  751560
  233369
  541626
  823891
  712703
  792826
  744764
  727945
  639788
  803306
  523847
  493149
  523838
  818499
  820847
  826783
  813769
  815230
  821493
  496713
  537539
  547323
  577257
  574077
  553155
  684150
  714594
  555301
  776775
  797298
  785432
  787092
  797176
  715426
  777292
  305931
  388773
  387965
  396259
  426245
  814804
  820559
  459239
  456794
  485810
  549705
  549709
  566858
  630494
  591276
  603054
  614819
  794894
  794864
  812936
  752647
  807304
  759397
  762274
  727017
  742560
]
2.47 ms
(1.48%)
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
  24993
  99145
  135519
  193895
  197358
  233369
  305931
  384553
  387965
  388411
  388773
  395439
  396259
  397199
  401288
  421790
  423943
  426245
  438614
  441956
  445892
  456435
  456794
  459239
  459273
  462189
  465675
  473005
  485810
  493149
  496713
  523838
  523847
  526767
  532118
  537539
  538459
  541626
  547323
  549705
  549709
  551963
  553155
  555301
  557254
  566627
  566858
  567313
  573219
  574077
  577257
  578007
  581196
  583190
  585419
  591276
  603054
  604488
  611343
  614819
  621200
  621682
  627344
  630494
  633092
  637318
  639788
  658492
  678780
  684150
  710833
  712703
  714594
  715426
  727017
  727482
  727945
  740545
  742560
  744764
  751560
  752647
  759146
  759397
  762274
  769137
  769438
  776775
  777292
  779069
  781928
  785432
  787064
  787092
  792826
  794864
  794894
  797176
  797298
  801420
  802019
  802488
  803306
  807304
  807523
  812936
  813769
  814804
  814851
  815230
  815529
  817278
  817878
  818353
  818499
  820559
  820847
  821493
  823891
  826783
]
2.29 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shower mother"
]
2.24 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shower мам женщин"
]
1.74 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shower мам женщин"
]

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.