Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.71 ms
(52.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
163.88 ms
(41.40%)
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
  7178
  107606
  188398
  188610
  340635
  379559
  384382
  388545
  388732
  395550
  398562
  401666
  402409
  407350
  413183
  413829
  441910
  443913
  460318
  464929
  464975
  477541
  478582
  486192
  491830
  491837
  494454
  497701
  500806
  502108
  513114
  517069
  520908
  520979
  522510
  522614
  523835
  530465
  530688
  531556
  537263
  554463
  555066
  555093
  560999
  563945
  564731
  580712
  600351
  605129
  605209
  610042
  637430
  639755
  649859
  668529
  671599
  672105
  680437
  686035
  691228
  698496
  707307
  707310
  710510
  713486
  715524
  719929
  720171
  720621
  726612
  726988
  727789
  728406
  731247
  739994
  744989
  746689
  748504
  748935
  752703
  755391
  756223
  761323
  765454
  765478
  768330
  769887
  770304
  770949
  776184
  777727
  790009
  796957
  799650
  800329
  800370
  800597
  801338
  801807
  801909
  802036
  802450
  807353
  809128
  815180
  815890
  815910
  816063
  816886
  816991
  820875
  821219
  821238
  821521
  821672
  822421
  823240
  823293
  825979
]
18.14 ms
(4.58%)
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
  801909
  441910
  477541
  610042
  464975
  395550
  825979
  402409
  340635
  443913
  413829
  821219
  823240
  820875
  821672
  823293
  530688
  497701
  563945
  680437
  686035
  713486
  649859
  671599
  672105
  691228
  600351
  639755
  637430
  799650
  800597
  809128
  801338
  802036
  802450
  765478
  800370
  728406
  731247
  746689
  744989
  756223
  765454
  769887
  770949
  755391
  768330
  726988
  748935
  770304
  605209
  698496
  707307
  707310
  720171
  776184
  800329
  801807
  107606
  188398
  388545
  464929
  531556
  564731
  668529
  555093
  580712
  807353
  777727
  761323
  726612
  727789
  719929
  379559
  7178
  401666
  413183
  500806
  522614
  513114
  522510
  486192
  398562
  790009
  384382
  407350
  460318
  491830
  502108
  555066
  554463
  710510
  720621
  560999
  605129
  796957
  739994
  748504
  752703
  388732
  478582
  188610
  491837
  494454
  517069
  537263
  520908
  520979
  523835
  815180
  815890
  816063
  816991
  816886
  821238
  822421
  815910
  821521
  530465
  715524
]
2.60 ms
(0.66%)
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
  7178
  107606
  188398
  188610
  340635
  379559
  384382
  388545
  388732
  395550
  398562
  401666
  402409
  407350
  413183
  413829
  441910
  443913
  460318
  464929
  464975
  477541
  478582
  486192
  491830
  491837
  494454
  497701
  500806
  502108
  513114
  517069
  520908
  520979
  522510
  522614
  523835
  530465
  530688
  531556
  537263
  554463
  555066
  555093
  560999
  563945
  564731
  580712
  600351
  605129
  605209
  610042
  637430
  639755
  649859
  668529
  671599
  672105
  680437
  686035
  691228
  698496
  707307
  707310
  710510
  713486
  715524
  719929
  720171
  720621
  726612
  726988
  727789
  728406
  731247
  739994
  744989
  746689
  748504
  748935
  752703
  755391
  756223
  761323
  765454
  765478
  768330
  769887
  770304
  770949
  776184
  777727
  790009
  796957
  799650
  800329
  800370
  800597
  801338
  801807
  801909
  802036
  802450
  807353
  809128
  815180
  815890
  815910
  816063
  816886
  816991
  820875
  821219
  821238
  821521
  821672
  822421
  823240
  823293
  825979
]
1.61 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал с мамой зрелой"
]
1.61 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал мам женщин зрелая женщин"
]
1.29 ms
(0.33%)
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.