Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.43 ms
(84.99%)
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
  148814
  382112
  398690
  417955
  420105
  447359
  451175
  456214
  456610
  456975
  457338
  466327
  467684
  470141
  479225
  482615
  485040
  489285
  492022
  498195
  499066
  499174
  504740
  508989
  511840
  514147
  516618
  517018
  518628
  520933
  521789
  523778
  526767
  527786
  528820
  529728
  529870
  530390
  530431
  531264
  531574
  536375
  542862
  549112
  552273
  560281
  561296
  565842
  567223
  570927
  575769
  579872
  579981
  587216
  588359
  598859
  613798
  618531
  628245
  646682
  655840
  660249
  661652
  689964
  698021
  699480
  713964
  714279
  719829
  722349
  724789
  725384
  726055
  727423
  728482
  730363
  732816
  733759
  740484
  751411
  751437
  752502
  754700
  760696
  763276
  768499
  772216
  773291
  777113
  777204
  778569
  782755
  782762
  782773
  782776
  786515
  788093
  792126
  793201
  793722
  793724
  795002
  795945
  797215
  798704
  801067
  803194
  806085
  806864
  810582
  811806
  814312
  814697
  817073
  817126
  818069
  818841
  825516
  826863
  827308
]
11.54 ms
(8.21%)
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
  520933
  479225
  570927
  457338
  456975
  485040
  567223
  588359
  417955
  542862
  598859
  818069
  521789
  530431
  722349
  613798
  777113
  778569
  786515
  795002
  801067
  782773
  725384
  726055
  733759
  773291
  777204
  793201
  382112
  714279
  811806
  552273
  817073
  529728
  660249
  793722
  806864
  727423
  560281
  511840
  814312
  719829
  792126
  782755
  810582
  536375
  498195
  451175
  561296
  826863
  814697
  526767
  689964
  797215
  782776
  754700
  148814
  514147
  504740
  565842
  827308
  499066
  646682
  579872
  618531
  798704
  732816
  751437
  751411
  398690
  818841
  482615
  517018
  713964
  549112
  782762
  768499
  795945
  730363
  420105
  489285
  456610
  518628
  470141
  825516
  466327
  661652
  698021
  803194
  728482
  763276
  699480
  587216
  467684
  499174
  527786
  628245
  760696
  740484
  817126
  531264
  793724
  724789
  752502
  579981
  516618
  575769
  508989
  523778
  447359
  456214
  530390
  529870
  531574
  655840
  806085
  772216
  788093
  492022
  528820
]
2.33 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
  148814
  382112
  398690
  417955
  420105
  447359
  451175
  456214
  456610
  456975
  457338
  466327
  467684
  470141
  479225
  482615
  485040
  489285
  492022
  498195
  499066
  499174
  504740
  508989
  511840
  514147
  516618
  517018
  518628
  520933
  521789
  523778
  526767
  527786
  528820
  529728
  529870
  530390
  530431
  531264
  531574
  536375
  542862
  549112
  552273
  560281
  561296
  565842
  567223
  570927
  575769
  579872
  579981
  587216
  588359
  598859
  613798
  618531
  628245
  646682
  655840
  660249
  661652
  689964
  698021
  699480
  713964
  714279
  719829
  722349
  724789
  725384
  726055
  727423
  728482
  730363
  732816
  733759
  740484
  751411
  751437
  752502
  754700
  760696
  763276
  768499
  772216
  773291
  777113
  777204
  778569
  782755
  782762
  782773
  782776
  786515
  788093
  792126
  793201
  793722
  793724
  795002
  795945
  797215
  798704
  801067
  803194
  806085
  806864
  810582
  811806
  814312
  814697
  817073
  817126
  818069
  818841
  825516
  826863
  827308
]
2.13 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam bondage sex"
]
1.90 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер бдсм секс"
]
1.71 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер бдсм секс"
]
1.49 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.