Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.90 ms
(78.95%)
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
  393752
  395676
  398949
  412132
  414686
  419988
  420083
  420262
  425337
  443315
  448069
  450811
  451511
  451990
  460332
  461645
  462714
  464280
  464317
  465368
  465406
  466942
  468860
  469424
  470758
  473226
  474813
  475049
  476902
  480309
  481953
  483401
  483424
  484819
  485581
  486366
  486704
  487054
  488567
  489108
  489476
  489893
  490671
  492511
  493266
  494702
  495025
  499844
  500699
  501747
  501755
  504024
  504307
  505660
  508145
  509718
  512306
  512532
  513123
  513768
  513978
  515097
  515247
  515455
  519549
  520265
  520509
  520686
  523040
  523608
  524091
  528053
  537870
  543837
  544313
  546111
  546125
  549248
  554784
  556025
  558016
  558828
  559108
  559424
  560958
  562810
  563066
  565931
  567410
  567667
  568361
  571361
  571793
  572128
  573077
  575435
  576286
  576308
  576632
  577102
  581266
  596577
  598500
  598695
  606824
  607442
  612413
  612861
  613055
  614987
  621397
  651907
  651933
  652572
  653464
  653523
  654381
  679347
  756522
  810984
]
21.08 ms
(14.36%)
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
  501747
  481953
  504024
  451990
  476902
  571793
  487054
  464317
  546111
  560958
  573077
  568361
  572128
  606824
  679347
  425337
  562810
  450811
  559424
  571361
  493266
  465368
  558828
  810984
  515097
  515247
  509718
  756522
  393752
  520686
  462714
  581266
  395676
  414686
  598695
  512306
  470758
  520265
  494702
  473226
  484819
  419988
  513978
  451511
  544313
  483424
  501755
  596577
  505660
  613055
  653464
  499844
  520509
  465406
  495025
  460332
  546125
  420083
  474813
  461645
  513123
  576286
  537870
  489476
  654381
  508145
  489893
  475049
  492511
  485581
  488567
  598500
  559108
  468860
  577102
  575435
  443315
  464280
  651907
  614987
  567667
  483401
  486704
  528053
  512532
  504307
  567410
  486366
  398949
  543837
  576632
  420262
  523040
  621397
  565931
  489108
  607442
  612413
  549248
  563066
  612861
  651933
  469424
  490671
  515455
  556025
  523608
  554784
  480309
  558016
  653523
  524091
  412132
  519549
  466942
  576308
  500699
  652572
  513768
  448069
]
2.44 ms
(1.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
  393752
  395676
  398949
  412132
  414686
  419988
  420083
  420262
  425337
  443315
  448069
  450811
  451511
  451990
  460332
  461645
  462714
  464280
  464317
  465368
  465406
  466942
  468860
  469424
  470758
  473226
  474813
  475049
  476902
  480309
  481953
  483401
  483424
  484819
  485581
  486366
  486704
  487054
  488567
  489108
  489476
  489893
  490671
  492511
  493266
  494702
  495025
  499844
  500699
  501747
  501755
  504024
  504307
  505660
  508145
  509718
  512306
  512532
  513123
  513768
  513978
  515097
  515247
  515455
  519549
  520265
  520509
  520686
  523040
  523608
  524091
  528053
  537870
  543837
  544313
  546111
  546125
  549248
  554784
  556025
  558016
  558828
  559108
  559424
  560958
  562810
  563066
  565931
  567410
  567667
  568361
  571361
  571793
  572128
  573077
  575435
  576286
  576308
  576632
  577102
  581266
  596577
  598500
  598695
  606824
  607442
  612413
  612861
  613055
  614987
  621397
  651907
  651933
  652572
  653464
  653523
  654381
  679347
  756522
  810984
]
1.97 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большие губы куни"
]
1.87 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие губ куннилингус оральн секс"
]
1.82 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие губ куннилингус оральн секс"
]
1.73 ms
(1.18%)
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.