Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.53 ms
(87.75%)
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
  9021
  14392
  34016
  54301
  114645
  142253
  161731
  187567
  382058
  382368
  383521
  386865
  400100
  415558
  422629
  430342
  443941
  449855
  449880
  464531
  466255
  466910
  477361
  482794
  490265
  491828
  492609
  502021
  505922
  507675
  520162
  534396
  543421
  551277
  557944
  563449
  564661
  567159
  572202
  574281
  579938
  583873
  585340
  596096
  603507
  603548
  603572
  608331
  609284
  612383
  622349
  629362
  634851
  637569
  641465
  644388
  645946
  645999
  649208
  649221
  650790
  653328
  659339
  663884
  664828
  670689
  676402
  678576
  678579
  679058
  681785
  682001
  693188
  693990
  694128
  696283
  699065
  701490
  703038
  703511
  705629
  710320
  712466
  715192
  720799
  721070
  721792
  722861
  724038
  724198
  729233
  730095
  732799
  736247
  742603
  742876
  744212
  751495
  756231
  784525
  785376
  792487
  792801
  800632
  804613
  805537
  805859
  810763
  814236
  815345
  818169
  818459
  820394
  820783
  821406
  821523
  821837
  822027
  822960
  826280
]
15.43 ms
(7.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
  543421
  826280
  491828
  449855
  477361
  564661
  712466
  732799
  505922
  736247
  821406
  187567
  492609
  650790
  664828
  682001
  114645
  676402
  551277
  490265
  583873
  415558
  534396
  386865
  466255
  482794
  703038
  742603
  670689
  693990
  603548
  563449
  645999
  785376
  820394
  729233
  422629
  520162
  653328
  715192
  609284
  724198
  641465
  663884
  557944
  644388
  818459
  820783
  721070
  649221
  810763
  703511
  54301
  637569
  822960
  815345
  821523
  699065
  805537
  724038
  800632
  805859
  784525
  161731
  579938
  751495
  705629
  634851
  792801
  818169
  814236
  710320
  382058
  596096
  567159
  449880
  603507
  612383
  744212
  382368
  659339
  742876
  721792
  792487
  142253
  466910
  9021
  574281
  34016
  572202
  502021
  822027
  678576
  804613
  694128
  693188
  603572
  678579
  679058
  720799
  622349
  756231
  629362
  585340
  383521
  821837
  730095
  464531
  701490
  400100
  507675
  696283
  649208
  722861
  608331
  14392
  430342
  681785
  443941
  645946
]
2.27 ms
(1.12%)
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
  9021
  14392
  34016
  54301
  114645
  142253
  161731
  187567
  382058
  382368
  383521
  386865
  400100
  415558
  422629
  430342
  443941
  449855
  449880
  464531
  466255
  466910
  477361
  482794
  490265
  491828
  492609
  502021
  505922
  507675
  520162
  534396
  543421
  551277
  557944
  563449
  564661
  567159
  572202
  574281
  579938
  583873
  585340
  596096
  603507
  603548
  603572
  608331
  609284
  612383
  622349
  629362
  634851
  637569
  641465
  644388
  645946
  645999
  649208
  649221
  650790
  653328
  659339
  663884
  664828
  670689
  676402
  678576
  678579
  679058
  681785
  682001
  693188
  693990
  694128
  696283
  699065
  701490
  703038
  703511
  705629
  710320
  712466
  715192
  720799
  721070
  721792
  722861
  724038
  724198
  729233
  730095
  732799
  736247
  742603
  742876
  744212
  751495
  756231
  784525
  785376
  792487
  792801
  800632
  804613
  805537
  805859
  810763
  814236
  815345
  818169
  818459
  820394
  820783
  821406
  821523
  821837
  822027
  822960
  826280
]
1.94 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жмж натуральные сиськ…"
]
1.82 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жмж секс втро натуральные сиськ без силикон"
]
1.79 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро натуральные сиськ без силикон"
]
1.67 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.