Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.53 ms
(86.95%)
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
  7108
  14806
  32874
  32937
  33260
  154516
  155198
  161318
  327981
  387295
  401517
  401809
  402350
  405508
  405954
  406363
  407562
  411052
  413788
  414088
  415739
  417495
  417865
  417884
  419600
  420116
  420499
  425627
  428535
  430285
  445730
  458597
  463838
  464344
  465483
  465484
  468371
  472263
  472553
  485170
  487010
  489347
  496279
  517181
  519182
  525678
  536930
  537832
  538725
  539917
  540393
  543894
  544694
  551980
  560292
  578208
  578786
  580757
  583948
  587081
  589238
  601710
  604500
  604515
  604526
  604571
  609673
  613015
  618036
  624828
  629901
  638533
  643920
  647641
  649863
  673767
  674100
  683593
  690884
  693220
  701309
  708667
  710266
  711337
  720176
  721060
  722187
  724483
  725676
  726665
  729181
  732468
  744668
  751309
  779774
  785679
  787215
  788364
  789790
  792817
  793151
  795515
  800474
  800475
  805424
  808580
  810122
  811270
  813074
  813799
  814661
  818281
  821162
  822189
  822419
  822559
  824787
  824900
  828758
]
15.29 ms
(7.75%)
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
  538725
  539917
  472553
  551980
  578208
  647641
  580757
  604571
  613015
  638533
  604515
  808580
  811270
  793151
  800475
  805424
  726665
  729181
  604500
  604526
  720176
  792817
  430285
  425627
  406363
  413788
  419600
  487010
  155198
  161318
  33260
  402350
  401517
  401809
  405954
  411052
  417865
  407562
  415739
  822419
  821926
  465483
  465484
  485170
  445730
  458597
  489347
  540393
  536930
  537832
  583948
  560292
  683593
  674100
  690884
  710266
  711337
  649863
  701309
  708667
  587081
  589238
  787215
  789790
  813074
  744668
  795515
  751309
  725676
  732468
  721060
  810122
  417495
  420499
  14806
  405508
  420116
  472263
  463838
  525678
  468371
  800474
  724483
  601710
  618036
  428535
  154516
  327981
  32937
  32874
  7108
  387295
  414088
  417884
  821162
  822189
  822559
  824787
  813799
  814661
  818281
  824900
  828758
  517181
  519182
  496279
  464344
  544694
  543894
  673767
  693220
  722187
  578786
  643920
  609673
  624828
  629901
  779774
  785679
  788364
]
2.88 ms
(1.46%)
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
  7108
  14806
  32874
  32937
  33260
  154516
  155198
  161318
  327981
  387295
  401517
  401809
  402350
  405508
  405954
  406363
  407562
  411052
  413788
  414088
  415739
  417495
  417865
  417884
  419600
  420116
  420499
  425627
  428535
  430285
  445730
  458597
  463838
  464344
  465483
  465484
  468371
  472263
  472553
  485170
  487010
  489347
  496279
  517181
  519182
  525678
  536930
  537832
  538725
  539917
  540393
  543894
  544694
  551980
  560292
  578208
  578786
  580757
  583948
  587081
  589238
  601710
  604500
  604515
  604526
  604571
  609673
  613015
  618036
  624828
  629901
  638533
  643920
  647641
  649863
  673767
  674100
  683593
  690884
  693220
  701309
  708667
  710266
  711337
  720176
  721060
  722187
  724483
  725676
  726665
  729181
  732468
  744668
  751309
  779774
  785679
  787215
  788364
  789790
  792817
  793151
  795515
  800474
  800475
  805424
  808580
  810122
  811270
  813074
  813799
  814661
  818281
  821162
  822189
  822419
  822559
  824787
  824900
  828758
]
2.02 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black tits"
]
1.92 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black сиськ"
]
1.72 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black сиськ"
]

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.