Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.83 ms
(85.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
  187203
  370949
  382020
  382140
  383828
  387251
  387544
  388713
  390447
  390574
  391392
  395513
  404528
  407819
  414385
  415145
  418876
  421325
  424741
  425503
  428223
  428453
  430144
  433217
  436134
  441110
  443171
  446313
  447276
  451127
  453471
  454186
  454192
  454208
  454714
  455058
  455957
  457389
  457775
  458707
  460418
  465592
  465788
  467075
  471445
  471648
  472241
  473891
  475679
  477071
  479258
  480809
  481345
  481663
  482483
  482505
  484396
  484439
  484683
  485751
  486531
  486789
  486955
  488560
  490474
  490877
  492648
  493203
  494204
  494563
  495678
  495714
  497798
  498037
  498081
  498702
  498763
  499073
  499184
  499549
  500940
  506535
  507165
  507209
  507739
  507901
  509260
  509376
  512607
  513964
  514289
  515572
  515635
  515643
  519343
  520583
  520935
  522978
  523175
  523634
  523778
  523834
  523852
  526071
  527224
  528800
  529401
  536462
  540552
  542525
  549968
  555987
  556467
  556938
  557244
  558021
  563053
  564445
  567431
  573734
]
17.53 ms
(9.33%)
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
  498702
  507165
  514289
  515635
  519343
  520935
  522978
  527224
  484396
  484683
  490474
  494204
  498037
  506535
  509260
  523175
  523634
  523778
  526071
  484439
  490877
  492648
  494563
  495678
  495714
  498081
  498763
  499073
  499184
  512607
  515643
  523834
  523852
  528800
  383828
  187203
  395513
  370949
  382020
  382140
  388713
  387544
  387251
  390574
  390447
  391392
  404528
  418876
  425503
  428453
  433217
  436134
  441110
  414385
  421325
  407819
  415145
  430144
  443171
  424741
  428223
  482483
  482505
  446313
  451127
  453471
  454186
  455957
  457389
  457775
  458707
  471445
  479258
  486955
  447276
  454714
  475679
  493203
  454192
  454208
  455058
  465592
  465788
  472241
  473891
  477071
  481663
  485751
  486531
  488560
  499549
  507901
  509376
  520583
  529401
  540552
  507209
  513964
  500940
  497798
  507739
  515572
  536462
  460418
  467075
  471648
  480809
  481345
  486789
  556467
  557244
  558021
  563053
  564445
  573734
  555987
  556938
  567431
  542525
  549968
]
2.72 ms
(1.45%)
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
  187203
  370949
  382020
  382140
  383828
  387251
  387544
  388713
  390447
  390574
  391392
  395513
  404528
  407819
  414385
  415145
  418876
  421325
  424741
  425503
  428223
  428453
  430144
  433217
  436134
  441110
  443171
  446313
  447276
  451127
  453471
  454186
  454192
  454208
  454714
  455058
  455957
  457389
  457775
  458707
  460418
  465592
  465788
  467075
  471445
  471648
  472241
  473891
  475679
  477071
  479258
  480809
  481345
  481663
  482483
  482505
  484396
  484439
  484683
  485751
  486531
  486789
  486955
  488560
  490474
  490877
  492648
  493203
  494204
  494563
  495678
  495714
  497798
  498037
  498081
  498702
  498763
  499073
  499184
  499549
  500940
  506535
  507165
  507209
  507739
  507901
  509260
  509376
  512607
  513964
  514289
  515572
  515635
  515643
  519343
  520583
  520935
  522978
  523175
  523634
  523778
  523834
  523852
  526071
  527224
  528800
  529401
  536462
  540552
  542525
  549968
  555987
  556467
  556938
  557244
  558021
  563053
  564445
  567431
  573734
]
1.96 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "даму"
]
1.79 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дам"
]
1.34 ms
(0.71%)
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.