https://forms.toadhallcottages.co.uk/forms/api/list?brand=NFC

Method
GET
HTTP Status
200
IP
87.224.40.23
Profiled on
Token
2bc65e

Query Metrics

54 Database Queries
6 Different statements
65.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
34.27 ms
(52.19%) 		1 
SELECT f0_.ID AS ID_0, f0_.Date AS Date_1, f0_.uuid AS uuid_2, f0_.version AS version_3, f0_.user_id AS user_id_4, f0_.brand AS brand_5, f0_.propname AS propname_6, f0_.extbuildappear AS extbuildappear_7, f0_.extparkfacility AS extparkfacility_8, f0_.extsiding AS extsiding_9, f0_.extwall AS extwall_10, f0_.extbarbecus AS extbarbecus_11, f0_.extgarfurniture AS extgarfurniture_12, f0_.extgates AS extgates_13, f0_.extdogs AS extdogs_14, f0_.extnotes AS extnotes_15, f0_.extpic1 AS extpic1_16, f0_.extpic2 AS extpic2_17, f0_.extpic3 AS extpic3_18, f0_.extpic4 AS extpic4_19, f0_.beddecor AS beddecor_20, f0_.bedfurniture AS bedfurniture_21, f0_.bedflooring AS bedflooring_22, f0_.bedlight AS bedlight_23, f0_.bedbeds AS bedbeds_24, f0_.bedbedding AS bedbedding_25, f0_.bediflooring AS bediflooring_26, f0_.bedcurtain AS bedcurtain_27, f0_.bedheadboard AS bedheadboard_28, f0_.bedmatress AS bedmatress_29, f0_.bedmatressp AS bedmatressp_30, f0_.bedDuvet AS bedDuvet_31, f0_.bedValances AS bedValances_32, f0_.bedpillow AS bedpillow_33, f0_.bedpillowSlips AS bedpillowSlips_34, f0_.bedBSTable AS bedBSTable_35, f0_.bedhanger AS bedhanger_36, f0_.bedmirror AS bedmirror_37, f0_.bedwardrobe AS bedwardrobe_38, f0_.bedbin AS bedbin_39, f0_.bednotes AS bednotes_40, f0_.bedpic1 AS bedpic1_41, f0_.bedpic2 AS bedpic2_42, f0_.bedpic3 AS bedpic3_43, f0_.bedpic4 AS bedpic4_44, f0_.bathdecor AS bathdecor_45, f0_.bathfurniture AS bathfurniture_46, f0_.bathflooring AS bathflooring_47, f0_.bathlighting AS bathlighting_48, f0_.bathbrush AS bathbrush_49, f0_.bathmirror AS bathmirror_50, f0_.bathshave AS bathshave_51, f0_.bathmat AS bathmat_52, f0_.bathbin AS bathbin_53, f0_.bathtowelrack AS bathtowelrack_54, f0_.bathnotes AS bathnotes_55, f0_.bathpic1 AS bathpic1_56, f0_.bathpic2 AS bathpic2_57, f0_.bathpic3 AS bathpic3_58, f0_.bathpic4 AS bathpic4_59, f0_.kitdecor AS kitdecor_60, f0_.kitfurniture AS kitfurniture_61, f0_.kitflooring AS kitflooring_62, f0_.kitlighting AS kitlighting_63, f0_.kitgas AS kitgas_64, f0_.kitequipment AS kitequipment_65, f0_.kitutensils AS kitutensils_66, f0_.kiticooker AS kiticooker_67, f0_.kitifreezer AS kitifreezer_68, f0_.kitwashmachine AS kitwashmachine_69, f0_.kitdryer AS kitdryer_70, f0_.kitiron AS kitiron_71, f0_.kitwasher AS kitwasher_72, f0_.kitmicrowave AS kitmicrowave_73, f0_.kitkettle AS kitkettle_74, f0_.kittoaster AS kittoaster_75, f0_.kitsaucepan AS kitsaucepan_76, f0_.kitfrypan AS kitfrypan_77, f0_.kitiutensils AS kitiutensils_78, f0_.ktcookware AS ktcookware_79, f0_.kitcutlery AS kitcutlery_80, f0_.kitcrockery AS kitcrockery_81, f0_.kitGlasses AS kitGlasses_82, f0_.kitSaltAndPepper AS kitSaltAndPepper_83, f0_.kitWUP AS kitWUP_84, f0_.kitClean AS kitClean_85, f0_.kitnotes AS kitnotes_86, f0_.kitpic1 AS kitpic1_87, f0_.kitpci2 AS kitpci2_88, f0_.kitpic3 AS kitpic3_89, f0_.kitpic4 AS kitpic4_90, f0_.pdecor AS pdecor_91, f0_.pfurniture AS pfurniture_92, f0_.pflooring AS pflooring_93, f0_.plighting AS plighting_94, f0_.piflooring AS piflooring_95, f0_.pseating AS pseating_96, f0_.pcurtain AS pcurtain_97, f0_.pcoffeetable AS pcoffeetable_98, f0_.plamp AS plamp_99, f0_.pdintable AS pdintable_100, f0_.ptablemat AS ptablemat_101, f0_.pbin AS pbin_102, f0_.pvaccum AS pvaccum_103, f0_.pnotes AS pnotes_104, f0_.ppic1 AS ppic1_105, f0_.ppic2 AS ppic2_106, f0_.ppic3 AS ppic3_107, f0_.ppic4 AS ppic4_108, f0_.cliving AS cliving_109, f0_.cbed AS cbed_110, f0_.cbath AS cbath_111, f0_.ckit AS ckit_112, f0_.cnotes AS cnotes_113, f0_.cpic1 AS cpic1_114, f0_.cpic2 AS cpic2_115, f0_.cpic3 AS cpic3_116, f0_.cpic4 AS cpic4_117, f0_.minfo AS minfo_118, f0_.mwelcome AS mwelcome_119, f0_.marrival AS marrival_120, f0_.mwifi AS mwifi_121, f0_.maccessories AS maccessories_122, f0_.mspace AS mspace_123, f0_.mfirerisk AS mfirerisk_124, f0_.mfra AS mfra_125, f0_.mboiler AS mboiler_126, f0_.mpat AS mpat_127, f0_.melectrictest AS melectrictest_128, f0_.mlegionela AS mlegionela_129, f0_.minsurrance AS minsurrance_130, f0_.meBlindCord AS meBlindCord_131, f0_.mcot AS mcot_132, f0_.mcotprop AS mcotprop_133, f0_.mhighchair AS mhighchair_134, f0_.mhighchairprop AS mhighchairprop_135, f0_.mstairgate AS mstairgate_136, f0_.mstairgateprop AS mstairgateprop_137, f0_.mnotes AS mnotes_138, f0_.mpic1 AS mpic1_139, f0_.mpic2 AS mpic2_140, f0_.mpic3 AS mpic3_141, f0_.mpic4 AS mpic4_142, f0_.ffeachfloor AS ffeachfloor_143, f0_.ffpressure AS ffpressure_144, f0_.ffvi AS ffvi_145, f0_.ffseal AS ffseal_146, f0_.ffdate AS ffdate_147, f0_.ffcoment AS ffcoment_148, f0_.fbtab AS fbtab_149, f0_.fbvi AS fbvi_150, f0_.fbcoment AS fbcoment_151, f0_.fevi AS fevi_152, f0_.fecoment AS fecoment_153, f0_.fsvi AS fsvi_154, f0_.fscoment AS fscoment_155, f0_.fwtemp AS fwtemp_156, f0_.chimney AS chimney_157, f0_.chimneydate AS chimneydate_158, f0_.fwcoment AS fwcoment_159, f0_.faplace AS faplace_160, f0_.fadesign AS fadesign_161, f0_.favi AS favi_162, f0_.facoment AS facoment_163, f0_.fcloc AS fcloc_164, f0_.fcdesign AS fcdesign_165, f0_.fcvi AS fcvi_166, f0_.fccoment AS fccoment_167, f0_.summary AS summary_168, f0_.miscpic1 AS miscpic1_169, f0_.miscpic2 AS miscpic2_170, f0_.miscpic3 AS miscpic3_171, f0_.miscpic4 AS miscpic4_172, f0_.Exterior_Total AS Exterior_Total_173, f0_.Bedroom_Score AS Bedroom_Score_174, f0_.Bathroom_Score AS Bathroom_Score_175, f0_.Kitchen_Score AS Kitchen_Score_176, f0_.Cleanliness_Score AS Cleanliness_Score_177, f0_.Management_Efficiency_Score AS Management_Efficiency_Score_178, f0_.Public_Area_Score AS Public_Area_Score_179, f0_.Total_Score AS Total_Score_180, f0_.stars AS stars_181, f0_.is_deleted AS is_deleted_182, f0_.ptv AS ptv_183 FROM forms f0_ WHERE f0_.is_deleted = 0 ORDER BY f0_.ID DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
16.11 ms
(24.53%) 		25 
SELECT t0.id AS id_1, t0.name AS name_2, t0.beddecor AS beddecor_3, t0.bedfurniture AS bedfurniture_4, t0.bedflooring AS bedflooring_5, t0.bedlight AS bedlight_6, t0.bedbeds AS bedbeds_7, t0.bedbedding AS bedbedding_8, t0.bediflooring AS bediflooring_9, t0.bedcurtain AS bedcurtain_10, t0.bedheadboard AS bedheadboard_11, t0.bedmatress AS bedmatress_12, t0.bedmatressp AS bedmatressp_13, t0.bedDuvet AS bedDuvet_14, t0.bedValances AS bedValances_15, t0.bedpillow AS bedpillow_16, t0.bedpillowSlips AS bedpillowSlips_17, t0.bedBSTable AS bedBSTable_18, t0.bedhanger AS bedhanger_19, t0.bedmirror AS bedmirror_20, t0.bedwardrobe AS bedwardrobe_21, t0.bedbin AS bedbin_22, t0.bednotes AS bednotes_23, t0.forms_id AS forms_id_24 FROM bedroom t0 WHERE t0.forms_id = ?
Parameters: 
[
  990
]
View formatted query    View runnable query    Explain query
8.86 ms
(13.49%) 		25 
SELECT t0.id AS id_1, t0.name AS name_2, t0.bathdecor AS bathdecor_3, t0.bathfurniture AS bathfurniture_4, t0.bathflooring AS bathflooring_5, t0.bathlighting AS bathlighting_6, t0.bathbrush AS bathbrush_7, t0.bathmirror AS bathmirror_8, t0.bathshave AS bathshave_9, t0.bathmat AS bathmat_10, t0.bathbin AS bathbin_11, t0.bathtowelrack AS bathtowelrack_12, t0.fsvi AS fsvi_13, t0.fscoment AS fscoment_14, t0.bathnotes AS bathnotes_15, t0.forms_id AS forms_id_16 FROM bathroom t0 WHERE t0.forms_id = ?
Parameters: 
[
  990
]
View formatted query    View runnable query    Explain query
3.89 ms
(5.93%) 		1 
SELECT DISTINCT ID_0 FROM (SELECT DISTINCT ID_0, Date_1 FROM (SELECT f0_.ID AS ID_0, f0_.Date AS Date_1, f0_.uuid AS uuid_2, f0_.version AS version_3, f0_.user_id AS user_id_4, f0_.brand AS brand_5, f0_.propname AS propname_6, f0_.extbuildappear AS extbuildappear_7, f0_.extparkfacility AS extparkfacility_8, f0_.extsiding AS extsiding_9, f0_.extwall AS extwall_10, f0_.extbarbecus AS extbarbecus_11, f0_.extgarfurniture AS extgarfurniture_12, f0_.extgates AS extgates_13, f0_.extdogs AS extdogs_14, f0_.extnotes AS extnotes_15, f0_.extpic1 AS extpic1_16, f0_.extpic2 AS extpic2_17, f0_.extpic3 AS extpic3_18, f0_.extpic4 AS extpic4_19, f0_.beddecor AS beddecor_20, f0_.bedfurniture AS bedfurniture_21, f0_.bedflooring AS bedflooring_22, f0_.bedlight AS bedlight_23, f0_.bedbeds AS bedbeds_24, f0_.bedbedding AS bedbedding_25, f0_.bediflooring AS bediflooring_26, f0_.bedcurtain AS bedcurtain_27, f0_.bedheadboard AS bedheadboard_28, f0_.bedmatress AS bedmatress_29, f0_.bedmatressp AS bedmatressp_30, f0_.bedDuvet AS bedDuvet_31, f0_.bedValances AS bedValances_32, f0_.bedpillow AS bedpillow_33, f0_.bedpillowSlips AS bedpillowSlips_34, f0_.bedBSTable AS bedBSTable_35, f0_.bedhanger AS bedhanger_36, f0_.bedmirror AS bedmirror_37, f0_.bedwardrobe AS bedwardrobe_38, f0_.bedbin AS bedbin_39, f0_.bednotes AS bednotes_40, f0_.bedpic1 AS bedpic1_41, f0_.bedpic2 AS bedpic2_42, f0_.bedpic3 AS bedpic3_43, f0_.bedpic4 AS bedpic4_44, f0_.bathdecor AS bathdecor_45, f0_.bathfurniture AS bathfurniture_46, f0_.bathflooring AS bathflooring_47, f0_.bathlighting AS bathlighting_48, f0_.bathbrush AS bathbrush_49, f0_.bathmirror AS bathmirror_50, f0_.bathshave AS bathshave_51, f0_.bathmat AS bathmat_52, f0_.bathbin AS bathbin_53, f0_.bathtowelrack AS bathtowelrack_54, f0_.bathnotes AS bathnotes_55, f0_.bathpic1 AS bathpic1_56, f0_.bathpic2 AS bathpic2_57, f0_.bathpic3 AS bathpic3_58, f0_.bathpic4 AS bathpic4_59, f0_.kitdecor AS kitdecor_60, f0_.kitfurniture AS kitfurniture_61, f0_.kitflooring AS kitflooring_62, f0_.kitlighting AS kitlighting_63, f0_.kitgas AS kitgas_64, f0_.kitequipment AS kitequipment_65, f0_.kitutensils AS kitutensils_66, f0_.kiticooker AS kiticooker_67, f0_.kitifreezer AS kitifreezer_68, f0_.kitwashmachine AS kitwashmachine_69, f0_.kitdryer AS kitdryer_70, f0_.kitiron AS kitiron_71, f0_.kitwasher AS kitwasher_72, f0_.kitmicrowave AS kitmicrowave_73, f0_.kitkettle AS kitkettle_74, f0_.kittoaster AS kittoaster_75, f0_.kitsaucepan AS kitsaucepan_76, f0_.kitfrypan AS kitfrypan_77, f0_.kitiutensils AS kitiutensils_78, f0_.ktcookware AS ktcookware_79, f0_.kitcutlery AS kitcutlery_80, f0_.kitcrockery AS kitcrockery_81, f0_.kitGlasses AS kitGlasses_82, f0_.kitSaltAndPepper AS kitSaltAndPepper_83, f0_.kitWUP AS kitWUP_84, f0_.kitClean AS kitClean_85, f0_.kitnotes AS kitnotes_86, f0_.kitpic1 AS kitpic1_87, f0_.kitpci2 AS kitpci2_88, f0_.kitpic3 AS kitpic3_89, f0_.kitpic4 AS kitpic4_90, f0_.pdecor AS pdecor_91, f0_.pfurniture AS pfurniture_92, f0_.pflooring AS pflooring_93, f0_.plighting AS plighting_94, f0_.piflooring AS piflooring_95, f0_.pseating AS pseating_96, f0_.pcurtain AS pcurtain_97, f0_.pcoffeetable AS pcoffeetable_98, f0_.plamp AS plamp_99, f0_.pdintable AS pdintable_100, f0_.ptablemat AS ptablemat_101, f0_.pbin AS pbin_102, f0_.pvaccum AS pvaccum_103, f0_.pnotes AS pnotes_104, f0_.ppic1 AS ppic1_105, f0_.ppic2 AS ppic2_106, f0_.ppic3 AS ppic3_107, f0_.ppic4 AS ppic4_108, f0_.cliving AS cliving_109, f0_.cbed AS cbed_110, f0_.cbath AS cbath_111, f0_.ckit AS ckit_112, f0_.cnotes AS cnotes_113, f0_.cpic1 AS cpic1_114, f0_.cpic2 AS cpic2_115, f0_.cpic3 AS cpic3_116, f0_.cpic4 AS cpic4_117, f0_.minfo AS minfo_118, f0_.mwelcome AS mwelcome_119, f0_.marrival AS marrival_120, f0_.mwifi AS mwifi_121, f0_.maccessories AS maccessories_122, f0_.mspace AS mspace_123, f0_.mfirerisk AS mfirerisk_124, f0_.mfra AS mfra_125, f0_.mboiler AS mboiler_126, f0_.mpat AS mpat_127, f0_.melectrictest AS melectrictest_128, f0_.mlegionela AS mlegionela_129, f0_.minsurrance AS minsurrance_130, f0_.meBlindCord AS meBlindCord_131, f0_.mcot AS mcot_132, f0_.mcotprop AS mcotprop_133, f0_.mhighchair AS mhighchair_134, f0_.mhighchairprop AS mhighchairprop_135, f0_.mstairgate AS mstairgate_136, f0_.mstairgateprop AS mstairgateprop_137, f0_.mnotes AS mnotes_138, f0_.mpic1 AS mpic1_139, f0_.mpic2 AS mpic2_140, f0_.mpic3 AS mpic3_141, f0_.mpic4 AS mpic4_142, f0_.ffeachfloor AS ffeachfloor_143, f0_.ffpressure AS ffpressure_144, f0_.ffvi AS ffvi_145, f0_.ffseal AS ffseal_146, f0_.ffdate AS ffdate_147, f0_.ffcoment AS ffcoment_148, f0_.fbtab AS fbtab_149, f0_.fbvi AS fbvi_150, f0_.fbcoment AS fbcoment_151, f0_.fevi AS fevi_152, f0_.fecoment AS fecoment_153, f0_.fsvi AS fsvi_154, f0_.fscoment AS fscoment_155, f0_.fwtemp AS fwtemp_156, f0_.chimney AS chimney_157, f0_.chimneydate AS chimneydate_158, f0_.fwcoment AS fwcoment_159, f0_.faplace AS faplace_160, f0_.fadesign AS fadesign_161, f0_.favi AS favi_162, f0_.facoment AS facoment_163, f0_.fcloc AS fcloc_164, f0_.fcdesign AS fcdesign_165, f0_.fcvi AS fcvi_166, f0_.fccoment AS fccoment_167, f0_.summary AS summary_168, f0_.miscpic1 AS miscpic1_169, f0_.miscpic2 AS miscpic2_170, f0_.miscpic3 AS miscpic3_171, f0_.miscpic4 AS miscpic4_172, f0_.Exterior_Total AS Exterior_Total_173, f0_.Bedroom_Score AS Bedroom_Score_174, f0_.Bathroom_Score AS Bathroom_Score_175, f0_.Kitchen_Score AS Kitchen_Score_176, f0_.Cleanliness_Score AS Cleanliness_Score_177, f0_.Management_Efficiency_Score AS Management_Efficiency_Score_178, f0_.Public_Area_Score AS Public_Area_Score_179, f0_.Total_Score AS Total_Score_180, f0_.stars AS stars_181, f0_.is_deleted AS is_deleted_182, f0_.ptv AS ptv_183 FROM forms f0_ WHERE f0_.brand = ? AND f0_.is_deleted = 0) dctrn_result_inner ORDER BY Date_1 DESC) dctrn_result LIMIT 25
Parameters: 
[
  "NFC"
]
View formatted query    View runnable query    Explain query
2.02 ms
(3.08%) 		1 
SELECT f0_.ID AS ID_0, f0_.Date AS Date_1, f0_.uuid AS uuid_2, f0_.version AS version_3, f0_.user_id AS user_id_4, f0_.brand AS brand_5, f0_.propname AS propname_6, f0_.extbuildappear AS extbuildappear_7, f0_.extparkfacility AS extparkfacility_8, f0_.extsiding AS extsiding_9, f0_.extwall AS extwall_10, f0_.extbarbecus AS extbarbecus_11, f0_.extgarfurniture AS extgarfurniture_12, f0_.extgates AS extgates_13, f0_.extdogs AS extdogs_14, f0_.extnotes AS extnotes_15, f0_.extpic1 AS extpic1_16, f0_.extpic2 AS extpic2_17, f0_.extpic3 AS extpic3_18, f0_.extpic4 AS extpic4_19, f0_.beddecor AS beddecor_20, f0_.bedfurniture AS bedfurniture_21, f0_.bedflooring AS bedflooring_22, f0_.bedlight AS bedlight_23, f0_.bedbeds AS bedbeds_24, f0_.bedbedding AS bedbedding_25, f0_.bediflooring AS bediflooring_26, f0_.bedcurtain AS bedcurtain_27, f0_.bedheadboard AS bedheadboard_28, f0_.bedmatress AS bedmatress_29, f0_.bedmatressp AS bedmatressp_30, f0_.bedDuvet AS bedDuvet_31, f0_.bedValances AS bedValances_32, f0_.bedpillow AS bedpillow_33, f0_.bedpillowSlips AS bedpillowSlips_34, f0_.bedBSTable AS bedBSTable_35, f0_.bedhanger AS bedhanger_36, f0_.bedmirror AS bedmirror_37, f0_.bedwardrobe AS bedwardrobe_38, f0_.bedbin AS bedbin_39, f0_.bednotes AS bednotes_40, f0_.bedpic1 AS bedpic1_41, f0_.bedpic2 AS bedpic2_42, f0_.bedpic3 AS bedpic3_43, f0_.bedpic4 AS bedpic4_44, f0_.bathdecor AS bathdecor_45, f0_.bathfurniture AS bathfurniture_46, f0_.bathflooring AS bathflooring_47, f0_.bathlighting AS bathlighting_48, f0_.bathbrush AS bathbrush_49, f0_.bathmirror AS bathmirror_50, f0_.bathshave AS bathshave_51, f0_.bathmat AS bathmat_52, f0_.bathbin AS bathbin_53, f0_.bathtowelrack AS bathtowelrack_54, f0_.bathnotes AS bathnotes_55, f0_.bathpic1 AS bathpic1_56, f0_.bathpic2 AS bathpic2_57, f0_.bathpic3 AS bathpic3_58, f0_.bathpic4 AS bathpic4_59, f0_.kitdecor AS kitdecor_60, f0_.kitfurniture AS kitfurniture_61, f0_.kitflooring AS kitflooring_62, f0_.kitlighting AS kitlighting_63, f0_.kitgas AS kitgas_64, f0_.kitequipment AS kitequipment_65, f0_.kitutensils AS kitutensils_66, f0_.kiticooker AS kiticooker_67, f0_.kitifreezer AS kitifreezer_68, f0_.kitwashmachine AS kitwashmachine_69, f0_.kitdryer AS kitdryer_70, f0_.kitiron AS kitiron_71, f0_.kitwasher AS kitwasher_72, f0_.kitmicrowave AS kitmicrowave_73, f0_.kitkettle AS kitkettle_74, f0_.kittoaster AS kittoaster_75, f0_.kitsaucepan AS kitsaucepan_76, f0_.kitfrypan AS kitfrypan_77, f0_.kitiutensils AS kitiutensils_78, f0_.ktcookware AS ktcookware_79, f0_.kitcutlery AS kitcutlery_80, f0_.kitcrockery AS kitcrockery_81, f0_.kitGlasses AS kitGlasses_82, f0_.kitSaltAndPepper AS kitSaltAndPepper_83, f0_.kitWUP AS kitWUP_84, f0_.kitClean AS kitClean_85, f0_.kitnotes AS kitnotes_86, f0_.kitpic1 AS kitpic1_87, f0_.kitpci2 AS kitpci2_88, f0_.kitpic3 AS kitpic3_89, f0_.kitpic4 AS kitpic4_90, f0_.pdecor AS pdecor_91, f0_.pfurniture AS pfurniture_92, f0_.pflooring AS pflooring_93, f0_.plighting AS plighting_94, f0_.piflooring AS piflooring_95, f0_.pseating AS pseating_96, f0_.pcurtain AS pcurtain_97, f0_.pcoffeetable AS pcoffeetable_98, f0_.plamp AS plamp_99, f0_.pdintable AS pdintable_100, f0_.ptablemat AS ptablemat_101, f0_.pbin AS pbin_102, f0_.pvaccum AS pvaccum_103, f0_.pnotes AS pnotes_104, f0_.ppic1 AS ppic1_105, f0_.ppic2 AS ppic2_106, f0_.ppic3 AS ppic3_107, f0_.ppic4 AS ppic4_108, f0_.cliving AS cliving_109, f0_.cbed AS cbed_110, f0_.cbath AS cbath_111, f0_.ckit AS ckit_112, f0_.cnotes AS cnotes_113, f0_.cpic1 AS cpic1_114, f0_.cpic2 AS cpic2_115, f0_.cpic3 AS cpic3_116, f0_.cpic4 AS cpic4_117, f0_.minfo AS minfo_118, f0_.mwelcome AS mwelcome_119, f0_.marrival AS marrival_120, f0_.mwifi AS mwifi_121, f0_.maccessories AS maccessories_122, f0_.mspace AS mspace_123, f0_.mfirerisk AS mfirerisk_124, f0_.mfra AS mfra_125, f0_.mboiler AS mboiler_126, f0_.mpat AS mpat_127, f0_.melectrictest AS melectrictest_128, f0_.mlegionela AS mlegionela_129, f0_.minsurrance AS minsurrance_130, f0_.meBlindCord AS meBlindCord_131, f0_.mcot AS mcot_132, f0_.mcotprop AS mcotprop_133, f0_.mhighchair AS mhighchair_134, f0_.mhighchairprop AS mhighchairprop_135, f0_.mstairgate AS mstairgate_136, f0_.mstairgateprop AS mstairgateprop_137, f0_.mnotes AS mnotes_138, f0_.mpic1 AS mpic1_139, f0_.mpic2 AS mpic2_140, f0_.mpic3 AS mpic3_141, f0_.mpic4 AS mpic4_142, f0_.ffeachfloor AS ffeachfloor_143, f0_.ffpressure AS ffpressure_144, f0_.ffvi AS ffvi_145, f0_.ffseal AS ffseal_146, f0_.ffdate AS ffdate_147, f0_.ffcoment AS ffcoment_148, f0_.fbtab AS fbtab_149, f0_.fbvi AS fbvi_150, f0_.fbcoment AS fbcoment_151, f0_.fevi AS fevi_152, f0_.fecoment AS fecoment_153, f0_.fsvi AS fsvi_154, f0_.fscoment AS fscoment_155, f0_.fwtemp AS fwtemp_156, f0_.chimney AS chimney_157, f0_.chimneydate AS chimneydate_158, f0_.fwcoment AS fwcoment_159, f0_.faplace AS faplace_160, f0_.fadesign AS fadesign_161, f0_.favi AS favi_162, f0_.facoment AS facoment_163, f0_.fcloc AS fcloc_164, f0_.fcdesign AS fcdesign_165, f0_.fcvi AS fcvi_166, f0_.fccoment AS fccoment_167, f0_.summary AS summary_168, f0_.miscpic1 AS miscpic1_169, f0_.miscpic2 AS miscpic2_170, f0_.miscpic3 AS miscpic3_171, f0_.miscpic4 AS miscpic4_172, f0_.Exterior_Total AS Exterior_Total_173, f0_.Bedroom_Score AS Bedroom_Score_174, f0_.Bathroom_Score AS Bathroom_Score_175, f0_.Kitchen_Score AS Kitchen_Score_176, f0_.Cleanliness_Score AS Cleanliness_Score_177, f0_.Management_Efficiency_Score AS Management_Efficiency_Score_178, f0_.Public_Area_Score AS Public_Area_Score_179, f0_.Total_Score AS Total_Score_180, f0_.stars AS stars_181, f0_.is_deleted AS is_deleted_182, f0_.ptv AS ptv_183 FROM forms f0_ WHERE f0_.brand = ? AND f0_.is_deleted = 0 AND f0_.ID IN (?) ORDER BY f0_.Date DESC
Parameters: 
[
  "NFC"
  [
    990
    989
    279
    129
    260
    988
    634
    246
    715
    140
    180
    978
    268
    237
    941
    940
    131
    144
    349
    947
    92
    621
    280
    577
    201
  ]
]
View formatted query    View runnable query    Explain query
0.51 ms
(0.78%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token AS token_5 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  49
]
View formatted query    View runnable query    Explain query

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

Class Mapping errors
App\Entity\Forms No errors.
App\Entity\User No errors.
App\Entity\Bedroom No errors.
App\Entity\Bathroom No errors.