Query Metrics
7
Database Queries
7
Different statements
184.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.35 ms (85.84%) |
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 8619 107495 187353 383643 390492 391355 397907 404658 405505 407288 407881 408239 409045 409258 409640 409936 412639 413108 413518 414871 414946 415708 420259 420262 421132 424797 443707 446173 450776 450796 450816 452975 457572 460622 462708 465704 465838 475270 476904 477032 490167 490742 492096 492115 492156 497537 508782 512952 514275 520387 522127 522168 532073 536637 546622 561125 562976 562996 563436 566222 571494 573311 581284 583867 586828 591636 593557 663520 668440 677611 686637 692306 699703 705277 709371 712137 717025 721219 721814 724227 733597 734679 737064 737088 752896 755407 758440 765662 766541 781306 781449 786455 790007 795508 800873 801334 801726 801913 802398 803007 803228 807458 813782 815321 815790 816074 816414 816773 816794 817473 817802 818204 818441 818901 820136 820364 820525 822280 822499 823017 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (8.40%) |
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 818441 815321 823017 815790 816414 816794 822499 816074 820364 820525 822280 583867 581284 717025 663520 721219 668440 586828 790007 734679 766541 801334 803007 807458 737064 733597 752896 755407 724227 721814 802398 699703 522127 497537 452975 492096 476904 781306 786455 407288 421132 490167 492115 414946 520387 397907 409640 508782 512952 803228 446173 413518 450816 563436 705277 420259 443707 107495 562976 562996 187353 412639 457572 450796 492156 546622 561125 566222 573311 383643 465704 407881 450776 424797 490742 514275 571494 816773 532073 800873 593557 391355 409258 415708 818204 677611 686637 712137 591636 737088 390492 405505 475270 462708 536637 408239 409936 404658 813782 709371 801726 801913 781449 765662 465838 460622 420262 522168 477032 8619 409045 414871 817802 818901 820136 795508 758440 692306 413108 817473 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.57%) |
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 8619 107495 187353 383643 390492 391355 397907 404658 405505 407288 407881 408239 409045 409258 409640 409936 412639 413108 413518 414871 414946 415708 420259 420262 421132 424797 443707 446173 450776 450796 450816 452975 457572 460622 462708 465704 465838 475270 476904 477032 490167 490742 492096 492115 492156 497537 508782 512952 514275 520387 522127 522168 532073 536637 546622 561125 562976 562996 563436 566222 571494 573311 581284 583867 586828 591636 593557 663520 668440 677611 686637 692306 699703 705277 709371 712137 717025 721219 721814 724227 733597 734679 737064 737088 752896 755407 758440 765662 766541 781306 781449 786455 790007 795508 800873 801334 801726 801913 802398 803007 803228 807458 813782 815321 815790 816074 816414 816773 816794 817473 817802 818204 818441 818901 820136 820364 820525 822280 822499 823017 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cunnilingus mom"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс mom"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс mom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
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.