Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.20 ms
(83.67%)
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
  43207
  84130
  378256
  382844
  383952
  384574
  384905
  387000
  396881
  398000
  398976
  400593
  401877
  404491
  406648
  411498
  412183
  416878
  417739
  417746
  421816
  421899
  422282
  426571
  427561
  427819
  427898
  427912
  429869
  430088
  431484
  431501
  437961
  442810
  443412
  443782
  446086
  447554
  448701
  450800
  454081
  454819
  459840
  463222
  467478
  469242
  474093
  483087
  485969
  499027
  499296
  502603
  506000
  511794
  517039
  517535
  518484
  520162
  520676
  521727
  522989
  523248
  527565
  531347
  532334
  532563
  533340
  534463
  535309
  535931
  537391
  539593
  545788
  546112
  546640
  548844
  549105
  549222
  551932
  554448
  554449
  554542
  554914
  555285
  555402
  555435
  557089
  557327
  557892
  558755
  559841
  560885
  561283
  561918
  563431
  563619
  565749
  571664
  574047
  574630
  575703
  576680
  578493
  578790
  583933
  587866
  589697
  591463
  591566
  592719
  594212
  605855
  606162
  613851
  623487
  623922
  624664
  649100
  664289
  677147
]
14.37 ms
(9.23%)
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
  527565
  613851
  623922
  427898
  383952
  387000
  84130
  623487
  499296
  531347
  549222
  551932
  554448
  554542
  555402
  557327
  558755
  554449
  555435
  563431
  578790
  561283
  583933
  589697
  454081
  546112
  421816
  459840
  448701
  401877
  384905
  398976
  400593
  43207
  398000
  417739
  427561
  437961
  442810
  454819
  474093
  506000
  502603
  469242
  555285
  605855
  606162
  591566
  587866
  591463
  594212
  624664
  427819
  421899
  426571
  429869
  467478
  406648
  416878
  447554
  411498
  443782
  450800
  382844
  378256
  384574
  396881
  404491
  417746
  422282
  431501
  427912
  443412
  431484
  412183
  430088
  463222
  446086
  483087
  517039
  518484
  532334
  535309
  539593
  534463
  520162
  520676
  521727
  522989
  532563
  533340
  535931
  537391
  499027
  511794
  517535
  523248
  485969
  571664
  574047
  578493
  548844
  557892
  560885
  576680
  545788
  549105
  554914
  557089
  561918
  563619
  565749
  575703
  649100
  664289
  677147
  546640
  559841
  574630
  592719
]
3.04 ms
(1.96%)
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
  43207
  84130
  378256
  382844
  383952
  384574
  384905
  387000
  396881
  398000
  398976
  400593
  401877
  404491
  406648
  411498
  412183
  416878
  417739
  417746
  421816
  421899
  422282
  426571
  427561
  427819
  427898
  427912
  429869
  430088
  431484
  431501
  437961
  442810
  443412
  443782
  446086
  447554
  448701
  450800
  454081
  454819
  459840
  463222
  467478
  469242
  474093
  483087
  485969
  499027
  499296
  502603
  506000
  511794
  517039
  517535
  518484
  520162
  520676
  521727
  522989
  523248
  527565
  531347
  532334
  532563
  533340
  534463
  535309
  535931
  537391
  539593
  545788
  546112
  546640
  548844
  549105
  549222
  551932
  554448
  554449
  554542
  554914
  555285
  555402
  555435
  557089
  557327
  557892
  558755
  559841
  560885
  561283
  561918
  563431
  563619
  565749
  571664
  574047
  574630
  575703
  576680
  578493
  578790
  583933
  587866
  589697
  591463
  591566
  592719
  594212
  605855
  606162
  613851
  623487
  623922
  624664
  649100
  664289
  677147
]
2.26 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большие задници волос…"
]
2.17 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп волос"
]
1.68 ms
(1.08%)
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.