Query Metrics
7
Database Queries
7
Different statements
144.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.24 ms (83.27%) |
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 394103 413289 418323 418648 419912 420031 421315 422855 423245 424551 425797 425823 430444 431871 443600 457110 457208 457265 457271 471822 485576 487864 491456 508485 508769 511927 512176 512208 515734 517857 519437 519769 523373 524819 529854 530663 534985 538295 539519 539938 540608 544712 550626 550637 550762 550778 552008 552918 554016 556353 558359 558377 559925 562808 564209 565481 566849 567107 567819 567837 573473 574681 577045 577059 583255 583267 586584 586590 591592 596278 596911 598289 600624 619178 622137 632803 636923 639894 642064 646004 672258 675208 704259 708805 710893 713096 724244 727382 740408 741134 741138 744732 744885 751854 752770 756359 758726 759473 760206 763390 771827 771832 776552 788135 793645 800504 801631 803996 804465 808858 810691 812171 816242 817847 817920 820685 820780 821625 822651 827853 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (10.12%) |
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 544712 619178 810691 740408 744732 741138 756359 708805 817920 672258 803996 804465 515734 554016 430444 512176 550778 583255 567837 512208 519437 423245 424551 529854 530663 539938 540608 534985 556353 559925 646004 565481 642064 586590 598289 418323 443600 457265 419912 517857 519769 485576 508485 508769 816242 675208 636923 808858 776552 800504 771827 771832 822651 820685 817847 821625 827853 539519 550626 577045 552918 704259 713096 710893 577059 622137 632803 639894 727382 741134 744885 758726 760206 788135 751854 763390 724244 752770 793645 801631 812171 413289 421315 431871 820780 491456 487864 511927 523373 538295 562808 567819 574681 550637 558377 550762 552008 566849 583267 558359 564209 567107 573473 586584 591592 600624 596278 596911 759473 418648 425797 457271 394103 425823 420031 422855 471822 457110 457208 524819 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.59%) |
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 394103 413289 418323 418648 419912 420031 421315 422855 423245 424551 425797 425823 430444 431871 443600 457110 457208 457265 457271 471822 485576 487864 491456 508485 508769 511927 512176 512208 515734 517857 519437 519769 523373 524819 529854 530663 534985 538295 539519 539938 540608 544712 550626 550637 550762 550778 552008 552918 554016 556353 558359 558377 559925 562808 564209 565481 566849 567107 567819 567837 573473 574681 577045 577059 583255 583267 586584 586590 591592 596278 596911 598289 600624 619178 622137 632803 636923 639894 642064 646004 672258 675208 704259 708805 710893 713096 724244 727382 740408 741134 741138 744732 744885 751854 752770 756359 758726 759473 760206 763390 771827 771832 776552 788135 793645 800504 801631 803996 804465 808858 810691 812171 816242 817847 817920 820685 820780 821625 822651 827853 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty asian"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty азиатк"
]
|
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.