Query Metrics
7
Database Queries
7
Different statements
248.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
223.03 ms (89.76%) |
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 379559 383950 391134 398866 406206 407586 410753 414788 421363 428410 428465 430416 430441 438934 442201 444652 445681 451040 452097 453036 453108 454613 454628 457943 464018 464093 464112 465883 467992 468021 469287 471410 471834 472216 476697 482217 482668 486931 491268 493045 502738 503598 503792 507306 511930 518633 519010 521469 523052 525115 525402 527069 528038 530048 530537 530834 531429 531436 534253 536728 557526 560186 567764 569827 584149 587925 590188 597717 598059 601007 610717 624436 627371 627372 633772 636270 640676 642697 646923 647669 651924 653247 673138 674090 682478 698262 705677 714900 715350 720295 720985 724266 744631 747258 747819 753443 759782 766831 773822 781586 785022 785388 795497 797580 800882 802458 802505 802640 802716 803451 803936 808647 808650 808654 814137 815406 815624 815717 815718 815928 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (5.65%) |
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 442201 428410 814137 457943 471410 476697 453108 454613 464093 472216 525402 503598 471834 493045 567764 627371 795497 802458 803451 753443 642697 781586 802505 379559 414788 467992 430441 511930 430416 528038 453036 536728 507306 785388 518633 519010 410753 482217 468021 530537 531429 525115 534253 651924 674090 705677 720985 714900 715350 647669 560186 598059 624436 627372 636270 800882 802716 808650 747819 759782 724266 747258 773822 785022 808647 808654 428465 682478 406206 557526 469287 815718 815406 569827 530834 720295 633772 421363 451040 531436 815717 601007 744631 438934 815624 673138 590188 640676 383950 407586 503792 646923 653247 698262 491268 465883 444652 454628 523052 527069 597717 766831 452097 815928 587925 610717 797580 802640 398866 464018 530048 521469 803936 445681 584149 464112 482668 502738 391134 486931 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"масле куни"
]
|
||||||||||||||||||||||||||||||
|
3.13 ms (1.26%) |
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 379559 383950 391134 398866 406206 407586 410753 414788 421363 428410 428465 430416 430441 438934 442201 444652 445681 451040 452097 453036 453108 454613 454628 457943 464018 464093 464112 465883 467992 468021 469287 471410 471834 472216 476697 482217 482668 486931 491268 493045 502738 503598 503792 507306 511930 518633 519010 521469 523052 525115 525402 527069 528038 530048 530537 530834 531429 531436 534253 536728 557526 560186 567764 569827 584149 587925 590188 597717 598059 601007 610717 624436 627371 627372 633772 636270 640676 642697 646923 647669 651924 653247 673138 674090 682478 698262 705677 714900 715350 720295 720985 724266 744631 747258 747819 753443 759782 766831 773822 781586 785022 785388 795497 797580 800882 802458 802505 802640 802716 803451 803936 808647 808650 808654 814137 815406 815624 815717 815718 815928 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.64%) |
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.