Query Metrics
7
Database Queries
7
Different statements
247.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.92 ms (86.40%) |
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 156525 260962 382958 390192 390706 390845 391054 400703 401674 402518 405745 407464 409727 410872 410874 413730 418899 419321 438424 453807 454215 456691 464531 467749 483388 488927 489680 508433 514643 530552 530886 532428 537564 543709 546219 553661 560319 570698 576165 578552 587258 590858 590907 591257 593840 613579 619271 622130 632037 632513 637280 637982 644324 645093 650646 651155 651301 653432 653896 654636 675297 675953 676279 676283 676851 676883 678374 693816 693849 694032 694639 697169 703212 703496 710030 715550 715559 718879 724410 726290 726419 727831 727858 729223 729260 729270 729276 733231 741476 742596 759464 762487 762513 770630 772144 776307 784700 792515 793175 793427 795525 798881 803450 805276 806068 806072 806777 809702 809765 809822 810967 814320 814936 815154 817361 824315 825302 827262 ] |
||||||||||||||||||||||||||||||
|
22.83 ms (9.22%) |
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 703496 762513 733231 632513 697169 619271 402518 651301 410872 729276 613579 784700 591257 793427 407464 776307 418899 489680 825302 537564 543709 622130 590907 382958 693849 805276 645093 765461 508433 653896 409727 413730 809765 715550 390706 560319 576165 715559 587258 483388 727831 729270 156525 759464 729260 454215 814936 632037 453807 653432 694032 390845 553661 410874 676851 806777 806068 644324 438424 400703 792515 488927 814320 795525 726290 726419 467749 593840 724410 729223 570698 456691 532428 675297 676883 742596 401674 390192 578552 676283 419321 815154 546219 694639 590858 803450 741476 772144 727858 762487 405745 654636 703212 514643 793175 260962 391054 824315 678374 651155 637280 798881 809822 770630 675953 650646 693816 817361 827262 530552 530886 464531 710030 718879 676279 637982 806072 810967 779185 809702 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.34%) |
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 156525 260962 382958 390192 390706 390845 391054 400703 401674 402518 405745 407464 409727 410872 410874 413730 418899 419321 438424 453807 454215 456691 464531 467749 483388 488927 489680 508433 514643 530552 530886 532428 537564 543709 546219 553661 560319 570698 576165 578552 587258 590858 590907 591257 593840 613579 619271 622130 632037 632513 637280 637982 644324 645093 650646 651155 651301 653432 653896 654636 675297 675953 676279 676283 676851 676883 678374 693816 693849 694032 694639 697169 703212 703496 710030 715550 715559 718879 724410 726290 726419 727831 727858 729223 729260 729270 729276 733231 741476 742596 759464 762487 762513 770630 772144 776307 784700 792515 793175 793427 795525 798881 803450 805276 806068 806072 806777 809702 809765 809822 810967 814320 814936 815154 817361 824315 825302 827262 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ffm with wife"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жмж секс втро жен"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро жен"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.72%) |
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.