Symfony Profiler

Query Metrics

19 Database Queries

15 Different statements

177.17 ms Query time

3 Invalid entities

1039 Managed entities

Grouped Statements

Time▼	Count	Info
74.97 ms (42.32%)	2	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 13547 AND l0_._left > 11874 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 13547 AND l0_._left > 11874 AND l0_.root = ? ORDER BY l0_._left ASC SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 13547 AND l0_._left > 11874 AND l0_.root = 1 ORDER BY l0_._left ASC;
31.28 ms (17.66%)	1	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.status = ? AND l0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4 Parameters: [2 34 152 7178 7180 7181 7337 7341 7342 7344 7345 7346 7347 7348 7351 7352 7353 7354 7355 7356 7357 7360 24196 24481 24946 26851 26852 26853 27478 27623 27860 27873 27909 27966 28003 28151 28306 28322 28449 28513 28732 28733 28745 28845 1298 7425 1346 6986 9462 9931 9932 9933 9934 9935 9936 9937 9938 9939 9940 9941 9942 9943 9944 9945 9946 9947 9948 9949 9950 9951 9952 9953 9954 9955 9956 9957 9958 9959 9960 9961 9962 9963 9964 9965 9966 9967 9968 9969 9970 9971 9972 9973 9974 9975 9976 9977 9978 9979 9980 9981 9982 9983 9984 9985 9986 9987 9988 9989 9990 9991 9992 9993 9994 9995 9996 9997 9998 9999 10000 10001 10002 10003 10004 10005 10006 10007 28691 7062 151 9148 9149 9150 9151 9152 9153 9154 9155 9156 9157 9158 9159 9160 9430 9431 9432 9433 9434 9435 9436 9437 9438 9439 9440 9441 9442 26854 26855 26860 26861 26862 26863 7063 7064 153 9783 7420 7427 9443 9444 9445 9446 9447 9448 9449 9450 9451 9452 9453 9454 9455 9456 9457 9458 9459 9460 9461 9463 9464 9465 9466 9467 9468 9469 9470 9471 9472 9473 9474 9475 9476 9477 9478 9479 9480 9481 9482 9483 9484 9485 9486 9487 9488 9489 9490 9491 9492 9493 9494 9495 9496 9497 9498 9499 9500 9501 9502 9503 9504 9505 9506 9507 9508 9509 9510 9511 9512 9513 9514 9515 9516 9517 9518 9519 9520 9521 9522 9523 9524 9525 9526 9527 9528 9529 9530 9531 9532 27680 27971 28326 28728 154 7377 7378 7379 7380 7381 7382 7383 7384 7385 7386 7387 7388 7389 7390 7391 7392 7393 7394 7395 7396 7397 7398 7399 7400 7401 7402 7403 7404 7405 7406 7407 7408 23788 24126 26864 26882 26883 26884 26885 26886 28989 155 28377 7418 7476 25411 25514 25524 26618 26619 26620 26621 26622 26635 26636 26637 26638 26639 27905 27948 156 9641 6933 470 9533 9534 9535 9536 9537 9538 29066 157 9539 9540 9541 9542 9543 9544 9545 9546 9547 9548 9549 9550 9551 9552 9553 9554 24618 28503 158 159 160 161 162 9555 9556 9557 9558 9559 9560 163 164 9561 9562 9563 9564 9565 9566 9567 9568 9569 9570 9571 9572 9573 9574 9575 9576 9577 9578 9579 9580 9581 9582 9583 9584 9585 9586 9587 9588 9589 9590 9591 9592 9593 9594 9595 9596 9597 9598 9599 9600 9601 9602 9603 9604 9605 9606 9607 9608 9609 9610 9611 9612 9613 9614 9615 9616 9617 9618 9619 9620 9621 9622 9623 9624 9625 9626 9627 9628 9629 9630 9631 9632 9633 9634 9635 9636 9637 165 166 9639 9640 9642 9643 9644 9645 9646 9647 9648 9649 9650 9651 9652 9653 9654 9655 9656 9657 9658 9659 9660 9661 9662 9663 9664 9665 9666 9667 9668 9669 9670 9671 9672 9673 9674 9675 9676 9677 9678 9679 9680 9681 9682 9683 9684 9685 9686 9687 9688 9689 9690 9691 9692 9693 9694 9695 9696 9697 9698 9699 9700 9701 9702 9703 9704 9705 9706 9707 9708 9709 9710 9711 9712 9713 9714 9715 9716 9717 9718 9719 9720 9721 9722 25741 28661 167 9723 9724 9725 9726 9727 9728 9729 9730 9731 9732 9733 9734 9735 9736 9737 9738 9739 9740 9741 9742 9743 9744 9745 9746 9747 9748 9749 9750 9751 9752 23629 27840 27994 28687 168 9753 9754 9755 9756 9757 9758 9759 9760 9761 9762 9763 9764 9765 9766 9767 9768 9769 9770 9771 9772 9773 9774 9775 9776 9777 9778 9779 28274 169 9780 9781 9782 9784 9785 9786 9787 9788 9789 9790 9791 9792 9793 9794 9795 170 1024 1025 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 9796 9797 174 183 184 9798 9799 9800 9801 9802 9803 9804 9805 9806 9807 9808 9809 9810 9811 9812 9813 9814 9815 9816 9817 9818 9819 9820 9821 9822 9823 9824 9825 9826 9827 9828 9829 9830 9831 9832 9833 9834 9835 9836 9837 9838 9839 9840 9841 9842 9843 9844 9845 9846 9847 9848 9849 9850 9851 9852 9853 9854 9855 9856 9857 9858 9859 9860 9861 9862 9863 9864 9865 9866 9867 9868 9869 9870 9871 9872 9873 9874 9875 9876 9877 9878 9879 9880 9881 9882 9883 9884 9885 9886 9887 9888 9889 9890 9891 9892 9893 9894 9895 9896 9897 9898 9899 9900 9901 9902 9903 9904 9905 9906 9907 9908 9909 9910 9911 9912 9913 9914 9915 9916 9917 9918 9919 9920 9921 9922 9923 9924 9925 9926 9927 9928 9929 9930 26652 26653 26654 26655 26656 27777 28055 185 186 187 188 189 190 191 1226 1276 24063 173 172 171 24950 25042 128 5533 1299 1300 1301 1302 1304 1305 1316 6959 1330 7092 7094 7498 23986 24266 24286 24372 24392 24393 24400 24401 24403 24404 24409 24450 24582 25637 25774 26721 27001 27356 27477 28089 28813 21171 23796 23978 23988 23989 24044 24045 25388 24179 24204 24208 24253 25541 25542 26279 26280 26316 28743] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE ( l0_.status = ? AND l0_.location_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4 SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.status = 2 AND l0_.location_id IN (34, 152, 7178, 7180, 7181, 7337, 7341, 7342, 7344, 7345, 7346, 7347, 7348, 7351, 7352, 7353, 7354, 7355, 7356, 7357, 7360, 24196, 24481, 24946, 26851, 26852, 26853, 27478, 27623, 27860, 27873, 27909, 27966, 28003, 28151, 28306, 28322, 28449, 28513, 28732, 28733, 28745, 28845, 1298, 7425, 1346, 6986, 9462, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9944, 9945, 9946, 9947, 9948, 9949, 9950, 9951, 9952, 9953, 9954, 9955, 9956, 9957, 9958, 9959, 9960, 9961, 9962, 9963, 9964, 9965, 9966, 9967, 9968, 9969, 9970, 9971, 9972, 9973, 9974, 9975, 9976, 9977, 9978, 9979, 9980, 9981, 9982, 9983, 9984, 9985, 9986, 9987, 9988, 9989, 9990, 9991, 9992, 9993, 9994, 9995, 9996, 9997, 9998, 9999, 10000, 10001, 10002, 10003, 10004, 10005, 10006, 10007, 28691, 7062, 151, 9148, 9149, 9150, 9151, 9152, 9153, 9154, 9155, 9156, 9157, 9158, 9159, 9160, 9430, 9431, 9432, 9433, 9434, 9435, 9436, 9437, 9438, 9439, 9440, 9441, 9442, 26854, 26855, 26860, 26861, 26862, 26863, 7063, 7064, 153, 9783, 7420, 7427, 9443, 9444, 9445, 9446, 9447, 9448, 9449, 9450, 9451, 9452, 9453, 9454, 9455, 9456, 9457, 9458, 9459, 9460, 9461, 9463, 9464, 9465, 9466, 9467, 9468, 9469, 9470, 9471, 9472, 9473, 9474, 9475, 9476, 9477, 9478, 9479, 9480, 9481, 9482, 9483, 9484, 9485, 9486, 9487, 9488, 9489, 9490, 9491, 9492, 9493, 9494, 9495, 9496, 9497, 9498, 9499, 9500, 9501, 9502, 9503, 9504, 9505, 9506, 9507, 9508, 9509, 9510, 9511, 9512, 9513, 9514, 9515, 9516, 9517, 9518, 9519, 9520, 9521, 9522, 9523, 9524, 9525, 9526, 9527, 9528, 9529, 9530, 9531, 9532, 27680, 27971, 28326, 28728, 154, 7377, 7378, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7387, 7388, 7389, 7390, 7391, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7400, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7408, 23788, 24126, 26864, 26882, 26883, 26884, 26885, 26886, 28989, 155, 28377, 7418, 7476, 25411, 25514, 25524, 26618, 26619, 26620, 26621, 26622, 26635, 26636, 26637, 26638, 26639, 27905, 27948, 156, 9641, 6933, 470, 9533, 9534, 9535, 9536, 9537, 9538, 29066, 157, 9539, 9540, 9541, 9542, 9543, 9544, 9545, 9546, 9547, 9548, 9549, 9550, 9551, 9552, 9553, 9554, 24618, 28503, 158, 159, 160, 161, 162, 9555, 9556, 9557, 9558, 9559, 9560, 163, 164, 9561, 9562, 9563, 9564, 9565, 9566, 9567, 9568, 9569, 9570, 9571, 9572, 9573, 9574, 9575, 9576, 9577, 9578, 9579, 9580, 9581, 9582, 9583, 9584, 9585, 9586, 9587, 9588, 9589, 9590, 9591, 9592, 9593, 9594, 9595, 9596, 9597, 9598, 9599, 9600, 9601, 9602, 9603, 9604, 9605, 9606, 9607, 9608, 9609, 9610, 9611, 9612, 9613, 9614, 9615, 9616, 9617, 9618, 9619, 9620, 9621, 9622, 9623, 9624, 9625, 9626, 9627, 9628, 9629, 9630, 9631, 9632, 9633, 9634, 9635, 9636, 9637, 165, 166, 9639, 9640, 9642, 9643, 9644, 9645, 9646, 9647, 9648, 9649, 9650, 9651, 9652, 9653, 9654, 9655, 9656, 9657, 9658, 9659, 9660, 9661, 9662, 9663, 9664, 9665, 9666, 9667, 9668, 9669, 9670, 9671, 9672, 9673, 9674, 9675, 9676, 9677, 9678, 9679, 9680, 9681, 9682, 9683, 9684, 9685, 9686, 9687, 9688, 9689, 9690, 9691, 9692, 9693, 9694, 9695, 9696, 9697, 9698, 9699, 9700, 9701, 9702, 9703, 9704, 9705, 9706, 9707, 9708, 9709, 9710, 9711, 9712, 9713, 9714, 9715, 9716, 9717, 9718, 9719, 9720, 9721, 9722, 25741, 28661, 167, 9723, 9724, 9725, 9726, 9727, 9728, 9729, 9730, 9731, 9732, 9733, 9734, 9735, 9736, 9737, 9738, 9739, 9740, 9741, 9742, 9743, 9744, 9745, 9746, 9747, 9748, 9749, 9750, 9751, 9752, 23629, 27840, 27994, 28687, 168, 9753, 9754, 9755, 9756, 9757, 9758, 9759, 9760, 9761, 9762, 9763, 9764, 9765, 9766, 9767, 9768, 9769, 9770, 9771, 9772, 9773, 9774, 9775, 9776, 9777, 9778, 9779, 28274, 169, 9780, 9781, 9782, 9784, 9785, 9786, 9787, 9788, 9789, 9790, 9791, 9792, 9793, 9794, 9795, 170, 1024, 1025, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 9796, 9797, 174, 183, 184, 9798, 9799, 9800, 9801, 9802, 9803, 9804, 9805, 9806, 9807, 9808, 9809, 9810, 9811, 9812, 9813, 9814, 9815, 9816, 9817, 9818, 9819, 9820, 9821, 9822, 9823, 9824, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9833, 9834, 9835, 9836, 9837, 9838, 9839, 9840, 9841, 9842, 9843, 9844, 9845, 9846, 9847, 9848, 9849, 9850, 9851, 9852, 9853, 9854, 9855, 9856, 9857, 9858, 9859, 9860, 9861, 9862, 9863, 9864, 9865, 9866, 9867, 9868, 9869, 9870, 9871, 9872, 9873, 9874, 9875, 9876, 9877, 9878, 9879, 9880, 9881, 9882, 9883, 9884, 9885, 9886, 9887, 9888, 9889, 9890, 9891, 9892, 9893, 9894, 9895, 9896, 9897, 9898, 9899, 9900, 9901, 9902, 9903, 9904, 9905, 9906, 9907, 9908, 9909, 9910, 9911, 9912, 9913, 9914, 9915, 9916, 9917, 9918, 9919, 9920, 9921, 9922, 9923, 9924, 9925, 9926, 9927, 9928, 9929, 9930, 26652, 26653, 26654, 26655, 26656, 27777, 28055, 185, 186, 187, 188, 189, 190, 191, 1226, 1276, 24063, 173, 172, 171, 24950, 25042, 128, 5533, 1299, 1300, 1301, 1302, 1304, 1305, 1316, 6959, 1330, 7092, 7094, 7498, 23986, 24266, 24286, 24372, 24392, 24393, 24400, 24401, 24403, 24404, 24409, 24450, 24582, 25637, 25774, 26721, 27001, 27356, 27477, 28089, 28813, 21171, 23796, 23978, 23988, 23989, 24044, 24045, 25388, 24179, 24204, 24208, 24253, 25541, 25542, 26279, 26280, 26316, 28743)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4;
17.50 ms (9.88%)	2	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 11874 AND l0_._right >= 13547 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 11874 AND l0_._right >= 13547 AND l0_.root = ? ORDER BY l0_._left ASC SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 11874 AND l0_._right >= 13547 AND l0_.root = 1 ORDER BY l0_._left ASC;
8.10 ms (4.57%)	1	SELECT d0_.id AS id_0, d0_.content AS content_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.comments_counter AS comments_counter_5, d0_.deleted_at AS deleted_at_6, d0_.severity AS severity_7, d0_.subscribers_notified AS subscribers_notified_8, d0_.reach_count AS reach_count_9, d0_.user_id AS user_id_10, d0_.location_id AS location_id_11, d0_.category_id AS category_id_12 FROM discussions d0_ WHERE (d0_.status = ? AND d0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d0_.comments_counter = 0) AND (d0_.deleted_at IS NULL) ORDER BY d0_.comments_counter DESC, d0_.created_at DESC Parameters: [2 34 152 7178 7180 7181 7337 7341 7342 7344 7345 7346 7347 7348 7351 7352 7353 7354 7355 7356 7357 7360 24196 24481 24946 26851 26852 26853 27478 27623 27860 27873 27909 27966 28003 28151 28306 28322 28449 28513 28732 28733 28745 28845 1298 7425 1346 6986 9462 9931 9932 9933 9934 9935 9936 9937 9938 9939 9940 9941 9942 9943 9944 9945 9946 9947 9948 9949 9950 9951 9952 9953 9954 9955 9956 9957 9958 9959 9960 9961 9962 9963 9964 9965 9966 9967 9968 9969 9970 9971 9972 9973 9974 9975 9976 9977 9978 9979 9980 9981 9982 9983 9984 9985 9986 9987 9988 9989 9990 9991 9992 9993 9994 9995 9996 9997 9998 9999 10000 10001 10002 10003 10004 10005 10006 10007 28691 7062 151 9148 9149 9150 9151 9152 9153 9154 9155 9156 9157 9158 9159 9160 9430 9431 9432 9433 9434 9435 9436 9437 9438 9439 9440 9441 9442 26854 26855 26860 26861 26862 26863 7063 7064 153 9783 7420 7427 9443 9444 9445 9446 9447 9448 9449 9450 9451 9452 9453 9454 9455 9456 9457 9458 9459 9460 9461 9463 9464 9465 9466 9467 9468 9469 9470 9471 9472 9473 9474 9475 9476 9477 9478 9479 9480 9481 9482 9483 9484 9485 9486 9487 9488 9489 9490 9491 9492 9493 9494 9495 9496 9497 9498 9499 9500 9501 9502 9503 9504 9505 9506 9507 9508 9509 9510 9511 9512 9513 9514 9515 9516 9517 9518 9519 9520 9521 9522 9523 9524 9525 9526 9527 9528 9529 9530 9531 9532 27680 27971 28326 28728 154 7377 7378 7379 7380 7381 7382 7383 7384 7385 7386 7387 7388 7389 7390 7391 7392 7393 7394 7395 7396 7397 7398 7399 7400 7401 7402 7403 7404 7405 7406 7407 7408 23788 24126 26864 26882 26883 26884 26885 26886 28989 155 28377 7418 7476 25411 25514 25524 26618 26619 26620 26621 26622 26635 26636 26637 26638 26639 27905 27948 156 9641 6933 470 9533 9534 9535 9536 9537 9538 29066 157 9539 9540 9541 9542 9543 9544 9545 9546 9547 9548 9549 9550 9551 9552 9553 9554 24618 28503 158 159 160 161 162 9555 9556 9557 9558 9559 9560 163 164 9561 9562 9563 9564 9565 9566 9567 9568 9569 9570 9571 9572 9573 9574 9575 9576 9577 9578 9579 9580 9581 9582 9583 9584 9585 9586 9587 9588 9589 9590 9591 9592 9593 9594 9595 9596 9597 9598 9599 9600 9601 9602 9603 9604 9605 9606 9607 9608 9609 9610 9611 9612 9613 9614 9615 9616 9617 9618 9619 9620 9621 9622 9623 9624 9625 9626 9627 9628 9629 9630 9631 9632 9633 9634 9635 9636 9637 165 166 9639 9640 9642 9643 9644 9645 9646 9647 9648 9649 9650 9651 9652 9653 9654 9655 9656 9657 9658 9659 9660 9661 9662 9663 9664 9665 9666 9667 9668 9669 9670 9671 9672 9673 9674 9675 9676 9677 9678 9679 9680 9681 9682 9683 9684 9685 9686 9687 9688 9689 9690 9691 9692 9693 9694 9695 9696 9697 9698 9699 9700 9701 9702 9703 9704 9705 9706 9707 9708 9709 9710 9711 9712 9713 9714 9715 9716 9717 9718 9719 9720 9721 9722 25741 28661 167 9723 9724 9725 9726 9727 9728 9729 9730 9731 9732 9733 9734 9735 9736 9737 9738 9739 9740 9741 9742 9743 9744 9745 9746 9747 9748 9749 9750 9751 9752 23629 27840 27994 28687 168 9753 9754 9755 9756 9757 9758 9759 9760 9761 9762 9763 9764 9765 9766 9767 9768 9769 9770 9771 9772 9773 9774 9775 9776 9777 9778 9779 28274 169 9780 9781 9782 9784 9785 9786 9787 9788 9789 9790 9791 9792 9793 9794 9795 170 1024 1025 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 9796 9797 174 183 184 9798 9799 9800 9801 9802 9803 9804 9805 9806 9807 9808 9809 9810 9811 9812 9813 9814 9815 9816 9817 9818 9819 9820 9821 9822 9823 9824 9825 9826 9827 9828 9829 9830 9831 9832 9833 9834 9835 9836 9837 9838 9839 9840 9841 9842 9843 9844 9845 9846 9847 9848 9849 9850 9851 9852 9853 9854 9855 9856 9857 9858 9859 9860 9861 9862 9863 9864 9865 9866 9867 9868 9869 9870 9871 9872 9873 9874 9875 9876 9877 9878 9879 9880 9881 9882 9883 9884 9885 9886 9887 9888 9889 9890 9891 9892 9893 9894 9895 9896 9897 9898 9899 9900 9901 9902 9903 9904 9905 9906 9907 9908 9909 9910 9911 9912 9913 9914 9915 9916 9917 9918 9919 9920 9921 9922 9923 9924 9925 9926 9927 9928 9929 9930 26652 26653 26654 26655 26656 27777 28055 185 186 187 188 189 190 191 1226 1276 24063 173 172 171 24950 25042 128 5533 1299 1300 1301 1302 1304 1305 1316 6959 1330 7092 7094 7498 23986 24266 24286 24372 24392 24393 24400 24401 24403 24404 24409 24450 24582 25637 25774 26721 27001 27356 27477 28089 28813 21171 23796 23978 23988 23989 24044 24045 25388 24179 24204 24208 24253 25541 25542 26279 26280 26316 28743] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.content AS content_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.comments_counter AS comments_counter_5, d0_.deleted_at AS deleted_at_6, d0_.severity AS severity_7, d0_.subscribers_notified AS subscribers_notified_8, d0_.reach_count AS reach_count_9, d0_.user_id AS user_id_10, d0_.location_id AS location_id_11, d0_.category_id AS category_id_12 FROM discussions d0_ WHERE ( d0_.status = ? AND d0_.location_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND d0_.comments_counter = 0 ) AND (d0_.deleted_at IS NULL) ORDER BY d0_.comments_counter DESC, d0_.created_at DESC SELECT d0_.id AS id_0, d0_.content AS content_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.comments_counter AS comments_counter_5, d0_.deleted_at AS deleted_at_6, d0_.severity AS severity_7, d0_.subscribers_notified AS subscribers_notified_8, d0_.reach_count AS reach_count_9, d0_.user_id AS user_id_10, d0_.location_id AS location_id_11, d0_.category_id AS category_id_12 FROM discussions d0_ WHERE (d0_.status = 2 AND d0_.location_id IN (34, 152, 7178, 7180, 7181, 7337, 7341, 7342, 7344, 7345, 7346, 7347, 7348, 7351, 7352, 7353, 7354, 7355, 7356, 7357, 7360, 24196, 24481, 24946, 26851, 26852, 26853, 27478, 27623, 27860, 27873, 27909, 27966, 28003, 28151, 28306, 28322, 28449, 28513, 28732, 28733, 28745, 28845, 1298, 7425, 1346, 6986, 9462, 9931, 9932, 9933, 9934, 9935, 9936, 9937, 9938, 9939, 9940, 9941, 9942, 9943, 9944, 9945, 9946, 9947, 9948, 9949, 9950, 9951, 9952, 9953, 9954, 9955, 9956, 9957, 9958, 9959, 9960, 9961, 9962, 9963, 9964, 9965, 9966, 9967, 9968, 9969, 9970, 9971, 9972, 9973, 9974, 9975, 9976, 9977, 9978, 9979, 9980, 9981, 9982, 9983, 9984, 9985, 9986, 9987, 9988, 9989, 9990, 9991, 9992, 9993, 9994, 9995, 9996, 9997, 9998, 9999, 10000, 10001, 10002, 10003, 10004, 10005, 10006, 10007, 28691, 7062, 151, 9148, 9149, 9150, 9151, 9152, 9153, 9154, 9155, 9156, 9157, 9158, 9159, 9160, 9430, 9431, 9432, 9433, 9434, 9435, 9436, 9437, 9438, 9439, 9440, 9441, 9442, 26854, 26855, 26860, 26861, 26862, 26863, 7063, 7064, 153, 9783, 7420, 7427, 9443, 9444, 9445, 9446, 9447, 9448, 9449, 9450, 9451, 9452, 9453, 9454, 9455, 9456, 9457, 9458, 9459, 9460, 9461, 9463, 9464, 9465, 9466, 9467, 9468, 9469, 9470, 9471, 9472, 9473, 9474, 9475, 9476, 9477, 9478, 9479, 9480, 9481, 9482, 9483, 9484, 9485, 9486, 9487, 9488, 9489, 9490, 9491, 9492, 9493, 9494, 9495, 9496, 9497, 9498, 9499, 9500, 9501, 9502, 9503, 9504, 9505, 9506, 9507, 9508, 9509, 9510, 9511, 9512, 9513, 9514, 9515, 9516, 9517, 9518, 9519, 9520, 9521, 9522, 9523, 9524, 9525, 9526, 9527, 9528, 9529, 9530, 9531, 9532, 27680, 27971, 28326, 28728, 154, 7377, 7378, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7387, 7388, 7389, 7390, 7391, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7400, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7408, 23788, 24126, 26864, 26882, 26883, 26884, 26885, 26886, 28989, 155, 28377, 7418, 7476, 25411, 25514, 25524, 26618, 26619, 26620, 26621, 26622, 26635, 26636, 26637, 26638, 26639, 27905, 27948, 156, 9641, 6933, 470, 9533, 9534, 9535, 9536, 9537, 9538, 29066, 157, 9539, 9540, 9541, 9542, 9543, 9544, 9545, 9546, 9547, 9548, 9549, 9550, 9551, 9552, 9553, 9554, 24618, 28503, 158, 159, 160, 161, 162, 9555, 9556, 9557, 9558, 9559, 9560, 163, 164, 9561, 9562, 9563, 9564, 9565, 9566, 9567, 9568, 9569, 9570, 9571, 9572, 9573, 9574, 9575, 9576, 9577, 9578, 9579, 9580, 9581, 9582, 9583, 9584, 9585, 9586, 9587, 9588, 9589, 9590, 9591, 9592, 9593, 9594, 9595, 9596, 9597, 9598, 9599, 9600, 9601, 9602, 9603, 9604, 9605, 9606, 9607, 9608, 9609, 9610, 9611, 9612, 9613, 9614, 9615, 9616, 9617, 9618, 9619, 9620, 9621, 9622, 9623, 9624, 9625, 9626, 9627, 9628, 9629, 9630, 9631, 9632, 9633, 9634, 9635, 9636, 9637, 165, 166, 9639, 9640, 9642, 9643, 9644, 9645, 9646, 9647, 9648, 9649, 9650, 9651, 9652, 9653, 9654, 9655, 9656, 9657, 9658, 9659, 9660, 9661, 9662, 9663, 9664, 9665, 9666, 9667, 9668, 9669, 9670, 9671, 9672, 9673, 9674, 9675, 9676, 9677, 9678, 9679, 9680, 9681, 9682, 9683, 9684, 9685, 9686, 9687, 9688, 9689, 9690, 9691, 9692, 9693, 9694, 9695, 9696, 9697, 9698, 9699, 9700, 9701, 9702, 9703, 9704, 9705, 9706, 9707, 9708, 9709, 9710, 9711, 9712, 9713, 9714, 9715, 9716, 9717, 9718, 9719, 9720, 9721, 9722, 25741, 28661, 167, 9723, 9724, 9725, 9726, 9727, 9728, 9729, 9730, 9731, 9732, 9733, 9734, 9735, 9736, 9737, 9738, 9739, 9740, 9741, 9742, 9743, 9744, 9745, 9746, 9747, 9748, 9749, 9750, 9751, 9752, 23629, 27840, 27994, 28687, 168, 9753, 9754, 9755, 9756, 9757, 9758, 9759, 9760, 9761, 9762, 9763, 9764, 9765, 9766, 9767, 9768, 9769, 9770, 9771, 9772, 9773, 9774, 9775, 9776, 9777, 9778, 9779, 28274, 169, 9780, 9781, 9782, 9784, 9785, 9786, 9787, 9788, 9789, 9790, 9791, 9792, 9793, 9794, 9795, 170, 1024, 1025, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 9796, 9797, 174, 183, 184, 9798, 9799, 9800, 9801, 9802, 9803, 9804, 9805, 9806, 9807, 9808, 9809, 9810, 9811, 9812, 9813, 9814, 9815, 9816, 9817, 9818, 9819, 9820, 9821, 9822, 9823, 9824, 9825, 9826, 9827, 9828, 9829, 9830, 9831, 9832, 9833, 9834, 9835, 9836, 9837, 9838, 9839, 9840, 9841, 9842, 9843, 9844, 9845, 9846, 9847, 9848, 9849, 9850, 9851, 9852, 9853, 9854, 9855, 9856, 9857, 9858, 9859, 9860, 9861, 9862, 9863, 9864, 9865, 9866, 9867, 9868, 9869, 9870, 9871, 9872, 9873, 9874, 9875, 9876, 9877, 9878, 9879, 9880, 9881, 9882, 9883, 9884, 9885, 9886, 9887, 9888, 9889, 9890, 9891, 9892, 9893, 9894, 9895, 9896, 9897, 9898, 9899, 9900, 9901, 9902, 9903, 9904, 9905, 9906, 9907, 9908, 9909, 9910, 9911, 9912, 9913, 9914, 9915, 9916, 9917, 9918, 9919, 9920, 9921, 9922, 9923, 9924, 9925, 9926, 9927, 9928, 9929, 9930, 26652, 26653, 26654, 26655, 26656, 27777, 28055, 185, 186, 187, 188, 189, 190, 191, 1226, 1276, 24063, 173, 172, 171, 24950, 25042, 128, 5533, 1299, 1300, 1301, 1302, 1304, 1305, 1316, 6959, 1330, 7092, 7094, 7498, 23986, 24266, 24286, 24372, 24392, 24393, 24400, 24401, 24403, 24404, 24409, 24450, 24582, 25637, 25774, 26721, 27001, 27356, 27477, 28089, 28813, 21171, 23796, 23978, 23988, 23989, 24044, 24045, 25388, 24179, 24204, 24208, 24253, 25541, 25542, 26279, 26280, 26316, 28743) AND d0_.comments_counter = 0) AND (d0_.deleted_at IS NULL) ORDER BY d0_.comments_counter DESC, d0_.created_at DESC;
6.94 ms (3.92%)	2	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC Parameters: [`false`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 FROM property_types p0_ WHERE ( p0_.level = 1 AND p0_.private = ? ) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = 0) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC;
6.52 ms (3.68%)	1	SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 Parameters: [`false true`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = 0 AND l0_.searchable = 1 LIMIT 1;
5.62 ms (3.17%)	2	SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC Parameters: [`1 8 7 16 11 5 14 13 47 38 10 34 1 5`] View formatted query View runnable query Explain query SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE ( s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ? ) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (1, 8, 7, 16, 11, 5, 14, 13, 47, 38, 10) AND s1_.location_id IN (34) AND s1_.section_id = 1 AND s1_.search_result_count >= 5) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC;
4.43 ms (2.50%)	1	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) Parameters: [`"58" "20" "376" "213" "222"`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE ( l0_.id IN (?, ?, ?, ?, ?) ) AND (l0_.deleted_at IS NULL) SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.id IN ('58', '20', '376', '213', '222')) AND (l0_.deleted_at IS NULL);
4.34 ms (2.45%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = ? Parameters: [`"34"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = '34';
3.66 ms (2.07%)	1	SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_;
3.09 ms (1.74%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.amenities AS amenities_19, t0.parent_id AS parent_id_20 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.amenities AS amenities_19, t0.parent_id AS parent_id_20 FROM property_types t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.amenities AS amenities_19, t0.parent_id AS parent_id_20 FROM property_types t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
2.94 ms (1.66%)	1	SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ? Parameters: [`1 "2026-03-07 04:42:41"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ? SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (1) AND a0_.end_at >= '2026-03-07 04:42:41';
2.75 ms (1.55%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0;
2.51 ms (1.42%)	1	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ? Parameters: [`"web.enable.facebooklogin"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ? SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = 'web.enable.facebooklogin';
2.51 ms (1.42%)	1	SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = ?) AND (p0_.deleted_at IS NULL) Parameters: [`83`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM property_types p0_ WHERE ( p0_._right < 41 AND p0_._left > 2 AND p0_.root = ? ) AND (p0_.deleted_at IS NULL) SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = 83) AND (p0_.deleted_at IS NULL);

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.

Managed Entities

default entity manager

Class	Amount of managed objects
Aqarmap\Bundle\ListingBundle\Entity\Location	838
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	105
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	75
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	12
Aqarmap\Bundle\ListingBundle\Entity\Section	2
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound	2
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion	2
Aqarmap\Bundle\UserBundle\Entity\User	2
Aqarmap\Bundle\DiscussionBundle\Entity\Category	1

Entities Mapping

Class	Mapping errors
Aqarmap\Bundle\ListingBundle\Entity\Location	The mappings Aqarmap\Bundle\ListingBundle\Entity\Location#childrenSortedById and Aqarmap\Bundle\ListingBundle\Entity\Location#parent are inconsistent with each other.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle	No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Listing	The field Aqarmap\Bundle\ListingBundle\Entity\Listing#compoundAveragePrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#parentCompound does not contain the required 'inversedBy="compoundAveragePrices"' attribute.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics	No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer	No errors.
Aqarmap\Bundle\MainBundle\Entity\Setting	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation	No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Section	No errors.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationTranslation	No errors.
Aqarmap\Bundle\CRMBundle\Entity\Company	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationSupplyDemand	No errors.
Aqarmap\Bundle\NotifierBundle\Entity\Notifier	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserInterest	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto	No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion	No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	No errors.
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm	No errors.
App\Entity\Location\LocationTier	No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation	No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CustomField	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice	No errors.
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation	No errors.
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Category	No errors.
Aqarmap\Bundle\UserBundle\Entity\User	The field Aqarmap\Bundle\UserBundle\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\CRMBundle\Entity\Company#referedBy does not contain the required 'inversedBy="referrals"' attribute. The field Aqarmap\Bundle\UserBundle\Entity\User#recurringTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#user does not contain the required 'inversedBy="recurringTransactions"' attribute. The field Aqarmap\Bundle\UserBundle\Entity\User#geoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserGeoLocation#user does not contain the required 'inversedBy="geoLocations"' attribute. The field Aqarmap\Bundle\UserBundle\Entity\User#packages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\UserBundle\Entity\UserPackages#user does not contain the required 'inversedBy="packages"' attribute.
Aqarmap\Bundle\DiscussionBundle\Entity\Comment	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation	No errors.

Symfony Profiler

GET https://testing-eg.am-root.com/ar/ask-neighbors/?location=34&tab=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping