Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
111.65 ms
(82.19%)
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
  8497
  97098
  109233
  129999
  226195
  383565
  383911
  384295
  387542
  390653
  390696
  391455
  391928
  392716
  397873
  402555
  405895
  408424
  410366
  411802
  411984
  413979
  415636
  415831
  415906
  418395
  419566
  420154
  421501
  422303
  422665
  422695
  423190
  423378
  426015
  426482
  428562
  429219
  429839
  435759
  436089
  438786
  445058
  445224
  447007
  447040
  448402
  450184
  453335
  453728
  455670
  455967
  482404
  483242
  483647
  483843
  483878
  483900
  484780
  484947
  485446
  485776
  486040
  486849
  487355
  487458
  490803
  490816
  491205
  493009
  493024
  494046
  495087
  497140
  497331
  497535
  497882
  501306
  501608
  503013
  505042
  505727
  505987
  506014
  507273
  507384
  508015
  508780
  509797
  510111
  511535
  511758
  512235
  512255
  512488
  512570
  512640
  513361
  513727
  513865
  513906
  514370
  515285
  516163
  518892
  520309
  522251
  523750
  524023
  525493
  525578
  525901
  526433
  528027
  528156
  529263
  533351
  535630
  539356
]
14.80 ms
(10.90%)
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
  494046
  495087
  497140
  497331
  501608
  505987
  506014
  508780
  510111
  512255
  512640
  513361
  516163
  525578
  535630
  483843
  483878
  484947
  485776
  486849
  490816
  493009
  493024
  497882
  503013
  505042
  505727
  507273
  508015
  511758
  513727
  513865
  513906
  514370
  515285
  522251
  523750
  525493
  527557
  528156
  483242
  483647
  483900
  484780
  485446
  486040
  487355
  487458
  490803
  491205
  497535
  501306
  507384
  509797
  511535
  512235
  512488
  512570
  518892
  520309
  524023
  525901
  526433
  528027
  529263
  533351
  539356
  383911
  384295
  383565
  129999
  109233
  226195
  392716
  391928
  97098
  8497
  387542
  390696
  391455
  390653
  397873
  402555
  405895
  408424
  411984
  415831
  415906
  422665
  422695
  423190
  426482
  428562
  445058
  445224
  411802
  413979
  418395
  420154
  422303
  435759
  410366
  415636
  429219
  436089
  419566
  423378
  426015
  429839
  438786
  421501
  482404
  447007
  447040
  448402
  450184
  453335
  453728
  455670
  455967
]
2.33 ms
(1.72%)
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
  8497
  97098
  109233
  129999
  226195
  383565
  383911
  384295
  387542
  390653
  390696
  391455
  391928
  392716
  397873
  402555
  405895
  408424
  410366
  411802
  411984
  413979
  415636
  415831
  415906
  418395
  419566
  420154
  421501
  422303
  422665
  422695
  423190
  423378
  426015
  426482
  428562
  429219
  429839
  435759
  436089
  438786
  445058
  445224
  447007
  447040
  448402
  450184
  453335
  453728
  455670
  455967
  482404
  483242
  483647
  483843
  483878
  483900
  484780
  484947
  485446
  485776
  486040
  486849
  487355
  487458
  490803
  490816
  491205
  493009
  493024
  494046
  495087
  497140
  497331
  497535
  497882
  501306
  501608
  503013
  505042
  505727
  505987
  506014
  507273
  507384
  508015
  508780
  509797
  510111
  511535
  511758
  512235
  512255
  512488
  512570
  512640
  513361
  513727
  513865
  513906
  514370
  515285
  516163
  518892
  520309
  522251
  523750
  524023
  525493
  525578
  525901
  526433
  528027
  528156
  529263
  533351
  535630
  539356
]
1.88 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "щеку"
]
1.82 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "щек"
]
1.81 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "щек"
]
1.54 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.