Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.94 ms
(82.99%)
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
  2291
  107495
  318463
  352045
  382489
  383823
  384030
  386414
  389062
  395685
  397605
  397865
  401202
  401398
  401773
  405112
  412403
  415928
  416215
  422243
  425490
  425992
  426917
  427359
  428054
  429430
  429839
  443142
  443776
  445112
  446545
  450563
  450816
  453021
  453091
  453635
  454446
  454973
  455757
  459372
  459899
  460923
  464545
  466069
  466941
  467835
  467914
  468953
  474104
  475900
  476282
  476356
  476495
  477715
  478011
  478933
  479038
  484564
  485741
  485980
  487356
  489396
  491157
  491461
  494592
  499051
  502025
  502061
  504024
  505640
  506824
  508163
  509639
  513975
  518828
  518829
  522563
  526642
  526967
  528772
  547920
  548036
  549248
  553235
  556436
  559038
  559279
  559645
  562962
  564794
  574678
  589780
  624466
  663367
  690092
  726698
  728975
  731752
  731754
  733110
  733473
  740611
  744988
  745922
  771482
  774403
  781812
  781962
  800023
  801064
  805265
  808057
  810715
  820368
  826169
  826380
  826381
  826384
  826889
  827419
]
18.54 ms
(10.69%)
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
  505640
  487356
  426917
  518828
  467835
  827419
  386414
  820368
  781962
  733473
  416215
  454446
  548036
  384030
  443142
  513975
  781812
  808057
  744988
  2291
  726698
  459899
  826380
  826381
  826889
  826169
  740611
  547920
  491461
  428054
  559645
  624466
  800023
  745922
  733110
  728975
  805265
  415928
  589780
  556436
  810715
  489396
  425992
  460923
  422243
  445112
  412403
  526642
  506824
  401773
  502061
  499051
  494592
  559279
  476356
  491157
  459372
  502025
  468953
  476282
  518829
  826384
  731754
  478933
  401202
  484564
  446545
  771482
  476495
  427359
  453021
  731752
  107495
  401398
  562962
  553235
  522563
  485980
  425490
  453635
  504024
  526967
  574678
  450563
  774403
  528772
  564794
  352045
  450816
  454973
  475900
  395685
  405112
  466069
  397605
  455757
  453091
  397865
  464545
  479038
  383823
  467914
  429430
  474104
  477715
  485741
  429839
  443776
  509639
  549248
  382489
  508163
  559038
  318463
  690092
  663367
  801064
  389062
  478011
  466941
]
3.10 ms
(1.79%)
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
  2291
  107495
  318463
  352045
  382489
  383823
  384030
  386414
  389062
  395685
  397605
  397865
  401202
  401398
  401773
  405112
  412403
  415928
  416215
  422243
  425490
  425992
  426917
  427359
  428054
  429430
  429839
  443142
  443776
  445112
  446545
  450563
  450816
  453021
  453091
  453635
  454446
  454973
  455757
  459372
  459899
  460923
  464545
  466069
  466941
  467835
  467914
  468953
  474104
  475900
  476282
  476356
  476495
  477715
  478011
  478933
  479038
  484564
  485741
  485980
  487356
  489396
  491157
  491461
  494592
  499051
  502025
  502061
  504024
  505640
  506824
  508163
  509639
  513975
  518828
  518829
  522563
  526642
  526967
  528772
  547920
  548036
  549248
  553235
  556436
  559038
  559279
  559645
  562962
  564794
  574678
  589780
  624466
  663367
  690092
  726698
  728975
  731752
  731754
  733110
  733473
  740611
  744988
  745922
  771482
  774403
  781812
  781962
  800023
  801064
  805265
  808057
  810715
  820368
  826169
  826380
  826381
  826384
  826889
  827419
]
2.27 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни толстушке"
]
2.09 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс полная"
]
1.87 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс полная"
]
1.64 ms
(0.94%)
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.