Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.75 ms
(82.44%)
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
  10229
  16971
  214560
  383418
  387599
  387651
  387915
  390644
  390888
  393496
  398268
  398695
  399522
  401262
  406125
  406176
  406449
  408129
  408194
  412930
  413824
  415036
  415239
  416320
  418339
  419160
  419264
  420648
  423414
  423736
  423782
  429939
  430209
  431671
  431771
  433212
  433250
  434215
  435703
  438852
  441978
  442922
  443080
  443099
  445411
  447531
  449133
  450098
  451831
  453417
  458604
  459148
  459754
  460168
  462602
  463077
  464135
  468026
  469566
  470145
  473963
  473970
  474066
  474862
  475125
  476752
  476753
  479527
  480389
  482237
  482632
  483006
  483574
  486098
  486934
  488141
  490496
  494335
  494759
  499544
  500324
  500518
  504662
  512687
  513182
  516558
  520763
  523975
  527942
  535010
  551468
  552331
  560038
  560531
  561639
  565518
  566584
  576161
  579384
  586844
  591730
  592431
  593487
  593499
  600036
  612930
  654381
  657776
  707479
  749256
  750799
  757848
  759399
  773346
  778009
  788279
  793201
  796917
  810069
  818515
]
16.57 ms
(11.31%)
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
  214560
  657776
  565518
  778009
  788279
  757848
  793201
  10229
  494759
  612930
  750799
  406176
  449133
  460168
  500324
  579384
  586844
  591730
  475125
  419264
  500518
  479527
  420648
  433212
  474066
  474862
  415036
  818515
  458604
  707479
  759399
  773346
  387599
  482632
  418339
  383418
  406125
  482237
  576161
  469566
  473963
  16971
  552331
  593499
  520763
  390888
  430209
  423414
  476753
  593487
  443099
  490496
  387915
  398268
  406449
  412930
  483006
  566584
  387651
  415239
  442922
  445411
  447531
  523975
  516558
  600036
  476752
  443080
  535010
  441978
  796917
  749256
  401262
  435703
  459754
  463077
  560531
  408129
  416320
  431771
  470145
  486098
  488141
  499544
  433250
  654381
  527942
  486934
  408194
  419160
  423736
  459148
  480389
  462602
  494335
  561639
  390644
  399522
  434215
  450098
  483574
  551468
  473970
  513182
  393496
  451831
  453417
  468026
  512687
  560038
  592431
  810069
  431671
  438852
  423782
  413824
  398695
  429939
  464135
  504662
]
2.46 ms
(1.68%)
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
  10229
  16971
  214560
  383418
  387599
  387651
  387915
  390644
  390888
  393496
  398268
  398695
  399522
  401262
  406125
  406176
  406449
  408129
  408194
  412930
  413824
  415036
  415239
  416320
  418339
  419160
  419264
  420648
  423414
  423736
  423782
  429939
  430209
  431671
  431771
  433212
  433250
  434215
  435703
  438852
  441978
  442922
  443080
  443099
  445411
  447531
  449133
  450098
  451831
  453417
  458604
  459148
  459754
  460168
  462602
  463077
  464135
  468026
  469566
  470145
  473963
  473970
  474066
  474862
  475125
  476752
  476753
  479527
  480389
  482237
  482632
  483006
  483574
  486098
  486934
  488141
  490496
  494335
  494759
  499544
  500324
  500518
  504662
  512687
  513182
  516558
  520763
  523975
  527942
  535010
  551468
  552331
  560038
  560531
  561639
  565518
  566584
  576161
  579384
  586844
  591730
  592431
  593487
  593499
  600036
  612930
  654381
  657776
  707479
  749256
  750799
  757848
  759399
  773346
  778009
  788279
  793201
  796917
  810069
  818515
]
1.80 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс игрушк парен"
]
1.66 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс игрушк парен"
]
1.65 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс игрушки и партнеры"
]
1.59 ms
(1.08%)
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.