Query Metrics
7
Database Queries
7
Different statements
179.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.24 ms (84.49%) |
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 70191 187857 188009 193662 381946 384147 384382 388732 391392 393056 396975 397304 397855 399688 400739 400845 402409 405830 407350 407444 407799 408164 411804 413829 417094 424841 442975 443913 445460 452157 452308 460672 463743 463839 463856 466175 466227 467912 467949 468169 468183 468362 468484 469283 469579 469582 470169 471814 474850 478003 480295 480432 483150 485125 485129 490406 490780 491228 491830 492658 493224 493743 494454 496724 498081 510882 511500 511827 513436 513671 514445 516043 517069 518563 519573 520979 523867 526527 529202 530465 534683 535878 537263 537664 542512 549846 554463 557244 563025 563075 563945 576919 584771 591144 601930 605008 606384 609689 651135 675276 677971 687211 692813 698554 701470 710250 721562 721974 725197 727050 727927 728443 733943 734332 755391 775202 814606 818469 818609 823293 ] |
||||||||||||||||||||||||||||||
|
17.02 ms (9.51%) |
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 491228 478003 513436 490406 397855 400739 727927 391392 498081 467912 474850 408164 381946 605008 393056 470169 692813 698554 687211 721562 407799 384382 407350 491830 445460 554463 388732 494454 517069 537263 520979 193662 516043 542512 728443 563075 468362 471814 513671 463839 413829 823293 563945 755391 576919 490780 601930 396975 442975 721974 733943 510882 402409 443913 511827 734332 417094 675276 483150 452308 411804 549846 405830 519573 397304 480432 496724 814606 463743 485129 511500 591144 725197 468183 469283 523867 492658 493743 526527 775202 493224 537664 701470 468169 469579 606384 187857 518563 529202 452157 677971 480295 407444 651135 530465 188009 400845 463856 818469 818609 485125 557244 563025 609689 399688 514445 466227 535878 727050 70191 424841 468484 469582 466175 467949 584771 534683 384147 460672 710250 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (2.02%) |
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 70191 187857 188009 193662 381946 384147 384382 388732 391392 393056 396975 397304 397855 399688 400739 400845 402409 405830 407350 407444 407799 408164 411804 413829 417094 424841 442975 443913 445460 452157 452308 460672 463743 463839 463856 466175 466227 467912 467949 468169 468183 468362 468484 469283 469579 469582 470169 471814 474850 478003 480295 480432 483150 485125 485129 490406 490780 491228 491830 492658 493224 493743 494454 496724 498081 510882 511500 511827 513436 513671 514445 516043 517069 518563 519573 520979 523867 526527 529202 530465 534683 535878 537263 537664 542512 549846 554463 557244 563025 563075 563945 576919 584771 591144 601930 605008 606384 609689 651135 675276 677971 687211 692813 698554 701470 710250 721562 721974 725197 727050 727927 728443 733943 734332 755391 775202 814606 818469 818609 823293 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелая большой анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин большой большие анал"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
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.