Query Metrics
7
Database Queries
7
Different statements
182.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.64 ms (83.66%) |
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 88439 256218 384757 391945 399083 400497 404052 415866 419144 421856 432348 437947 441089 446034 451137 458760 462840 472835 474266 476055 477081 477366 477757 477812 478003 478463 479979 481871 485966 490399 491097 495112 496348 497905 499568 504173 506764 509836 522020 522165 526191 530375 530765 531139 531260 532726 532729 532746 532748 532962 533600 536259 536281 536621 536628 537913 540944 541440 544812 545648 545972 547237 553221 555104 561573 582262 583033 583577 583727 586407 593016 596011 599916 600280 601575 607355 614957 629808 629828 630024 645952 647860 663441 665238 665379 673035 676092 704529 708195 708443 725153 728536 729802 730118 731758 740450 743029 744416 747468 749050 756192 770157 782804 789183 797146 800689 800692 800737 804241 805139 805144 809054 812543 815520 815699 817980 819253 824684 827284 827654 ] |
||||||||||||||||||||||||||||||
|
19.00 ms (10.42%) |
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 532729 497905 582262 547237 673035 665238 600280 629808 599916 601575 782804 756192 747468 399083 391945 815520 815699 458760 499568 526191 479979 583033 647860 504173 531260 536628 477812 805144 437947 446034 478463 532962 536281 530375 530765 532726 532748 536259 476055 540944 541440 614957 725153 805139 421856 400497 522020 495112 800737 477081 478003 532746 555104 663441 665379 586407 472835 477366 533600 561573 477757 404052 819253 824684 474266 708195 583727 629828 596011 800689 731758 770157 812543 88439 481871 384757 536621 531139 537913 545648 544812 645952 676092 607355 704529 708443 462840 432348 419144 441089 451137 485966 496348 522165 506764 545972 583577 593016 630024 256218 415866 490399 491097 553221 797146 729802 743029 804241 740450 744416 749050 728536 730118 509836 827284 817980 827654 789183 809054 800692 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.75%) |
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 88439 256218 384757 391945 399083 400497 404052 415866 419144 421856 432348 437947 441089 446034 451137 458760 462840 472835 474266 476055 477081 477366 477757 477812 478003 478463 479979 481871 485966 490399 491097 495112 496348 497905 499568 504173 506764 509836 522020 522165 526191 530375 530765 531139 531260 532726 532729 532746 532748 532962 533600 536259 536281 536621 536628 537913 540944 541440 544812 545648 545972 547237 553221 555104 561573 582262 583033 583577 583727 586407 593016 596011 599916 600280 601575 607355 614957 629808 629828 630024 645952 647860 663441 665238 665379 673035 676092 704529 708195 708443 725153 728536 729802 730118 731758 740450 743029 744416 747468 749050 756192 770157 782804 789183 797146 800689 800692 800737 804241 805139 805144 809054 812543 815520 815699 817980 819253 824684 827284 827654 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo mature"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд mature"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие дилд mature"
]
|
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.