Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.15 ms
(86.84%)
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
  102334
  185123
  185861
  320786
  384864
  390292
  395509
  396569
  399628
  404740
  405088
  405224
  406080
  406425
  417134
  420753
  423982
  425164
  425662
  426561
  427295
  428255
  428513
  429357
  434440
  435078
  437437
  437710
  441102
  441758
  443095
  443865
  444540
  445458
  445529
  447357
  447488
  448182
  448652
  448824
  453560
  453697
  454648
  456071
  456579
  457292
  458879
  459133
  460131
  460378
  462726
  462870
  463978
  464474
  465226
  465989
  467110
  468112
  468687
  469549
  471377
  473369
  475481
  475711
  478035
  478638
  481971
  482272
  485046
  494185
  497029
  497635
  498303
  499651
  499834
  501750
  501772
  501786
  501799
  503994
  504339
  505042
  505869
  506795
  510041
  511931
  512593
  514936
  518590
  520726
  523971
  526167
  538365
  551402
  551409
  554983
  562225
  565335
  568348
  569539
  572013
  572030
  573930
  595865
  596710
  599935
  621158
  628346
  653243
  663533
  674600
  683446
  702383
  773895
  783507
  784364
  790913
  801412
  815482
  820900
]
16.25 ms
(8.29%)
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
  773895
  447488
  405224
  185123
  501750
  501799
  497029
  499834
  523971
  425164
  435078
  478638
  683446
  457292
  460131
  468112
  478035
  674600
  783507
  784364
  448652
  459133
  445529
  454648
  384864
  185861
  320786
  406080
  406425
  447357
  468687
  506795
  538365
  573930
  663533
  595865
  621158
  396569
  464474
  485046
  505042
  501786
  404740
  815482
  102334
  399628
  467110
  473369
  448182
  448824
  465989
  497635
  518590
  503994
  504339
  572030
  551409
  653243
  569539
  628346
  469549
  475481
  437437
  405088
  458879
  425662
  437710
  501772
  526167
  505869
  512593
  599935
  481971
  702383
  801412
  426561
  434440
  820900
  445458
  456579
  554983
  572013
  596710
  471377
  475711
  427295
  453697
  462726
  498303
  499651
  790913
  453560
  423982
  395509
  390292
  441758
  420753
  444540
  417134
  428255
  443865
  428513
  429357
  441102
  443095
  463978
  456071
  462870
  465226
  510041
  511931
  520726
  494185
  514936
  460378
  482272
  551402
  565335
  562225
  568348
]
2.85 ms
(1.45%)
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
  102334
  185123
  185861
  320786
  384864
  390292
  395509
  396569
  399628
  404740
  405088
  405224
  406080
  406425
  417134
  420753
  423982
  425164
  425662
  426561
  427295
  428255
  428513
  429357
  434440
  435078
  437437
  437710
  441102
  441758
  443095
  443865
  444540
  445458
  445529
  447357
  447488
  448182
  448652
  448824
  453560
  453697
  454648
  456071
  456579
  457292
  458879
  459133
  460131
  460378
  462726
  462870
  463978
  464474
  465226
  465989
  467110
  468112
  468687
  469549
  471377
  473369
  475481
  475711
  478035
  478638
  481971
  482272
  485046
  494185
  497029
  497635
  498303
  499651
  499834
  501750
  501772
  501786
  501799
  503994
  504339
  505042
  505869
  506795
  510041
  511931
  512593
  514936
  518590
  520726
  523971
  526167
  538365
  551402
  551409
  554983
  562225
  565335
  568348
  569539
  572013
  572030
  573930
  595865
  596710
  599935
  621158
  628346
  653243
  663533
  674600
  683446
  702383
  773895
  783507
  784364
  790913
  801412
  815482
  820900
]
1.88 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex oil"
]
1.70 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс масл"
]
1.62 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.76%)
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.