Query Metrics
7
Database Queries
7
Different statements
213.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.06 ms (82.45%) |
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 233353 235677 358565 361665 382731 385712 388900 389098 390363 401294 402599 417873 419467 421866 424131 426227 427004 429577 434350 435568 438314 439448 439643 439756 440872 443186 443518 443707 444156 444619 447740 450827 451758 452175 452212 457315 457447 457480 457859 460163 460286 464837 465545 465723 467956 468088 468405 468443 470052 471506 475097 475875 477570 477942 479112 482196 485409 486307 487993 488595 489198 489230 489317 490349 490386 491462 492138 492365 493676 493761 493883 495498 495841 496729 501435 504014 504458 505388 505447 506062 510305 512023 514302 516668 517962 520908 520979 524271 527196 532131 536444 539464 543543 547420 549718 550330 557583 561476 564548 566914 568252 574173 584101 610446 629543 632513 637500 644075 656321 662922 671679 687940 700263 738202 777270 792190 796207 801775 809913 825851 ] |
||||||||||||||||||||||||||||||
|
27.89 ms (13.06%) |
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 738202 435568 382731 429577 419467 443186 444619 486307 495841 490386 543543 687940 361665 385712 465723 475875 491462 460163 662922 671679 700263 610446 637500 792190 796207 629543 632513 809913 438314 439448 450827 468405 468443 470052 477942 532131 468088 547420 550330 656321 460286 514302 495498 488595 504014 506062 505388 465545 421866 233353 444156 487993 520908 520979 524271 389098 479112 439643 358565 402599 426227 452212 457859 477570 493676 493761 452175 475097 539464 510305 471506 493883 574173 566914 557583 549718 561476 564548 644075 777270 424131 427004 501435 516668 485409 489198 490349 489230 527196 505447 388900 390363 417873 443518 434350 440872 492365 482196 447740 451758 457315 457480 464837 492138 584101 801775 443707 467956 504458 512023 517962 496729 235677 568252 489317 536444 401294 439756 457447 825851 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.22%) |
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 233353 235677 358565 361665 382731 385712 388900 389098 390363 401294 402599 417873 419467 421866 424131 426227 427004 429577 434350 435568 438314 439448 439643 439756 440872 443186 443518 443707 444156 444619 447740 450827 451758 452175 452212 457315 457447 457480 457859 460163 460286 464837 465545 465723 467956 468088 468405 468443 470052 471506 475097 475875 477570 477942 479112 482196 485409 486307 487993 488595 489198 489230 489317 490349 490386 491462 492138 492365 493676 493761 493883 495498 495841 496729 501435 504014 504458 505388 505447 506062 510305 512023 514302 516668 517962 520908 520979 524271 527196 532131 536444 539464 543543 547420 549718 550330 557583 561476 564548 566914 568252 574173 584101 610446 629543 632513 637500 644075 656321 662922 671679 687940 700263 738202 777270 792190 796207 801775 809913 825851 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин постел"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother bed"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.74%) |
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.