Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.62 ms
(85.48%)
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
  383068
  385852
  396326
  396784
  397128
  397759
  401859
  413732
  422762
  427268
  429540
  430392
  446480
  446499
  448734
  452533
  456641
  457752
  460488
  463729
  468753
  472949
  473751
  473755
  477408
  491454
  496800
  499818
  500570
  500680
  505353
  511266
  512033
  516436
  516853
  530667
  532261
  532591
  535630
  537566
  539950
  540130
  540201
  540213
  540310
  540313
  546292
  546493
  549087
  550639
  550732
  550739
  550772
  551962
  551978
  551993
  551999
  552000
  552002
  554320
  554340
  556400
  556408
  557681
  558374
  559874
  559875
  559945
  561372
  562051
  564595
  565470
  566013
  566845
  568552
  568553
  568562
  568613
  572721
  572746
  573213
  577046
  577184
  583648
  587898
  595705
  596860
  600537
  603082
  604009
  605069
  605397
  605418
  610365
  619420
  619435
  619474
  621025
  622625
  628909
  630930
  632727
  650359
  658555
  662200
  678195
  705547
  718955
  729065
  747956
  748663
  748667
  750448
  750449
  757158
  768090
  785005
  792722
  805671
  810416
]
14.76 ms
(8.85%)
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
  540201
  540213
  540130
  511266
  512033
  546493
  550732
  550739
  559874
  559875
  562051
  554340
  662200
  546292
  572746
  577046
  595705
  604009
  768090
  792722
  496800
  605418
  413732
  430392
  446480
  477408
  473755
  491454
  446499
  456641
  540310
  500680
  505353
  516436
  540313
  550639
  552002
  551962
  551978
  558374
  566013
  568553
  568562
  572721
  577184
  550772
  568552
  573213
  556400
  587898
  605397
  621025
  810416
  619474
  622625
  452533
  396784
  468753
  457752
  472949
  499818
  535630
  530667
  559945
  564595
  383068
  537566
  385852
  401859
  429540
  427268
  448734
  473751
  539950
  516853
  532261
  532591
  549087
  551993
  552000
  556408
  554320
  561372
  565470
  566845
  568613
  678195
  718955
  650359
  658555
  705547
  551999
  557681
  583648
  628909
  596860
  603082
  610365
  600537
  619420
  619435
  630930
  605069
  729065
  750448
  785005
  747956
  750449
  748663
  748667
  757158
  632727
  805671
  463729
  396326
  397759
  422762
  460488
  500570
  397128
]
2.67 ms
(1.60%)
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
  383068
  385852
  396326
  396784
  397128
  397759
  401859
  413732
  422762
  427268
  429540
  430392
  446480
  446499
  448734
  452533
  456641
  457752
  460488
  463729
  468753
  472949
  473751
  473755
  477408
  491454
  496800
  499818
  500570
  500680
  505353
  511266
  512033
  516436
  516853
  530667
  532261
  532591
  535630
  537566
  539950
  540130
  540201
  540213
  540310
  540313
  546292
  546493
  549087
  550639
  550732
  550739
  550772
  551962
  551978
  551993
  551999
  552000
  552002
  554320
  554340
  556400
  556408
  557681
  558374
  559874
  559875
  559945
  561372
  562051
  564595
  565470
  566013
  566845
  568552
  568553
  568562
  568613
  572721
  572746
  573213
  577046
  577184
  583648
  587898
  595705
  596860
  600537
  603082
  604009
  605069
  605397
  605418
  610365
  619420
  619435
  619474
  621025
  622625
  628909
  630930
  632727
  650359
  658555
  662200
  678195
  705547
  718955
  729065
  747956
  748663
  748667
  750448
  750449
  757158
  768090
  785005
  792722
  805671
  810416
]
1.81 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тощая азиатка"
]
1.67 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худая азиатк"
]
1.66 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая азиатк"
]
1.66 ms
(0.99%)
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.