Query Metrics
7
Database Queries
7
Different statements
150.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.10 ms (81.33%) |
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 41516 170836 187567 188266 188507 233331 257966 330462 381940 382003 382411 383373 383472 383565 383631 383987 384752 384856 384878 385163 385882 386205 386864 388449 388765 388769 389482 390497 390653 391163 392458 392729 393771 395654 395688 395695 395849 396270 396312 396472 396757 396862 396947 396966 396983 399304 399689 399865 400166 400196 402570 403042 404953 405188 407362 407383 407414 407796 409667 409894 412303 419428 419844 424463 443705 443997 447246 449880 454187 455197 464960 466131 466847 467336 474060 475100 476559 477960 489138 491776 504393 518917 522003 554472 592735 622037 623598 637747 698293 698708 717708 717713 720701 721704 722662 725138 725558 726859 732078 734692 737897 744095 745999 752945 754227 757151 760615 770280 772109 774927 775014 775994 786172 797915 800074 801371 802460 804192 805221 808224 ] |
||||||||||||||||||||||||||||||
|
18.13 ms (12.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 801371 774927 802460 726859 734692 754227 757151 772109 800074 725558 732078 745999 744095 725138 737897 760615 770280 622037 623598 637747 698293 698708 717708 717713 720701 721704 775014 775994 786172 797915 804192 805221 187567 386864 466131 466847 41516 407383 454187 467336 384878 385882 395654 396862 399689 399865 424463 447246 233331 388769 391163 396966 412303 443705 477960 419844 443997 504393 522003 752945 409667 383472 396312 403042 592735 722662 384856 393771 257966 170836 402570 383987 388449 400166 407362 409894 449880 464960 518917 554472 381940 400196 407414 475100 476559 404953 419428 405188 455197 489138 491776 396947 407796 808224 474060 388765 396757 386205 383373 385163 384752 383565 383631 188266 188507 392458 392729 395688 395695 395849 330462 382003 382411 389482 390497 390653 396270 396472 396983 399304 ] |
||||||||||||||||||||||||||||||
|
2.49 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 41516 170836 187567 188266 188507 233331 257966 330462 381940 382003 382411 383373 383472 383565 383631 383987 384752 384856 384878 385163 385882 386205 386864 388449 388765 388769 389482 390497 390653 391163 392458 392729 393771 395654 395688 395695 395849 396270 396312 396472 396757 396862 396947 396966 396983 399304 399689 399865 400166 400196 402570 403042 404953 405188 407362 407383 407414 407796 409667 409894 412303 419428 419844 424463 443705 443997 447246 449880 454187 455197 464960 466131 466847 467336 474060 475100 476559 477960 489138 491776 504393 518917 522003 554472 592735 622037 623598 637747 698293 698708 717708 717713 720701 721704 722662 725138 725558 726859 732078 734692 737897 744095 745999 752945 754227 757151 760615 770280 772109 774927 775014 775994 786172 797915 800074 801371 802460 804192 805221 808224 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde old"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая old"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая old"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
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.