Query Metrics
7
Database Queries
7
Different statements
151.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.72 ms (81.56%) |
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 95673 390407 412911 421569 424214 424624 425452 427209 429563 434307 436690 438655 445825 446373 449925 450287 450977 451264 451267 453213 457945 464132 469100 471035 472266 473779 475406 479669 480354 480356 480490 480788 482704 483717 486350 488789 489263 490918 493567 495421 498552 499365 506688 510876 514399 514408 515265 516622 516686 518514 521810 523255 526164 528178 530784 531116 537890 539319 543842 554526 555129 557324 559942 560935 568471 576503 580223 581873 584968 586965 588411 588697 589349 591394 595256 600173 605333 607509 620217 620395 622971 630760 632632 633813 639254 646776 650544 657865 662190 666525 667748 668690 675702 675866 681210 713332 738912 740512 740694 742385 744108 749935 750453 750756 758606 761039 771082 777688 777770 782512 791406 796877 799190 799933 803074 814467 814928 815999 825366 ] |
||||||||||||||||||||||||||||||
|
19.15 ms (12.62%) |
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 489263 390407 438655 814467 815999 480490 488789 479669 526164 498552 515265 518514 576503 584968 668690 675702 558081 568471 586965 630760 777770 782512 799933 740694 740512 749935 738912 758606 750756 605333 713332 581873 595256 622971 510876 506688 557324 425452 434307 480356 514399 495421 482704 530784 449925 543842 445825 483717 493567 560935 675866 681210 657865 662190 589349 607509 639254 777688 771082 791406 742385 750453 799190 475406 480788 424624 490918 451264 480354 555129 580223 424214 457945 825366 744108 539319 666525 667748 473779 521810 436690 450287 471035 537890 650544 600173 620217 620395 633813 588697 803074 796877 446373 469100 412911 453213 472266 528178 554526 591394 95673 429563 814928 451267 516622 523255 486350 464132 499365 514408 516686 632632 531116 559942 646776 588411 761039 450977 421569 427209 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.77%) |
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 95673 390407 412911 421569 424214 424624 425452 427209 429563 434307 436690 438655 445825 446373 449925 450287 450977 451264 451267 453213 457945 464132 469100 471035 472266 473779 475406 479669 480354 480356 480490 480788 482704 483717 486350 488789 489263 490918 493567 495421 498552 499365 506688 510876 514399 514408 515265 516622 516686 518514 521810 523255 526164 528178 530784 531116 537890 539319 543842 554526 555129 557324 559942 560935 568471 576503 580223 581873 584968 586965 588411 588697 589349 591394 595256 600173 605333 607509 620217 620395 622971 630760 632632 633813 639254 646776 650544 657865 662190 666525 667748 668690 675702 675866 681210 713332 738912 740512 740694 742385 744108 749935 750453 750756 758606 761039 771082 777688 777770 782512 791406 796877 799190 799933 803074 814467 814928 815999 825366 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy дилд"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy dildo"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy дилд"
]
|
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.