Query Metrics
7
Database Queries
7
Different statements
153.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.54 ms (78.48%) |
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 2779 4199 6643 13373 38637 46283 145343 145988 152056 213396 241970 310133 383440 385578 386068 386074 389236 389504 395527 396142 397014 397068 397207 398395 398696 400829 400977 401507 401509 401581 401915 402531 405088 406907 407567 408447 410029 412518 418719 420232 422704 423646 424048 427264 430227 430920 431193 431672 441926 446770 450713 454741 455478 457492 462230 464567 465841 465846 466696 468613 471029 472720 472790 473073 474315 476156 477109 477569 478404 490107 490675 491590 492156 492664 499715 499927 502022 515455 516990 522702 526460 528965 529372 530331 535598 542492 543819 551992 553107 555547 561725 570382 592545 593261 593634 598087 599962 618920 630016 650951 660711 675230 680517 697296 707472 709862 714531 720088 743249 770570 774186 794425 795180 797735 799103 802046 810482 819396 824224 ] |
||||||||||||||||||||||||||||||
|
23.16 ms (15.08%) |
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 802046 709862 389236 145988 4199 401915 464567 462230 707472 799103 774186 743249 714531 2779 441926 478404 543819 454741 397207 466696 477109 398696 405088 472720 476156 491590 499715 395527 468613 420232 515455 430920 386074 38637 465841 474315 410029 529372 561725 553107 660711 697296 593634 397068 386068 450713 145343 471029 492664 555547 675230 593261 772838 794425 46283 401507 383440 598087 241970 13373 473073 535598 213396 599962 455478 477569 499927 526460 516990 810482 424048 431672 401509 402531 406907 522702 490675 492156 551992 570382 400829 431193 457492 412518 472790 490107 465846 407567 423646 528965 530331 542492 310133 396142 650951 680517 720088 618920 592545 630016 795180 797735 770570 408447 397014 422704 446770 400977 819396 824224 502022 6643 385578 427264 152056 398395 401581 430227 418719 389504 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.69%) |
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 2779 4199 6643 13373 38637 46283 145343 145988 152056 213396 241970 310133 383440 385578 386068 386074 389236 389504 395527 396142 397014 397068 397207 398395 398696 400829 400977 401507 401509 401581 401915 402531 405088 406907 407567 408447 410029 412518 418719 420232 422704 423646 424048 427264 430227 430920 431193 431672 441926 446770 450713 454741 455478 457492 462230 464567 465841 465846 466696 468613 471029 472720 472790 473073 474315 476156 477109 477569 478404 490107 490675 491590 492156 492664 499715 499927 502022 515455 516990 522702 526460 528965 529372 530331 535598 542492 543819 551992 553107 555547 561725 570382 592545 593261 593634 598087 599962 618920 630016 650951 660711 675230 680517 697296 707472 709862 714531 720088 743249 770570 774186 794425 795180 797735 799103 802046 810482 819396 824224 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
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.