Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
271.20 ms
(91.64%)
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
  13428
  29295
  34104
  38857
  182340
  231260
  335993
  386990
  396029
  397365
  398928
  400050
  400524
  402425
  412551
  413702
  418013
  424043
  424238
  424528
  426647
  432374
  432518
  441928
  442463
  450046
  458662
  460319
  463403
  472624
  473113
  475956
  476799
  505135
  509673
  511314
  514001
  515621
  520850
  526831
  528322
  529340
  533715
  534419
  537097
  544024
  552754
  560957
  563409
  567248
  574768
  576686
  577315
  580329
  585550
  588334
  588600
  592810
  592994
  595762
  603359
  606040
  606087
  610697
  613304
  622416
  635615
  639127
  650749
  663281
  672821
  675085
  687307
  695544
  696914
  698882
  706640
  710337
  714316
  716119
  718054
  718878
  719028
  731544
  738325
  742457
  747308
  750195
  751321
  752842
  754303
  754756
  755897
  756522
  759160
  761247
  769467
  770107
  777659
  779495
  780771
  784510
  785327
  789259
  791029
  791455
  792002
  793944
  795612
  806596
  807582
  810096
  814309
  814438
  814765
  824138
  824450
  828451
  828819
]
15.63 ms
(5.28%)
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
  755897
  769467
  754303
  731544
  780771
  789259
  791029
  182340
  412551
  606087
  386990
  580329
  511314
  828819
  675085
  622416
  400050
  398928
  460319
  526831
  814438
  650749
  706640
  806596
  784510
  751321
  752842
  750195
  785327
  544024
  574768
  432374
  418013
  718054
  807582
  441928
  560957
  754756
  473113
  396029
  413702
  463403
  585550
  595762
  613304
  472624
  505135
  588600
  635615
  458662
  426647
  475956
  476799
  520850
  515621
  402425
  610697
  537097
  759160
  424528
  824138
  824450
  828081
  231260
  335993
  38857
  828451
  810096
  397365
  528322
  29295
  814765
  533715
  534419
  577315
  672821
  695544
  698882
  714316
  719028
  663281
  687307
  696914
  552754
  588334
  779495
  795612
  793944
  770107
  738325
  747308
  742457
  761247
  639127
  710337
  716119
  777659
  567248
  576686
  592810
  814309
  718878
  792002
  791455
  756522
  606040
  432518
  400524
  442463
  424043
  563409
  603359
  592994
  34104
  514001
  509673
  13428
  424238
  450046
  529340
]
2.95 ms
(1.00%)
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
  13428
  29295
  34104
  38857
  182340
  231260
  335993
  386990
  396029
  397365
  398928
  400050
  400524
  402425
  412551
  413702
  418013
  424043
  424238
  424528
  426647
  432374
  432518
  441928
  442463
  450046
  458662
  460319
  463403
  472624
  473113
  475956
  476799
  505135
  509673
  511314
  514001
  515621
  520850
  526831
  528322
  529340
  533715
  534419
  537097
  544024
  552754
  560957
  563409
  567248
  574768
  576686
  577315
  580329
  585550
  588334
  588600
  592810
  592994
  595762
  603359
  606040
  606087
  610697
  613304
  622416
  635615
  639127
  650749
  663281
  672821
  675085
  687307
  695544
  696914
  698882
  706640
  710337
  714316
  716119
  718054
  718878
  719028
  731544
  738325
  742457
  747308
  750195
  751321
  752842
  754303
  754756
  755897
  756522
  759160
  761247
  769467
  770107
  777659
  779495
  780771
  784510
  785327
  789259
  791029
  791455
  792002
  793944
  795612
  806596
  807582
  810096
  814309
  814438
  814765
  824138
  824450
  828451
  828819
]
1.63 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел леопардов трусик нижн бел"
]
1.55 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в чулках и леопардовых трусах"
]
1.40 ms
(0.47%)
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.