Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.25 ms
(51.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "оргазм жен домашн любительск"
]
178.38 ms
(43.05%)
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
  69589
  398683
  398719
  418259
  421121
  434293
  434326
  435552
  439156
  441101
  442510
  449070
  449992
  456127
  456161
  456939
  467923
  471340
  481961
  489312
  497675
  498278
  502877
  505724
  505747
  508154
  511376
  527194
  527207
  536470
  537379
  541757
  551543
  555297
  561979
  564510
  571112
  575357
  594293
  594980
  605742
  613521
  615503
  616978
  619992
  627937
  628507
  631604
  636414
  638737
  639612
  645623
  647822
  648931
  660053
  662129
  693732
  693772
  693816
  703022
  703927
  709559
  710265
  710529
  711266
  711990
  722383
  726723
  728518
  729252
  734114
  736326
  736987
  739161
  740452
  741683
  742657
  744157
  744412
  748083
  757393
  757512
  764096
  765405
  765812
  766439
  768820
  772443
  773120
  773334
  776966
  777982
  778279
  778567
  778578
  780080
  782096
  782821
  784868
  785114
  785234
  786082
  788640
  791113
  792880
  793008
  796997
  803089
  806524
  806943
  806947
  808665
  810081
  811186
  812495
  812672
  818557
  823368
  824754
  826880
]
14.07 ms
(3.39%)
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
  744412
  729252
  398719
  818557
  784868
  803089
  791113
  811186
  773120
  765405
  788640
  792880
  69589
  709559
  647822
  710529
  628507
  619992
  744157
  613521
  615503
  627937
  711266
  645623
  527207
  541757
  616978
  636414
  605742
  508154
  703927
  639612
  764096
  793008
  471340
  766439
  434326
  442510
  823368
  456939
  456127
  489312
  449992
  498278
  536470
  527194
  564510
  662129
  561979
  638737
  782096
  782821
  806947
  812495
  786082
  806943
  812672
  757393
  757512
  467923
  418259
  441101
  449070
  435552
  456161
  481961
  505747
  502877
  551543
  571112
  810081
  575357
  824754
  826880
  537379
  785114
  808665
  778578
  785234
  806524
  734114
  736987
  765812
  740452
  773334
  739161
  772443
  726723
  728518
  736326
  741683
  722383
  776966
  777982
  555297
  796997
  434293
  497675
  511376
  693816
  631604
  710265
  505724
  421121
  780080
  778567
  768820
  742657
  748083
  398683
  594980
  439156
  693772
  594293
  778279
  703022
  711990
  660053
  693732
  648931
]
2.73 ms
(0.66%)
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
  69589
  398683
  398719
  418259
  421121
  434293
  434326
  435552
  439156
  441101
  442510
  449070
  449992
  456127
  456161
  456939
  467923
  471340
  481961
  489312
  497675
  498278
  502877
  505724
  505747
  508154
  511376
  527194
  527207
  536470
  537379
  541757
  551543
  555297
  561979
  564510
  571112
  575357
  594293
  594980
  605742
  613521
  615503
  616978
  619992
  627937
  628507
  631604
  636414
  638737
  639612
  645623
  647822
  648931
  660053
  662129
  693732
  693772
  693816
  703022
  703927
  709559
  710265
  710529
  711266
  711990
  722383
  726723
  728518
  729252
  734114
  736326
  736987
  739161
  740452
  741683
  742657
  744157
  744412
  748083
  757393
  757512
  764096
  765405
  765812
  766439
  768820
  772443
  773120
  773334
  776966
  777982
  778279
  778567
  778578
  780080
  782096
  782821
  784868
  785114
  785234
  786082
  788640
  791113
  792880
  793008
  796997
  803089
  806524
  806943
  806947
  808665
  810081
  811186
  812495
  812672
  818557
  823368
  824754
  826880
]
1.90 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оргазм жены домашнее"
]
1.66 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "оргазм жен домашн любительск"
]
1.40 ms
(0.34%)
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.