Query Metrics
7
Database Queries
7
Different statements
190.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.78 ms (85.60%) |
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 388363 388545 406012 412830 415988 434367 438573 441160 443246 452937 452948 452950 452960 454044 457292 457999 460291 465672 466868 467064 469158 469769 471126 471981 487944 488757 490403 491101 491104 491107 491108 511005 511014 511379 511869 513568 513636 513668 517514 517525 517539 517808 518192 518598 519357 526577 531838 532830 535363 537447 540556 540567 541795 543998 546409 547007 555014 558117 558610 576540 582025 582465 583539 583727 585498 585612 589589 592965 601014 605245 605247 618985 632094 634027 634640 650524 652881 660831 701235 701239 712129 713327 714409 715094 719389 733425 740553 759806 781920 787512 787677 788753 790334 793506 800689 802162 802571 803049 803396 803508 804264 807597 807723 810096 812407 816184 819645 823992 824632 825432 826832 826957 827296 827394 827395 827396 827616 827692 827722 827734 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (8.27%) |
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 733425 759806 632094 701235 803508 804264 434367 715094 469158 518598 406012 513568 388545 388363 438573 457999 471126 452948 454044 466868 490403 511005 532830 511869 511014 518192 531838 555014 558610 558117 582465 601014 605247 807597 467064 471981 412830 441160 460291 469769 452960 415988 517808 488757 517514 491101 513636 513668 526577 487944 491104 491107 491108 517525 519357 443246 457292 452937 452950 511379 816184 819645 824632 823992 826832 826957 827296 827616 827722 827394 827395 827396 827734 827692 825432 465672 540556 540567 517539 535363 537447 543998 546409 547007 541795 576540 582025 650524 652881 660831 712129 714409 701239 713327 719389 583539 583727 589589 592965 605245 618985 634027 585498 585612 634640 781920 787512 790334 800689 803049 810096 812407 788753 802162 802571 803396 807723 740553 787677 793506 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.85%) |
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 388363 388545 406012 412830 415988 434367 438573 441160 443246 452937 452948 452950 452960 454044 457292 457999 460291 465672 466868 467064 469158 469769 471126 471981 487944 488757 490403 491101 491104 491107 491108 511005 511014 511379 511869 513568 513636 513668 517514 517525 517539 517808 518192 518598 519357 526577 531838 532830 535363 537447 540556 540567 541795 543998 546409 547007 555014 558117 558610 576540 582025 582465 583539 583727 585498 585612 589589 592965 601014 605245 605247 618985 632094 634027 634640 650524 652881 660831 701235 701239 712129 713327 714409 715094 719389 733425 740553 759806 781920 787512 787677 788753 790334 793506 800689 802162 802571 803049 803396 803508 804264 807597 807723 810096 812407 816184 819645 823992 824632 825432 826832 826957 827296 827394 827395 827396 827616 827692 827722 827734 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло mature вебкамер"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo mature webcam"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло mature вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.95%) |
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.