Query Metrics
7
Database Queries
7
Different statements
143.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.25 ms (86.12%) |
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 41903 386166 393067 399006 410227 413687 429902 432299 435593 446274 447985 461612 489953 492192 496149 518185 521338 523273 529626 543208 543600 543648 543904 544847 544909 546016 547447 548186 548460 548895 555224 555249 555772 557060 558981 559202 559420 566820 571137 575180 576566 578741 579185 585172 586732 586935 587290 592979 600862 605270 607468 610490 617504 617682 618531 623024 630074 641456 646044 662812 663339 666623 669062 669265 675512 683080 694550 696236 698236 704241 709855 710053 710480 720737 724130 734575 735452 743225 745746 748175 750347 752622 754704 760554 761347 761523 772881 775563 776956 777268 782112 782351 784180 788109 789409 794300 796389 801041 801150 801315 801629 804342 804419 805524 806990 813547 813644 814433 814532 814766 818626 823754 824341 824594 824652 824826 825350 825371 825400 827298 ] |
||||||||||||||||||||||||||||||
|
10.77 ms (7.52%) |
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 544847 704241 446274 489953 579185 669062 666623 461612 586935 605270 546016 432299 683080 720737 710053 618531 782112 413687 559202 575180 518185 523273 623024 399006 752622 410227 823754 824826 814766 824341 825350 825400 818626 824652 824594 825371 555224 543208 543904 548895 555772 558981 576566 578741 694550 669265 675512 544909 547447 566820 587290 607468 585172 586732 630074 775563 794300 806990 776956 789409 801150 801315 804342 761523 772881 784180 788109 734575 748175 735452 745746 743225 750347 754704 760554 641456 709855 777268 801041 804419 592979 492192 429902 393067 496149 386166 447985 548460 543648 696236 782351 805524 761347 41903 521338 571137 548186 796389 801629 435593 529626 698236 600862 617504 814532 710480 724130 646044 617682 610490 813644 814433 813547 827298 543600 555249 557060 559420 662812 663339 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.91%) |
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 41903 386166 393067 399006 410227 413687 429902 432299 435593 446274 447985 461612 489953 492192 496149 518185 521338 523273 529626 543208 543600 543648 543904 544847 544909 546016 547447 548186 548460 548895 555224 555249 555772 557060 558981 559202 559420 566820 571137 575180 576566 578741 579185 585172 586732 586935 587290 592979 600862 605270 607468 610490 617504 617682 618531 623024 630074 641456 646044 662812 663339 666623 669062 669265 675512 683080 694550 696236 698236 704241 709855 710053 710480 720737 724130 734575 735452 743225 745746 748175 750347 752622 754704 760554 761347 761523 772881 775563 776956 777268 782112 782351 784180 788109 789409 794300 796389 801041 801150 801315 801629 804342 804419 805524 806990 813547 813644 814433 814532 814766 818626 823754 824341 824594 824652 824826 825350 825371 825400 827298 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape vagina"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.93%) |
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.