Query Metrics
7
Database Queries
7
Different statements
149.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.09 ms (80.82%) |
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 382076 382441 384745 393862 394184 404370 410429 413295 415220 416066 418277 418532 419233 420344 421409 421448 422237 422402 423267 423381 423746 427314 427533 429160 429419 430320 430369 431152 431719 432118 433377 433656 434470 435320 441933 442995 443231 443988 445444 447682 448097 449326 450435 450461 450826 451261 454585 455467 455782 455939 460279 460483 461653 462091 462910 463581 469678 472025 472447 473522 475478 475622 475940 475989 477401 479764 481242 481307 481539 482802 486838 487460 487702 488771 496528 503156 503644 503859 504001 504900 507665 508756 509058 509162 510048 510071 511367 513193 517243 521335 522263 522281 523301 523938 525427 526905 538236 547930 551649 555740 556391 560833 561357 561674 561935 563635 564056 564091 565115 566345 567775 570363 576243 576739 579946 582665 583068 618893 657329 ] |
||||||||||||||||||||||||||||||
|
17.97 ms (11.99%) |
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 582665 576243 433377 382441 423381 431152 434470 441933 460483 477401 418277 525427 517243 523938 382076 449326 450826 488771 579946 565115 563635 463581 393862 421448 423746 469678 450461 509058 538236 487460 487702 522281 508756 429419 433656 418532 422402 496528 547930 460279 504001 561357 416066 443231 564091 384745 422237 443988 415220 503644 507665 429160 404370 430369 447682 462910 522263 473522 556391 564056 570363 618893 410429 431719 481242 413295 461653 510048 503156 472447 561674 567775 475989 423267 523301 432118 427314 455939 445444 450435 455467 475478 475940 482802 526905 551649 576739 555740 560833 566345 583068 481307 394184 430320 435320 442995 455782 472025 481539 462091 419233 475622 479764 504900 509162 486838 521335 510071 420344 451261 448097 561935 657329 454585 465573 421409 427533 513193 511367 503859 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (2.00%) |
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 382076 382441 384745 393862 394184 404370 410429 413295 415220 416066 418277 418532 419233 420344 421409 421448 422237 422402 423267 423381 423746 427314 427533 429160 429419 430320 430369 431152 431719 432118 433377 433656 434470 435320 441933 442995 443231 443988 445444 447682 448097 449326 450435 450461 450826 451261 454585 455467 455782 455939 460279 460483 461653 462091 462910 463581 469678 472025 472447 473522 475478 475622 475940 475989 477401 479764 481242 481307 481539 482802 486838 487460 487702 488771 496528 503156 503644 503859 504001 504900 507665 508756 509058 509162 510048 510071 511367 513193 517243 521335 522263 522281 523301 523938 525427 526905 538236 547930 551649 555740 556391 560833 561357 561674 561935 563635 564056 564091 565115 566345 567775 570363 576243 576739 579946 582665 583068 618893 657329 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy and girl"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен девушк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.