Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.65 ms
(84.60%)
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
  4510
  89199
  163135
  373277
  382204
  383347
  384568
  385618
  387759
  389319
  392572
  397088
  401806
  404738
  406010
  415958
  416522
  416581
  416669
  416676
  418365
  419052
  419664
  420171
  420625
  421612
  428750
  429333
  430262
  431028
  431038
  432480
  439033
  441424
  443436
  444449
  445440
  446798
  446946
  447881
  448607
  450670
  452775
  453816
  456132
  457035
  457133
  458242
  461493
  462236
  462520
  462845
  462985
  464836
  466214
  466478
  467980
  470062
  471001
  471090
  471152
  475420
  475814
  476465
  477393
  483463
  483512
  485301
  486856
  488796
  489876
  490128
  491100
  491137
  492836
  499302
  499931
  508070
  509443
  509984
  511428
  513015
  513184
  513860
  523403
  525365
  526019
  533970
  545037
  548753
  550465
  561748
  563360
  566945
  567120
  569566
  572224
  577726
  580225
  587107
  593989
  597284
  598668
  602221
  602556
  602608
  606670
  616295
  622346
  625271
  631258
  635203
  644343
  650748
  700237
  757906
  762995
  797373
  799613
  814464
]
16.39 ms
(9.52%)
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
  420625
  476465
  499302
  489876
  511428
  513860
  483463
  486856
  387759
  513184
  606670
  625271
  762995
  443436
  462845
  416522
  616295
  466478
  491100
  462985
  4510
  799613
  432480
  384568
  373277
  700237
  163135
  593989
  392572
  415958
  491137
  453816
  550465
  545037
  447881
  428750
  420171
  492836
  525365
  526019
  488796
  513015
  485301
  814464
  572224
  635203
  602221
  383347
  457035
  444449
  508070
  509984
  389319
  441424
  397088
  89199
  446798
  470062
  445440
  464836
  602556
  382204
  416669
  475420
  499931
  561748
  548753
  650748
  598668
  757906
  448607
  462236
  416581
  416676
  431028
  431038
  439033
  430262
  452775
  458242
  404738
  421612
  419052
  456132
  457133
  475814
  533970
  471152
  566945
  569566
  587107
  622346
  631258
  385618
  462520
  471090
  429333
  466214
  467980
  461493
  523403
  509443
  797373
  446946
  483512
  477393
  406010
  418365
  401806
  450670
  490128
  471001
  563360
  577726
  567120
  580225
  602608
  597284
  644343
  419664
]
2.89 ms
(1.68%)
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
  4510
  89199
  163135
  373277
  382204
  383347
  384568
  385618
  387759
  389319
  392572
  397088
  401806
  404738
  406010
  415958
  416522
  416581
  416669
  416676
  418365
  419052
  419664
  420171
  420625
  421612
  428750
  429333
  430262
  431028
  431038
  432480
  439033
  441424
  443436
  444449
  445440
  446798
  446946
  447881
  448607
  450670
  452775
  453816
  456132
  457035
  457133
  458242
  461493
  462236
  462520
  462845
  462985
  464836
  466214
  466478
  467980
  470062
  471001
  471090
  471152
  475420
  475814
  476465
  477393
  483463
  483512
  485301
  486856
  488796
  489876
  490128
  491100
  491137
  492836
  499302
  499931
  508070
  509443
  509984
  511428
  513015
  513184
  513860
  523403
  525365
  526019
  533970
  545037
  548753
  550465
  561748
  563360
  566945
  567120
  569566
  572224
  577726
  580225
  587107
  593989
  597284
  598668
  602221
  602556
  602608
  606670
  616295
  622346
  625271
  631258
  635203
  644343
  650748
  700237
  757906
  762995
  797373
  799613
  814464
]
2.14 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер 18 девушк"
]
1.91 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam 18 girls"
]
1.71 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер 18 девушк"
]

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.