Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.17 ms
(85.67%)
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
  6840
  95864
  343078
  382642
  385129
  390907
  391043
  391572
  396553
  401105
  405466
  415254
  416157
  420233
  429800
  429844
  430324
  444349
  445002
  447111
  448038
  448853
  453604
  454173
  462738
  465128
  467782
  468071
  470382
  472381
  473035
  473550
  473943
  478239
  481339
  486694
  486981
  488637
  489403
  490035
  490247
  492435
  492820
  496432
  500169
  501785
  502236
  505867
  512345
  512664
  514352
  514799
  514907
  515570
  517097
  522813
  524082
  524722
  529050
  535938
  538209
  545530
  549022
  549804
  551628
  552145
  552186
  552226
  552239
  553213
  554746
  557043
  557545
  559945
  560880
  561935
  562221
  562280
  562303
  564128
  564593
  565354
  566031
  567773
  568351
  569868
  570015
  570041
  570385
  570444
  571233
  571913
  572121
  572315
  572801
  573011
  573115
  573263
  573544
  573661
  573695
  573703
  573855
  574680
  575771
  577689
  579181
  581168
  584495
  589377
  591677
  593198
  593965
  625868
  654352
  661694
  674909
  699787
  755832
  778681
]
16.07 ms
(8.93%)
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
  500169
  490247
  549022
  570444
  552226
  568351
  572801
  573703
  577689
  552145
  552186
  553213
  562221
  562280
  569868
  571913
  573011
  573115
  573661
  573695
  661694
  674909
  699787
  552239
  554746
  570015
  570041
  570385
  572121
  573544
  573855
  589377
  591677
  755832
  390907
  391043
  415254
  444349
  447111
  448853
  470382
  473550
  343078
  6840
  420233
  454173
  472381
  473943
  405466
  429800
  462738
  467782
  473035
  382642
  385129
  391572
  396553
  445002
  478239
  453604
  502236
  515570
  517097
  529050
  496432
  505867
  488637
  492435
  492820
  514352
  522813
  538209
  489403
  512664
  514907
  524082
  535938
  562303
  654352
  593965
  625868
  593198
  468071
  549804
  564128
  778681
  557043
  567773
  572315
  551628
  575771
  579181
  559945
  571233
  584495
  95864
  416157
  501785
  514799
  486981
  524722
  401105
  430324
  429844
  465128
  490035
  481339
  448038
  512345
  486694
  545530
  561935
  564593
  565354
  557545
  566031
  573263
  574680
  581168
  560880
]
2.86 ms
(1.59%)
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
  6840
  95864
  343078
  382642
  385129
  390907
  391043
  391572
  396553
  401105
  405466
  415254
  416157
  420233
  429800
  429844
  430324
  444349
  445002
  447111
  448038
  448853
  453604
  454173
  462738
  465128
  467782
  468071
  470382
  472381
  473035
  473550
  473943
  478239
  481339
  486694
  486981
  488637
  489403
  490035
  490247
  492435
  492820
  496432
  500169
  501785
  502236
  505867
  512345
  512664
  514352
  514799
  514907
  515570
  517097
  522813
  524082
  524722
  529050
  535938
  538209
  545530
  549022
  549804
  551628
  552145
  552186
  552226
  552239
  553213
  554746
  557043
  557545
  559945
  560880
  561935
  562221
  562280
  562303
  564128
  564593
  565354
  566031
  567773
  568351
  569868
  570015
  570041
  570385
  570444
  571233
  571913
  572121
  572315
  572801
  573011
  573115
  573263
  573544
  573661
  573695
  573703
  573855
  574680
  575771
  577689
  579181
  581168
  584495
  589377
  591677
  593198
  593965
  625868
  654352
  661694
  674909
  699787
  755832
  778681
]
1.96 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая красотка"
]
1.71 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая красивая"
]
1.65 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.