Query Metrics
7
Database Queries
7
Different statements
209.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.98 ms (87.78%) |
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 8713 21576 57253 80370 89362 205794 257966 381846 384016 385119 386686 388101 389593 390807 390922 391579 391702 391913 392602 394206 398935 400535 400987 402729 403066 403316 406701 407664 407876 410251 411389 412288 413888 418837 423904 424478 427452 428866 433250 443178 443378 443705 443997 444001 444115 447687 453272 453655 456915 460714 461534 461842 462710 465375 465598 466182 466271 474798 477960 477979 484393 484485 484603 485841 486543 490361 491412 491960 492043 493103 499266 499414 499421 502738 505811 506757 508771 509710 511421 511701 514599 516784 518852 520750 521667 524155 525475 526948 527187 528274 530999 538211 543284 543290 545647 572491 574519 581187 600166 601435 603807 606052 607870 614057 617639 618195 654840 656465 658096 662516 683288 718501 720543 777532 787195 796360 801860 802392 820261 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (7.50%) |
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 381846 388101 390807 391579 392602 398935 403066 403316 407876 411389 423904 428866 447687 461534 8713 21576 205794 386686 389593 391702 391913 394206 400987 407664 410251 427452 443378 443705 460714 461842 465375 465598 474798 477960 477979 406701 424478 443178 443997 444001 444115 453272 453655 520750 484393 484603 485841 491960 499266 509710 511421 511701 527187 538211 490361 491412 499414 521667 524155 525475 528274 486543 492043 493103 499421 506757 508771 390922 433250 413888 418837 484485 505811 574519 572491 654840 607870 600166 603807 614057 384016 462710 518852 530999 400535 543290 658096 720543 606052 796360 618195 777532 57253 801860 766118 787195 402729 80370 412288 456915 656465 545647 601435 466182 466271 502738 516784 514599 526948 385119 257966 89362 820261 543284 581187 662516 718501 683288 617639 802392 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.31%) |
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 8713 21576 57253 80370 89362 205794 257966 381846 384016 385119 386686 388101 389593 390807 390922 391579 391702 391913 392602 394206 398935 400535 400987 402729 403066 403316 406701 407664 407876 410251 411389 412288 413888 418837 423904 424478 427452 428866 433250 443178 443378 443705 443997 444001 444115 447687 453272 453655 456915 460714 461534 461842 462710 465375 465598 466182 466271 474798 477960 477979 484393 484485 484603 485841 486543 490361 491412 491960 492043 493103 499266 499414 499421 502738 505811 506757 508771 509710 511421 511701 514599 516784 518852 520750 521667 524155 525475 526948 527187 528274 530999 538211 543284 543290 545647 572491 574519 581187 600166 601435 603807 606052 607870 614057 617639 618195 654840 656465 658096 662516 683288 718501 720543 777532 787195 796360 801860 802392 820261 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx парен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx boy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx парен"
]
|
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.