Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.19 ms
(86.29%)
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
  387693
  395184
  415223
  417238
  421807
  425592
  441978
  447416
  462167
  463199
  473766
  475588
  476438
  477187
  479978
  481734
  484928
  493770
  513888
  515455
  518031
  523247
  525443
  525935
  527573
  538055
  538436
  539244
  540736
  543734
  550691
  550718
  553109
  556580
  558816
  560157
  564019
  566778
  567240
  568165
  569014
  573477
  574964
  579311
  579368
  580702
  581168
  581701
  582218
  584358
  584540
  585717
  589015
  589510
  591640
  592906
  592924
  594770
  595855
  598568
  599791
  603937
  606783
  612014
  618895
  627745
  630612
  636252
  638457
  639669
  652760
  668087
  672744
  678608
  678671
  680251
  694119
  732001
  742507
  756259
  757340
  758891
  766021
  767480
  768179
  772635
  777700
  778662
  778800
  781099
  791268
  797355
  799809
  800868
  802016
  804532
  804918
  810032
  810544
  810566
  810775
  813183
  814220
  817746
  819444
  820313
  821370
  821605
  823049
  823244
  824014
  824644
  825696
  827535
  827857
  827869
  827887
  827890
  827912
  828653
]
14.92 ms
(7.65%)
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
  525935
  558816
  560157
  579311
  581168
  581701
  584358
  580702
  582218
  594770
  598568
  585717
  603937
  589015
  618895
  630612
  810775
  758891
  766021
  479978
  473766
  477187
  447416
  463199
  475588
  527573
  515455
  525443
  592906
  742507
  417238
  481734
  425592
  395184
  564019
  568165
  553109
  652760
  606783
  804532
  756259
  639669
  800868
  441978
  817746
  819444
  827535
  823049
  825696
  827890
  827912
  828653
  540736
  538055
  550691
  543734
  574964
  567240
  589510
  638457
  781099
  810544
  777700
  778662
  804918
  810566
  767480
  813183
  757340
  768179
  772635
  778800
  791268
  797355
  799809
  802016
  387693
  421807
  462167
  415223
  814220
  821370
  821605
  476438
  484928
  573477
  579368
  584540
  569014
  550718
  591640
  627745
  513888
  518031
  672744
  694119
  680251
  599791
  810032
  732001
  595855
  824644
  820313
  824014
  823244
  827869
  827857
  827887
  493770
  538436
  539244
  523247
  566778
  556580
  668087
  678608
  678671
  592924
  636252
  612014
]
4.40 ms
(2.26%)
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
  387693
  395184
  415223
  417238
  421807
  425592
  441978
  447416
  462167
  463199
  473766
  475588
  476438
  477187
  479978
  481734
  484928
  493770
  513888
  515455
  518031
  523247
  525443
  525935
  527573
  538055
  538436
  539244
  540736
  543734
  550691
  550718
  553109
  556580
  558816
  560157
  564019
  566778
  567240
  568165
  569014
  573477
  574964
  579311
  579368
  580702
  581168
  581701
  582218
  584358
  584540
  585717
  589015
  589510
  591640
  592906
  592924
  594770
  595855
  598568
  599791
  603937
  606783
  612014
  618895
  627745
  630612
  636252
  638457
  639669
  652760
  668087
  672744
  678608
  678671
  680251
  694119
  732001
  742507
  756259
  757340
  758891
  766021
  767480
  768179
  772635
  777700
  778662
  778800
  781099
  791268
  797355
  799809
  800868
  802016
  804532
  804918
  810032
  810544
  810566
  810775
  813183
  814220
  817746
  819444
  820313
  821370
  821605
  823049
  823244
  824014
  824644
  825696
  827535
  827857
  827869
  827887
  827890
  827912
  828653
]
2.04 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov young in"
]
1.87 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов young"
]
1.61 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов young"
]

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.