Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.16 ms
(87.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
  82252
  382839
  384070
  385607
  390889
  403081
  409274
  411883
  411885
  411896
  412001
  415588
  416226
  426709
  427523
  428996
  429244
  444383
  450213
  453395
  454960
  454986
  455262
  457393
  457962
  468687
  468719
  468735
  468758
  470126
  471866
  472610
  473195
  474734
  474751
  489294
  506266
  508647
  509412
  509837
  511378
  512683
  518796
  522123
  524918
  525655
  525660
  526782
  528689
  530747
  530769
  531467
  536701
  545330
  550364
  555940
  555952
  565157
  566061
  572858
  575720
  579813
  582760
  589031
  589263
  591598
  591658
  597665
  598456
  600359
  601101
  607191
  607590
  614030
  621385
  627781
  629388
  630079
  631654
  631692
  631944
  632015
  634553
  638412
  638533
  640731
  641344
  641487
  642725
  647675
  648222
  649131
  688672
  692804
  702152
  705741
  710706
  716848
  716911
  719139
  721113
  725970
  725980
  729864
  733598
  737070
  737079
  737174
  740599
  741313
  744593
  745759
  748159
  755846
  758492
  761347
  777570
  784490
  784494
  817242
]
14.71 ms
(8.11%)
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
  740599
  545330
  630079
  641487
  614030
  710706
  384070
  702152
  638412
  472610
  457393
  411883
  474751
  390889
  455262
  509837
  506266
  555952
  721113
  737079
  597665
  629388
  531467
  509412
  582760
  627781
  566061
  411896
  427523
  575720
  591598
  729864
  745759
  716911
  526782
  453395
  600359
  631944
  716848
  692804
  565157
  761347
  468719
  579813
  705741
  621385
  784490
  744593
  468687
  474734
  403081
  426709
  550364
  572858
  649131
  688672
  641344
  755846
  640731
  525660
  473195
  382839
  411885
  634553
  638533
  444383
  409274
  530747
  512683
  508647
  555940
  648222
  607191
  631654
  598456
  591658
  589263
  725980
  725970
  741313
  737174
  758492
  733598
  601101
  536701
  784494
  82252
  511378
  748159
  632015
  468758
  454986
  524918
  647675
  607590
  468735
  416226
  528689
  450213
  429244
  470126
  415588
  454960
  428996
  518796
  412001
  777570
  385607
  817242
  489294
  530769
  457962
  719139
  589031
  631692
  642725
  525655
  522123
  737070
  471866
]
2.41 ms
(1.33%)
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
  82252
  382839
  384070
  385607
  390889
  403081
  409274
  411883
  411885
  411896
  412001
  415588
  416226
  426709
  427523
  428996
  429244
  444383
  450213
  453395
  454960
  454986
  455262
  457393
  457962
  468687
  468719
  468735
  468758
  470126
  471866
  472610
  473195
  474734
  474751
  489294
  506266
  508647
  509412
  509837
  511378
  512683
  518796
  522123
  524918
  525655
  525660
  526782
  528689
  530747
  530769
  531467
  536701
  545330
  550364
  555940
  555952
  565157
  566061
  572858
  575720
  579813
  582760
  589031
  589263
  591598
  591658
  597665
  598456
  600359
  601101
  607191
  607590
  614030
  621385
  627781
  629388
  630079
  631654
  631692
  631944
  632015
  634553
  638412
  638533
  640731
  641344
  641487
  642725
  647675
  648222
  649131
  688672
  692804
  702152
  705741
  710706
  716848
  716911
  719139
  721113
  725970
  725980
  729864
  733598
  737070
  737079
  737174
  740599
  741313
  744593
  745759
  748159
  755846
  758492
  761347
  777570
  784490
  784494
  817242
]
1.72 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг минет оральн секс"
]
1.63 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг минет оральн секс"
]
1.43 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting blowjob"
]
1.33 ms
(0.73%)
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.