Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.25 ms
(86.58%)
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
  95586
  95886
  96118
  96231
  97401
  129722
  381775
  385457
  387562
  395408
  395440
  398041
  401309
  404957
  410094
  412189
  414357
  415618
  415954
  417674
  417829
  426390
  427447
  428383
  434275
  444645
  446394
  448880
  451527
  452311
  454364
  454802
  460889
  461723
  465253
  466355
  473739
  476108
  477020
  478647
  479462
  481147
  508180
  513882
  513893
  516091
  516350
  522043
  531286
  536614
  537888
  558119
  565172
  572763
  582821
  597239
  599969
  601150
  602506
  606489
  615918
  621656
  629243
  630524
  632001
  632006
  633497
  637008
  647906
  647910
  651199
  663551
  668527
  670761
  671721
  672710
  678141
  678532
  679029
  683470
  683494
  685791
  686821
  697025
  699549
  700282
  704205
  708421
  710794
  713375
  715371
  720077
  721399
  721417
  725608
  725630
  728272
  729288
  733877
  737663
  738483
  738619
  741537
  743309
  748530
  748779
  748943
  750469
  764295
  769870
  770923
  774650
  775269
  775915
  776239
  789516
  806580
  820769
  826623
  827523
]
18.49 ms
(8.83%)
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
  748943
  764295
  395408
  395440
  428383
  479462
  513893
  708421
  651199
  670761
  671721
  686821
  699549
  683470
  713375
  715371
  606489
  776239
  775915
  725630
  789516
  728272
  750469
  770923
  738483
  769870
  741537
  743309
  738619
  720077
  721399
  775269
  401309
  451527
  95886
  381775
  385457
  387562
  537888
  415618
  414357
  444645
  446394
  454364
  476108
  452311
  558119
  582821
  678141
  679029
  685791
  602506
  621656
  632006
  601150
  632001
  806580
  615918
  417674
  404957
  434275
  466355
  516350
  522043
  700282
  774650
  410094
  748530
  96118
  826623
  531286
  683494
  663551
  729288
  725608
  748779
  737663
  417829
  427447
  412189
  478647
  454802
  513882
  508180
  473739
  477020
  481147
  572763
  678532
  710794
  672710
  704205
  647906
  565172
  599969
  630524
  637008
  597239
  633497
  461723
  398041
  415954
  516091
  721417
  629243
  647910
  668527
  697025
  733877
  95586
  129722
  97401
  96231
  426390
  820769
  827523
  465253
  460889
  448880
  536614
]
2.67 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen double penetration"
]
2.35 ms
(1.12%)
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
  95586
  95886
  96118
  96231
  97401
  129722
  381775
  385457
  387562
  395408
  395440
  398041
  401309
  404957
  410094
  412189
  414357
  415618
  415954
  417674
  417829
  426390
  427447
  428383
  434275
  444645
  446394
  448880
  451527
  452311
  454364
  454802
  460889
  461723
  465253
  466355
  473739
  476108
  477020
  478647
  479462
  481147
  508180
  513882
  513893
  516091
  516350
  522043
  531286
  536614
  537888
  558119
  565172
  572763
  582821
  597239
  599969
  601150
  602506
  606489
  615918
  621656
  629243
  630524
  632001
  632006
  633497
  637008
  647906
  647910
  651199
  663551
  668527
  670761
  671721
  672710
  678141
  678532
  679029
  683470
  683494
  685791
  686821
  697025
  699549
  700282
  704205
  708421
  710794
  713375
  715371
  720077
  721399
  721417
  725608
  725630
  728272
  729288
  733877
  737663
  738483
  738619
  741537
  743309
  748530
  748779
  748943
  750469
  764295
  769870
  770923
  774650
  775269
  775915
  776239
  789516
  806580
  820769
  826623
  827523
]
1.72 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen double penetration"
]
1.51 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen double penetration"
]

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.