Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.11 ms
(86.60%)
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
  246506
  382105
  391583
  391676
  400945
  412609
  418893
  427737
  432413
  432508
  438369
  443070
  444987
  446604
  448306
  448508
  449829
  450503
  452557
  452769
  455114
  455190
  455406
  455971
  456738
  459499
  459511
  460905
  463725
  464135
  464548
  464753
  465154
  467016
  468209
  469164
  470060
  470145
  470208
  470737
  471053
  473679
  474780
  475014
  477862
  478304
  478390
  479148
  480668
  481245
  491103
  492841
  493042
  493909
  494095
  494400
  494413
  495182
  499257
  499742
  500157
  500437
  501801
  503383
  503640
  507452
  508562
  509650
  512231
  518778
  518789
  519079
  521170
  521976
  522812
  522824
  523282
  525389
  525452
  525814
  528057
  528284
  538423
  546632
  547229
  551619
  555994
  555996
  556715
  560438
  560793
  562795
  565019
  571335
  572812
  573817
  574628
  579215
  582321
  582369
  584424
  594638
  598466
  619903
  699444
  713731
  714474
  718876
  725476
  727138
  736978
  738926
  755838
  758158
  759097
  761247
  763744
  764215
  790517
  797060
]
17.22 ms
(8.37%)
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
  738926
  755838
  759097
  758158
  763744
  725476
  727138
  736978
  761247
  764215
  619903
  699444
  713731
  714474
  718876
  790517
  797060
  391676
  475014
  459511
  460905
  448508
  246506
  470060
  481245
  468209
  518778
  522812
  525814
  528284
  499257
  509650
  521976
  523282
  538423
  493042
  493909
  499742
  519079
  522824
  562795
  450503
  525452
  512231
  494095
  494413
  503640
  547229
  551619
  555994
  560438
  555996
  556715
  572812
  582321
  582369
  584424
  546632
  560793
  571335
  573817
  574628
  565019
  579215
  594638
  598466
  427737
  432413
  432508
  455190
  456738
  464548
  469164
  471053
  478304
  478390
  480668
  382105
  412609
  446604
  452557
  467016
  473679
  479148
  391583
  448306
  452769
  455114
  455971
  470145
  470208
  470737
  474780
  400945
  418893
  438369
  443070
  444987
  449829
  455406
  463725
  464135
  464753
  459499
  465154
  477862
  500157
  500437
  501801
  507452
  508562
  518789
  492841
  494400
  495182
  503383
  521170
  525389
  528057
  491103
]
3.11 ms
(1.51%)
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
  246506
  382105
  391583
  391676
  400945
  412609
  418893
  427737
  432413
  432508
  438369
  443070
  444987
  446604
  448306
  448508
  449829
  450503
  452557
  452769
  455114
  455190
  455406
  455971
  456738
  459499
  459511
  460905
  463725
  464135
  464548
  464753
  465154
  467016
  468209
  469164
  470060
  470145
  470208
  470737
  471053
  473679
  474780
  475014
  477862
  478304
  478390
  479148
  480668
  481245
  491103
  492841
  493042
  493909
  494095
  494400
  494413
  495182
  499257
  499742
  500157
  500437
  501801
  503383
  503640
  507452
  508562
  509650
  512231
  518778
  518789
  519079
  521170
  521976
  522812
  522824
  523282
  525389
  525452
  525814
  528057
  528284
  538423
  546632
  547229
  551619
  555994
  555996
  556715
  560438
  560793
  562795
  565019
  571335
  572812
  573817
  574628
  579215
  582321
  582369
  584424
  594638
  598466
  619903
  699444
  713731
  714474
  718876
  725476
  727138
  736978
  738926
  755838
  758158
  759097
  761247
  763744
  764215
  790517
  797060
]
1.95 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy russian"
]
1.80 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy русск"
]
1.75 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy русск"
]

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.