Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.85 ms
(58.45%)
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
  391604
  395306
  417725
  418116
  427819
  434574
  437133
  437148
  441447
  441448
  441501
  443010
  447265
  448282
  448519
  448522
  450542
  452568
  453000
  454837
  454842
  455519
  455956
  456402
  458470
  458600
  458789
  459191
  459482
  459941
  459956
  464519
  468062
  468379
  472076
  472159
  473238
  473986
  475111
  477612
  478123
  482650
  483568
  484836
  486385
  486596
  488821
  490227
  491565
  497338
  498012
  498563
  500463
  500493
  507362
  508748
  509867
  509917
  510482
  510565
  511197
  511347
  511521
  514104
  515651
  516200
  516443
  516693
  518608
  518930
  520491
  520621
  520786
  522225
  522559
  523301
  524189
  524581
  525179
  526199
  527123
  527463
  527943
  528005
  528149
  533021
  535091
  542059
  546509
  551847
  554292
  556222
  559284
  560512
  560845
  562067
  565739
  566346
  567756
  568208
  568536
  570398
  576199
  578351
  578367
  578373
  578384
  583679
  585737
  585922
  586864
  588494
  589087
  602758
  603937
  608153
  612447
  634231
  654914
  798243
]
115.13 ms
(32.22%)
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
  391604
  395306
  417725
  418116
  427819
  434574
  437133
  437148
  441447
  441448
  441501
  443010
  447265
  448282
  448519
  448522
  450542
  452568
  453000
  454837
  454842
  455519
  455956
  456402
  458470
  458600
  458789
  459191
  459482
  459941
  459956
  464519
  468062
  468379
  472076
  472159
  473238
  473986
  475111
  477612
  478123
  482650
  483568
  484836
  486385
  486596
  488821
  490227
  491565
  497338
  498012
  498563
  500463
  500493
  507362
  508748
  509867
  509917
  510482
  510565
  511197
  511347
  511521
  514104
  515651
  516200
  516443
  516693
  518608
  518930
  520491
  520621
  520786
  522225
  522559
  523301
  524189
  524581
  525179
  526199
  527123
  527463
  527943
  528005
  528149
  533021
  535091
  542059
  546509
  551847
  554292
  556222
  559284
  560512
  560845
  562067
  565739
  566346
  567756
  568208
  568536
  570398
  576199
  578351
  578367
  578373
  578384
  583679
  585737
  585922
  586864
  588494
  589087
  602758
  603937
  608153
  612447
  634231
  654914
  798243
]
26.26 ms
(7.35%)
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
  395306
  418116
  482650
  448522
  459191
  475111
  483568
  488821
  456402
  458600
  520621
  509917
  510565
  509867
  522225
  468379
  472159
  576199
  568208
  568536
  570398
  565739
  654914
  546509
  589087
  585922
  798243
  427819
  450542
  448282
  455519
  455956
  464519
  473986
  478123
  434574
  454837
  459956
  477612
  515651
  520786
  486596
  490227
  497338
  511197
  507362
  516443
  468062
  578367
  583679
  578351
  578373
  535091
  533021
  528149
  437148
  498012
  459482
  527463
  527943
  560845
  562067
  566346
  586864
  588494
  603937
  612447
  453000
  448519
  454842
  518608
  522559
  523301
  525179
  484836
  520491
  551847
  528005
  441447
  437133
  441448
  452568
  458789
  459941
  500463
  516693
  500493
  518930
  526199
  498563
  508748
  527123
  554292
  542059
  559284
  560512
  556222
  585737
  608153
  443010
  458470
  472076
  524581
  524189
  473238
  634231
  602758
  511347
  417725
  578384
  486385
  511521
  567756
  491565
  391604
  441501
  447265
  516200
  514104
  510482
]
1.98 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade college"
]
1.81 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск college"
]
1.46 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск college"
]

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.