Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.38 ms
(82.69%)
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
  145336
  188561
  389976
  402138
  411516
  422720
  426100
  435566
  435616
  435632
  437496
  445227
  445273
  447729
  453141
  454597
  467086
  468003
  469421
  470820
  484173
  487783
  490618
  492959
  496846
  499372
  505382
  507776
  508913
  509936
  516362
  521247
  527504
  529639
  529731
  530416
  530645
  530710
  531591
  531760
  532370
  533312
  533487
  534732
  534857
  535292
  536146
  537474
  539059
  542235
  542724
  546164
  547496
  548179
  550913
  554492
  554864
  556164
  559314
  560228
  561347
  561975
  571193
  572926
  574338
  576437
  576597
  576618
  579478
  580914
  582836
  585861
  588056
  593184
  593740
  594312
  594396
  596028
  596090
  596414
  601824
  606315
  613002
  613503
  613806
  614673
  625678
  631129
  634895
  636138
  639573
  641753
  647000
  651651
  661327
  666606
  666977
  675897
  680772
  680950
  681748
  696459
  709679
  710439
  727561
  736864
  738279
  746575
  753702
  754516
  754598
  774081
  776459
  778045
  782520
  784137
  790128
  806194
  810802
]
14.84 ms
(10.28%)
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
  550913
  576437
  560228
  588056
  606315
  634895
  594396
  593740
  601824
  435566
  675897
  496846
  666606
  516362
  145336
  445273
  445227
  507776
  539059
  530710
  533487
  554492
  542235
  661327
  680772
  680950
  576618
  625678
  613002
  613806
  596090
  782520
  810802
  784137
  613503
  710439
  454597
  484173
  509936
  531760
  521247
  534732
  572926
  411516
  447729
  470820
  529639
  530645
  535292
  574338
  582836
  651651
  681748
  647000
  548179
  576597
  641753
  593184
  776459
  790128
  806194
  754516
  738279
  746575
  774081
  778045
  188561
  487783
  529731
  696459
  636138
  736864
  754598
  753702
  402138
  554864
  426100
  389976
  422720
  435616
  435632
  490618
  453141
  530416
  499372
  533312
  534857
  536146
  537474
  527504
  531591
  492959
  561347
  579478
  556164
  559314
  546164
  666977
  639573
  585861
  596414
  594312
  596028
  727561
  631129
  709679
  467086
  469421
  468003
  437496
  508913
  614673
  505382
  532370
  542724
  571193
  561975
  580914
  541345
  547496
]
3.15 ms
(2.18%)
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
  145336
  188561
  389976
  402138
  411516
  422720
  426100
  435566
  435616
  435632
  437496
  445227
  445273
  447729
  453141
  454597
  467086
  468003
  469421
  470820
  484173
  487783
  490618
  492959
  496846
  499372
  505382
  507776
  508913
  509936
  516362
  521247
  527504
  529639
  529731
  530416
  530645
  530710
  531591
  531760
  532370
  533312
  533487
  534732
  534857
  535292
  536146
  537474
  539059
  542235
  542724
  546164
  547496
  548179
  550913
  554492
  554864
  556164
  559314
  560228
  561347
  561975
  571193
  572926
  574338
  576437
  576597
  576618
  579478
  580914
  582836
  585861
  588056
  593184
  593740
  594312
  594396
  596028
  596090
  596414
  601824
  606315
  613002
  613503
  613806
  614673
  625678
  631129
  634895
  636138
  639573
  641753
  647000
  651651
  661327
  666606
  666977
  675897
  680772
  680950
  681748
  696459
  709679
  710439
  727561
  736864
  738279
  746575
  753702
  754516
  754598
  774081
  776459
  778045
  782520
  784137
  790128
  806194
  810802
]
1.91 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло показыва вагин"
]
1.87 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло показывают вагины"
]
1.71 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло показыва вагин"
]
1.50 ms
(1.04%)
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.