Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.64 ms
(87.08%)
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
  21323
  167756
  384492
  387143
  387647
  390207
  396784
  396922
  396989
  397145
  397678
  398354
  399738
  402020
  411880
  414248
  416294
  419951
  421038
  423688
  427449
  428849
  429764
  430468
  431607
  434861
  435635
  443523
  444005
  444117
  446499
  446855
  448315
  453249
  454292
  454685
  456132
  457097
  457209
  457732
  459521
  465076
  469210
  473756
  475250
  475448
  477407
  482330
  492178
  498620
  507258
  508962
  510579
  510580
  510669
  515749
  519904
  520629
  525193
  525197
  530685
  532941
  540310
  541840
  545532
  550616
  550732
  550739
  550772
  552002
  554337
  556400
  557199
  557543
  558374
  559160
  564223
  566013
  567833
  568552
  568869
  570729
  572721
  572740
  572746
  577184
  577251
  578499
  579347
  582669
  590966
  595705
  598270
  601081
  604086
  605397
  605848
  605929
  611314
  615005
  619441
  619451
  619474
  619487
  622656
  639310
  648794
  654451
  662078
  672031
  672261
  680892
  686082
  689688
  712154
  720948
  766566
  766607
  795539
  808775
]
16.23 ms
(8.04%)
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
  414248
  387647
  397678
  427449
  454292
  446499
  540310
  552002
  558374
  566013
  572721
  577184
  582669
  550772
  568552
  680892
  550616
  556400
  605397
  619474
  390207
  416294
  396784
  444005
  443523
  515749
  387143
  402020
  568869
  672031
  766566
  396922
  444117
  435635
  475250
  448315
  465076
  520629
  510669
  492178
  554337
  578499
  672261
  712154
  654451
  557543
  570729
  611314
  619441
  601081
  605848
  619487
  622656
  639310
  795539
  808775
  423688
  457097
  510579
  590966
  498620
  508962
  429764
  519904
  598270
  619451
  397145
  431607
  419951
  550732
  550739
  577251
  689688
  662078
  572746
  595705
  604086
  615005
  396989
  430468
  477407
  446855
  454685
  525193
  532941
  530685
  557199
  545532
  686082
  564223
  605929
  766607
  720948
  469210
  482330
  525197
  384492
  167756
  21323
  398354
  399738
  411880
  428849
  421038
  434861
  456132
  457209
  457732
  453249
  459521
  475448
  510580
  507258
  473756
  567833
  572740
  579347
  541840
  559160
  648794
]
3.32 ms
(1.65%)
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
  21323
  167756
  384492
  387143
  387647
  390207
  396784
  396922
  396989
  397145
  397678
  398354
  399738
  402020
  411880
  414248
  416294
  419951
  421038
  423688
  427449
  428849
  429764
  430468
  431607
  434861
  435635
  443523
  444005
  444117
  446499
  446855
  448315
  453249
  454292
  454685
  456132
  457097
  457209
  457732
  459521
  465076
  469210
  473756
  475250
  475448
  477407
  482330
  492178
  498620
  507258
  508962
  510579
  510580
  510669
  515749
  519904
  520629
  525193
  525197
  530685
  532941
  540310
  541840
  545532
  550616
  550732
  550739
  550772
  552002
  554337
  556400
  557199
  557543
  558374
  559160
  564223
  566013
  567833
  568552
  568869
  570729
  572721
  572740
  572746
  577184
  577251
  578499
  579347
  582669
  590966
  595705
  598270
  601081
  604086
  605397
  605848
  605929
  611314
  615005
  619441
  619451
  619474
  619487
  622656
  639310
  648794
  654451
  662078
  672031
  672261
  680892
  686082
  689688
  712154
  720948
  766566
  766607
  795539
  808775
]
1.77 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian ass"
]
1.73 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк жоп"
]
1.41 ms
(0.70%)
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.