Query Metrics
7
Database Queries
7
Different statements
153.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.66 ms (84.06%) |
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 6591 20031 95788 96524 96819 96947 96968 97096 187824 326297 365995 382907 383188 385344 388325 389290 389482 390437 391908 393091 395646 396917 397045 397382 397946 399807 400935 403348 405070 410093 412775 414729 423350 426367 427290 447038 447843 448560 452049 452648 453217 469917 471323 472345 475227 475894 476323 484639 484735 485145 486260 491272 491393 493260 508187 509014 509501 509813 513696 517638 522907 525020 526162 530012 530034 531164 531229 533658 550294 550665 550820 560430 567392 576685 577429 581292 584550 585282 585332 590767 599783 600009 603216 604142 620164 631930 633807 634771 637117 640777 641642 648219 649100 649651 650488 650794 653142 666591 672709 680691 690832 720684 720840 722805 724182 724251 745254 748541 766607 771723 785337 797949 801949 801962 808112 810404 810827 813082 814360 814536 ] |
||||||||||||||||||||||||||||||
|
14.40 ms (9.41%) |
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 187824 389482 400935 447038 471323 690832 567392 599783 785337 395646 365995 426367 469917 95788 771723 96819 476323 6591 526162 533658 517638 550294 649100 649651 603216 766607 509014 550665 590767 475894 509813 814536 508187 403348 475227 397045 96968 452648 385344 391908 96524 427290 493260 637117 393091 485145 423350 631930 604142 522907 397382 550820 530012 672709 581292 801949 414729 484735 585282 584550 560430 585332 797949 382907 20031 396917 96947 509501 531164 576685 680691 491272 390437 810827 410093 412775 383188 389290 486260 633807 814360 453217 577429 653142 720684 641642 813082 447843 525020 388325 397946 452049 531229 648219 666591 634771 472345 724182 720840 620164 748541 722805 448560 530034 513696 650488 650794 600009 640777 801962 810404 745254 724251 399807 405070 491393 484639 97096 326297 808112 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.96%) |
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 6591 20031 95788 96524 96819 96947 96968 97096 187824 326297 365995 382907 383188 385344 388325 389290 389482 390437 391908 393091 395646 396917 397045 397382 397946 399807 400935 403348 405070 410093 412775 414729 423350 426367 427290 447038 447843 448560 452049 452648 453217 469917 471323 472345 475227 475894 476323 484639 484735 485145 486260 491272 491393 493260 508187 509014 509501 509813 513696 517638 522907 525020 526162 530012 530034 531164 531229 533658 550294 550665 550820 560430 567392 576685 577429 581292 584550 585282 585332 590767 599783 600009 603216 604142 620164 631930 633807 634771 637117 640777 641642 648219 649100 649651 650488 650794 653142 666591 672709 680691 690832 720684 720840 722805 724182 724251 745254 748541 766607 771723 785337 797949 801949 801962 808112 810404 810827 813082 814360 814536 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mmf"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
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.