Query Metrics
7
Database Queries
7
Different statements
166.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.51 ms (84.15%) |
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 359441 385955 407250 427714 445006 449546 449963 455591 456050 461147 461807 461868 465280 465439 470520 470784 470976 478081 485661 487431 489659 490641 492412 495242 495490 496456 496890 504463 508082 509223 509958 510132 518197 520152 522339 523075 524085 524355 525617 525772 525780 527818 528468 530106 535314 539335 540927 543555 545395 545434 545885 547942 549573 551026 553487 554904 555889 555959 556981 557582 558121 559297 559396 561489 562015 562570 562935 563116 563425 564496 564510 567119 570462 574050 577310 577997 578148 579381 579611 580001 580817 581713 582740 584045 584284 586506 587581 589596 591866 597803 598321 599528 599789 600467 600838 605697 614059 619868 637250 648266 649368 650075 651218 666160 666596 666676 668461 669589 671876 672812 673963 675402 680456 682124 684934 687430 689897 698409 812305 818367 ] |
||||||||||||||||||||||||||||||
|
16.32 ms (9.77%) |
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 649368 669589 555959 557582 582740 591866 600467 587581 599528 600838 586506 597803 605697 619868 698409 812305 470784 407250 461807 525772 528468 489659 509223 487431 490641 496890 579381 673963 682124 672812 555889 599789 637250 614059 510132 385955 359441 445006 427714 818367 449546 449963 461147 461868 485661 456050 470520 455591 465280 478081 492412 495242 509958 520152 522339 524355 518197 523075 525617 525780 495490 504463 508082 524085 527818 530106 496456 535314 539335 465439 470976 562570 574050 577310 580817 540927 543555 547942 549573 554904 558121 559297 562015 563425 564496 564510 545395 545885 553487 556981 562935 567119 580001 581713 584284 666160 666596 668461 648266 650075 651218 666676 680456 684934 671876 675402 687430 689897 545434 551026 559396 561489 563116 570462 577997 578148 579611 584045 589596 598321 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.87%) |
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 359441 385955 407250 427714 445006 449546 449963 455591 456050 461147 461807 461868 465280 465439 470520 470784 470976 478081 485661 487431 489659 490641 492412 495242 495490 496456 496890 504463 508082 509223 509958 510132 518197 520152 522339 523075 524085 524355 525617 525772 525780 527818 528468 530106 535314 539335 540927 543555 545395 545434 545885 547942 549573 551026 553487 554904 555889 555959 556981 557582 558121 559297 559396 561489 562015 562570 562935 563116 563425 564496 564510 567119 570462 574050 577310 577997 578148 579381 579611 580001 580817 581713 582740 584045 584284 586506 587581 589596 591866 597803 598321 599528 599789 600467 600838 605697 614059 619868 637250 648266 649368 650075 651218 666160 666596 666676 668461 669589 671876 672812 673963 675402 680456 682124 684934 687430 689897 698409 812305 818367 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"порно большие клиторÑâ…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн большие клитор"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
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.