Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
346.60 ms
(93.72%)
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
  408616
  413819
  414125
  421215
  424001
  425353
  426616
  434286
  434334
  434338
  434384
  443112
  446872
  448515
  460813
  466824
  467879
  467882
  467908
  468307
  469603
  471923
  473051
  475439
  476409
  477210
  480208
  481939
  484057
  485509
  487362
  491449
  491607
  491932
  493234
  495459
  496872
  497332
  497868
  499019
  503113
  503153
  503670
  507939
  508195
  510478
  515499
  520176
  521596
  530268
  533043
  534986
  536532
  536542
  537676
  537747
  537932
  538816
  541216
  541748
  542604
  543609
  545399
  547466
  547481
  547482
  547494
  547958
  549314
  550124
  551904
  562830
  563534
  564387
  565165
  566691
  566695
  568546
  570753
  576718
  576991
  577370
  577386
  581157
  583996
  586023
  591067
  592492
  592675
  594406
  600017
  600270
  600344
  601644
  601653
  604567
  605376
  605378
  614065
  622382
  625801
  626405
  634202
  660399
  665957
  668688
  669067
  669079
  669361
  669376
  669386
  696450
  717034
  717550
  720237
  780642
  786007
  792594
  800604
  807011
]
14.79 ms
(4.00%)
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
  604567
  605376
  601644
  800604
  780642
  786007
  807011
  717034
  792594
  460813
  468307
  485509
  497868
  476409
  421215
  426616
  408616
  467908
  491607
  515499
  536542
  507939
  503670
  510478
  538816
  537932
  480208
  547466
  547482
  562830
  576718
  542604
  566695
  541216
  563534
  568546
  583996
  669067
  717550
  547958
  549314
  566691
  576991
  577386
  581157
  591067
  592492
  592675
  601653
  614065
  622382
  600344
  625801
  600017
  434334
  434384
  424001
  434286
  413819
  434338
  481939
  499019
  484057
  477210
  487362
  550124
  668688
  491449
  446872
  448515
  534986
  536532
  520176
  537676
  533043
  495459
  496872
  530268
  537747
  466824
  543609
  547481
  564387
  545399
  570753
  547494
  551904
  565165
  660399
  665957
  696450
  720237
  669079
  669361
  669376
  669386
  577370
  594406
  600270
  605378
  634202
  626405
  586023
  425353
  467879
  467882
  469603
  473051
  414125
  471923
  503153
  508195
  521596
  497332
  503113
  491932
  493234
  443112
  475439
  541748
]
2.74 ms
(0.74%)
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
  408616
  413819
  414125
  421215
  424001
  425353
  426616
  434286
  434334
  434338
  434384
  443112
  446872
  448515
  460813
  466824
  467879
  467882
  467908
  468307
  469603
  471923
  473051
  475439
  476409
  477210
  480208
  481939
  484057
  485509
  487362
  491449
  491607
  491932
  493234
  495459
  496872
  497332
  497868
  499019
  503113
  503153
  503670
  507939
  508195
  510478
  515499
  520176
  521596
  530268
  533043
  534986
  536532
  536542
  537676
  537747
  537932
  538816
  541216
  541748
  542604
  543609
  545399
  547466
  547481
  547482
  547494
  547958
  549314
  550124
  551904
  562830
  563534
  564387
  565165
  566691
  566695
  568546
  570753
  576718
  576991
  577370
  577386
  581157
  583996
  586023
  591067
  592492
  592675
  594406
  600017
  600270
  600344
  601644
  601653
  604567
  605376
  605378
  614065
  622382
  625801
  626405
  634202
  660399
  665957
  668688
  669067
  669079
  669361
  669376
  669386
  696450
  717034
  717550
  720237
  780642
  786007
  792594
  800604
  807011
]
1.60 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny anal mature"
]
1.47 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые анал mature"
]
1.21 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые анал mature"
]

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.