Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.37 ms
(83.02%)
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
  95991
  382434
  389519
  400513
  407903
  411321
  411356
  411394
  421823
  421835
  421884
  422154
  422187
  423777
  428883
  429333
  429598
  438455
  439787
  444140
  444888
  445390
  450657
  451030
  451477
  451494
  456328
  456408
  459790
  460728
  460762
  463458
  464303
  466893
  467489
  467503
  469199
  469277
  469372
  476013
  476776
  479928
  480988
  481186
  481316
  481451
  484123
  485297
  486340
  487656
  488128
  490436
  490948
  491914
  492057
  492507
  493228
  494015
  495239
  495256
  496028
  502755
  504055
  504635
  506693
  506894
  507412
  511152
  512030
  513616
  515343
  516550
  516658
  516835
  517798
  518598
  519582
  524446
  524520
  528476
  528620
  536457
  540977
  542987
  546783
  547617
  547754
  549849
  551652
  552799
  553003
  554233
  554261
  557032
  558505
  563057
  563154
  563400
  566997
  567072
  570328
  570626
  573113
  573451
  581925
  582068
  582587
  590573
  605364
  609071
  611422
  613356
  622302
  624876
  686573
  730688
  750756
  778699
  789925
  794665
]
15.29 ms
(10.63%)
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
  464303
  516658
  491914
  496028
  488128
  493228
  494015
  515343
  546783
  573113
  542987
  554233
  553003
  570626
  551652
  566997
  609071
  789925
  730688
  476776
  481451
  423777
  451477
  400513
  407903
  481316
  451030
  490948
  506894
  517798
  502755
  487656
  528476
  570328
  686573
  563154
  778699
  750756
  429333
  459790
  460762
  563400
  411394
  450657
  513616
  495256
  582068
  492057
  95991
  567072
  495239
  422154
  421884
  439787
  554261
  557032
  558505
  563057
  582587
  552799
  549849
  547617
  573451
  605364
  622302
  624876
  421823
  460728
  466893
  429598
  467489
  480988
  421835
  444888
  445390
  469372
  456328
  463458
  481186
  422187
  476013
  512030
  536457
  484123
  524446
  506693
  485297
  492507
  516550
  516835
  524520
  528620
  540977
  794665
  469277
  581925
  611422
  444140
  451494
  479928
  438455
  504055
  507412
  467503
  511152
  519582
  490436
  518598
  547754
  613356
  590573
  382434
  428883
  469199
  411321
  456408
  389519
  411356
  504635
  486340
]
2.41 ms
(1.67%)
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
  95991
  382434
  389519
  400513
  407903
  411321
  411356
  411394
  421823
  421835
  421884
  422154
  422187
  423777
  428883
  429333
  429598
  438455
  439787
  444140
  444888
  445390
  450657
  451030
  451477
  451494
  456328
  456408
  459790
  460728
  460762
  463458
  464303
  466893
  467489
  467503
  469199
  469277
  469372
  476013
  476776
  479928
  480988
  481186
  481316
  481451
  484123
  485297
  486340
  487656
  488128
  490436
  490948
  491914
  492057
  492507
  493228
  494015
  495239
  495256
  496028
  502755
  504055
  504635
  506693
  506894
  507412
  511152
  512030
  513616
  515343
  516550
  516658
  516835
  517798
  518598
  519582
  524446
  524520
  528476
  528620
  536457
  540977
  542987
  546783
  547617
  547754
  549849
  551652
  552799
  553003
  554233
  554261
  557032
  558505
  563057
  563154
  563400
  566997
  567072
  570328
  570626
  573113
  573451
  581925
  582068
  582587
  590573
  605364
  609071
  611422
  613356
  622302
  624876
  686573
  730688
  750756
  778699
  789925
  794665
]
1.98 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская красное белье…"
]
1.71 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск красн бел"
]
1.38 ms
(0.96%)
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.