Query Metrics
7
Database Queries
7
Different statements
180.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.30 ms (86.09%) |
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 79293 128784 276646 385564 386322 386965 388819 392974 395410 396399 397345 400128 400839 404503 407993 408435 409390 410855 411654 412518 413233 414220 417904 418134 419847 421735 423462 425005 426318 426808 428920 430696 432889 440788 443707 447303 447638 447745 448052 448077 448177 450237 453106 454302 454310 456398 456742 460346 460986 461162 462554 465209 465983 467342 467365 467380 467386 468470 468693 469493 469646 472066 472399 472557 473470 474302 477116 477399 478999 479138 479780 479878 482262 482664 482909 485017 486805 487297 490187 497253 498218 498355 501716 502753 503822 507487 508582 512409 513267 513704 518285 519256 519484 521452 523048 528817 546925 552168 559393 560535 560594 568361 569915 570437 570994 591975 601958 634858 654329 656453 717944 719159 730199 732029 757090 761829 775564 775601 790469 803386 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (8.13%) |
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 388819 396399 400128 400839 440788 419847 413233 417904 423462 418134 425005 428920 432889 410855 411654 430696 453106 465209 474302 477116 479780 482664 486805 450237 456398 460346 467342 472399 490187 487297 518285 502753 507487 523048 498218 461162 467365 468693 469493 546925 560535 569915 570437 552168 559393 560594 570994 568361 634858 601958 757090 732029 761829 717944 790469 407993 421735 447745 456742 472066 473470 395410 397345 404503 409390 426808 462554 477399 479138 479878 412518 448052 460986 467380 478999 414220 426318 443707 447638 454302 454310 472557 482262 447303 448077 448177 465983 467386 468470 469646 501716 519256 482909 513704 519484 512409 485017 497253 498355 503822 508582 513267 521452 528817 386322 385564 128784 392974 276646 79293 386965 408435 654329 656453 719159 591975 775564 775601 803386 730199 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.67%) |
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 79293 128784 276646 385564 386322 386965 388819 392974 395410 396399 397345 400128 400839 404503 407993 408435 409390 410855 411654 412518 413233 414220 417904 418134 419847 421735 423462 425005 426318 426808 428920 430696 432889 440788 443707 447303 447638 447745 448052 448077 448177 450237 453106 454302 454310 456398 456742 460346 460986 461162 462554 465209 465983 467342 467365 467380 467386 468470 468693 469493 469646 472066 472399 472557 473470 474302 477116 477399 478999 479138 479780 479878 482262 482664 482909 485017 486805 487297 490187 497253 498218 498355 501716 502753 503822 507487 508582 512409 513267 513704 518285 519256 519484 521452 523048 528817 546925 552168 559393 560535 560594 568361 569915 570437 570994 591975 601958 634858 654329 656453 717944 719159 730199 732029 757090 761829 775564 775601 790469 803386 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"вылизывает после"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза посл"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
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.