FMI

Total Time

Count

Avg Time

Query

0.012

1 call
1056 rows

0.012

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...9581, 48193828169663, 431094457434192, 48193828167127, 11852383160108192, 48193828174539, 48193828170987, 48193828169112, 48193828169175, 48193828180667, 48193828114377, 2367772520612339, 2367622196756881, 2367815470284875, 21934286311522621, 48193828167248, 48193828180999, 48193828092607, 2367755340743310, 48193828176737, 48193828176744, 48193828176751, 1073789068640293, 1359348559250531, 32429571475243022, 11654093109985289, 11654157534495182, 11654226253971512, 11654294973448260, 687723048337421, 48193828176599, 687710163435647, 48193828176606, 29210257263689844, 27724585126330911, 27723081887779584, 27723236506599430, 44973762197585921, 25849604268359851, 44974045665427457, 535127155277873, 16715089298063361, 535152925081607, 48193828169077, 16715089298063541, 16715011988653234, 535161515016213, 535152925081638, 535114270375999, 55057185767705, 13980127138414836, 2367686621267365, 11654325038219327, 11654436707368961, 2367755340742739, 156641752252510, 48193828181029, 48193828168677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.011

1 call
1056 rows

0.011

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...8677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828109981, 1257046733226076, 48193828056206, 1176915528385066, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 48193828176366, 48193828180258, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 48193828175541, 335930867056662, 48193828179965, 6575393066713768, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828174274, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 21418026947576481, 48193828169566, 48193828169463, 21418048422412672, 21418014062674292, 21418026947576467, 48193828170960, 21418018357642330, 21418048422412554, 48193828170005, 48193828170578, 21418039832478106)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.009

1 call
997 rows

0.009

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...833, 2018711938532289, 25639885310263699, 48193828031956, 48193828114575, 48193828150198, 48193828150249, 48193828150261, 48193828085199, 48193828030128, 48193828150706, 48193828148359, 48193828169182, 2238249191866945, 48193828150986, 12224310148071565, 7684963507897137, 48193828153216, 48193828031909, 51599737094162, 48193828123819, 30389268736115441, 48193828146093, 21627011466264588, 9147876613554279, 109474421407761, 13354028280841235, 30040221038937604, 905318976454657, 48193828033854, 678394379370591, 34313709203488776, 48193828131395, 979480176754798, 48193828165752, 25006755591225351, 326353089986574, 35205846925312, 25202064934044054, 32389366286385159, 26168411100807461, 41305263126347781, 48193828122683, 48193828154699, 31232349341483315, 28287049748447241, 48193828036661, 47540404588904453, 26116317442474599, 22621545503392792, 499775279464571, 149413322293248, 96546569846812, 535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 581250809069571, 48193828148840, 18111748238213292, 23316179154108434, 48193828159432, 48193828159465, 48193828159577, 48193828031484, 48193828112847, 48193828160240, 48193828161028, 2469296957555049, 30374313659990327, 37306085933056, 48193828138111, 48193828065993, 12329992113356956, 48193828113885, 48193828174888, 48193828180919, 48193828030496, 48193828166948, 48193828058562, 29588102716589010, 48193828105499, 48193828031179, 48193828156908, 48193828167047, 196486163857424, 19599791197520009, 33825354242064388, 24964128040813598, 25809437734208084, 1602800190489369, 32769131589664794, 26047752584561380, 2214287569324644, 48193828167195, 48193828114522, 48193828167304, 32064799902793729, 3326095688467149, 682749476208642, 48193828167352, 20191040690454691, 48193828029109, 34905027415900176, 55057185767613, 48193828147656, 48193828167390, 17037890450096234, 18362179191309061, 48193828135845, 38395268164485132, 1845903929376935, 36542213114560514, 48193828167527, 26388558239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 48193828167645, 34737330417828005, 25877147893629655, 5299800664703052, 48193828150461, 43492651315494917, 48193828142520, 2142054809340137, 19329805258326193, 497945623396397, 48193828167998, 48193828168001, 48193828030451, 48193828168035, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 34673270980626, 55905905664851974, 48193828061517, 52529627578499073, 27359512906170458, 48193828046932, 19898476108186045, 49938254765490177, 37697898619600925, 30510172065497133, 48193828117628, 33491351815323714, 48193828168176, 53586863843180549, 48193828168209, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 1419332072507548, 26420607285461439, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 24515003310670200, 48193828035598, 38534446579712, 51425872523034627, 11631153689657352, 36485747179594, 48193828143774, 11791497703719022, 48193828041120, 26716560596926921, 30601281206747889, 8264552164622941, 48193828168620, 48193828168626, 48193828031364, 29168849483989679, 48193828168721, 26759883932041694, 48193828168743, 113060719099907, 48193828114313, 26173758335090698, 48193828168632, 48193828168635, 28008903371390978, 50773750458613790, 30677486811480090, 32244905061384197, 55485093359124485, 48193828028740, 48193828040756, 48193828167566, 48193828028816, 48193828028813, 42398289353506818, 48193828039007, 48193828089272, 48193828028880, 48193828028888, 48193828028935, 48193828059861, 48193828028939, 48193828028954, 12584322896756763, 44210585163792389, 350705554554900, 37242172524724231, 48193828029106, 48193828029117, 247110943375361, 34916434849038337, 35178217400696841, 31843089396007122, 48193828029217, 26786078937579533, 36644660969472, 48193828033206, 48193828032167, 48193828116662, 363891104153613, 48193828032234)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.009

1 call
1 row

0.009

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.008

1 call
1 row

0.008

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hasShowPassword' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.008

1 call
1 row

0.008

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.007

1 call
700 rows

0.007

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Membership, Company) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`status`=1) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.007

1 call
1 row

0.007

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.007

1 call
1 row

0.007

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.007

1 call
1 row

0.007

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText_bottom' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.006

1 call
1 row

0.006

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.006

1 call
1 row

0.006

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.006

1 call
15 rows

0.006

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Membership, Company) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`alphaSort` LIKE 'D%' AND `Company`.`CompanyId` IN (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 4819382814856...7, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828109981, 1257046733226076, 48193828056206, 1176915528385066, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 48193828176366, 48193828180258, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 48193828175541, 335930867056662, 48193828179965, 6575393066713768, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828174274, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 21418026947576481, 48193828169566, 48193828169463, 21418048422412672, 21418014062674292, 21418026947576467, 48193828170960, 21418018357642330, 21418048422412554, 48193828170005, 48193828170578, 21418039832478106))) AND IFNULL(`Company`.`silent`, 2)!='1') AND `Company`.`MembershipId`=`Membership`.`MembershipId`) AND `Membership`.`status`=1) AND `Membership`.`MembershipTypeId` IN (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 1))) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.004

2 calls
0 rows

0.002

COMMIT

0.003

3 calls
1 row

0.001

SELECT version from databasemap;

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:37:00',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000012, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='6', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:37:00', `sessionId`=0x48921C132BE52923, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'http://www.fmiam.maxx.matrixdev.net/docs/default-source/membership/independent-operator-discussion----2020-v8.pdf?sfvrsn=6d42516e_0\\'}', `clientIPAddr`='216.73.216.129'

0.002

2 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.002

2 calls
0 rows

0.001

START TRANSACTION

0.002

1 call
0 rows

0.002

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 15:37:00',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA59900000012, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='6', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:37:00', `sessionId`=0x48921C132BE52923, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.002203226089477539', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'http://www.fmiam.maxx.matrixdev.net/docs/default-source/membership/independent-operator-discussion----2020-v8.pdf?sfvrsn=6d42516e_0\\'}', `clientIPAddr`='216.73.216.129' WHERE `PageRequestId`=0xCFA59900000012

0.001

1 call
11 rows

0.001

DESCRIBE Ticket

0.001

2 calls
54 rows

0.000

SELECT * FROM StateProvince ORDER BY orderindex, id

0.001

1 call
173 rows

0.001

SELECT * FROM webselect

0.001

1 call
10 rows

0.001

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828105644, 44727501657735172, 21736842369957910, 12773846918627900, 2337149403793103, 13204481814562600, 6723470654177505, 48193828068797, 35756448847757516, 433177516572689, 48968506984628225, 23022287426945035, 33059170731163752, 30478681365282950, 116226109997061)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.001

1 call
10 rows

0.001

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828105644, 44727501657735172, 21736842369957910, 12773846918627900, 2337149403793103, 13204481814562600, 6723470654177505, 48193828068797, 35756448847757516, 433177516572689, 48968506984628225, 23022287426945035, 33059170731163752, 30478681365282950, 116226109997061, 1213457110139030, 48193828085738, 2379510666232342, 48193828089518, 930959931211902, 2240839057145929, 930968521146399, 24194684649734982, 48193828039880, 963739121614854)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:37:00',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000013, `path`='forms/cas/login', `formName`='fmiam_cas', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='7', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:37:00', `sessionId`=0x48921C132BE52923, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'oauth\\':\\'1\\', \\'service\\':\\'/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=http%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fdocs%2fdefault-source%2fmembership%2findependent-operator-discussion----2020-v8.pdf%3fsfvrsn%3d6d42516e%5f0&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.129'

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 15:36:52',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA59900000004, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='5', `growth`='1316', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:36:51', `sessionId`=0x2DCD7710F7C48577, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.04849886894226074', `timeTaken`='2', `dictSize`='0', `fields`='{\\'Company_alphaSort\\':\\'D*\\', \\'action\\':\\'find\\', \\'submit\\':\\'Create PDF\\'}', `clientIPAddr`='217.113.194.13' WHERE `PageRequestId`=0xCFA59900000004

0.000

1 call
0 rows

0.000

INSERT INTO `Ticket` SET `mxxCreated`='2025-09-08 15:37:00',`mxxCreatedBy`=NULL, `TicketId`=0xCFA59900000014, `type`='2', `value`='LT-1757360220-w6yEo1skR8qISESa2FvNJnTTFWCId569', `expires`='2025/09/08 17:07:00.1007 US/Eastern', `username`=NULL, `service`='/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=http%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fdocs%2fdefault-source%2fmembership%2findependent-operator-discussion----2020-v8.pdf%3fsfvrsn%3d6d42516e%5f0&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/', `isPrimary`='2'

0.000

1 call
25 rows

0.000

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company) WHERE `Company`.`CompanyId` IN (48193828105644, 44727501657735172, 21736842369957910, 12773846918627900, 2337149403793103, 13204481814562600, 6723470654177505, 48193828068797, 35756448847757516, 433177516572689, 48968506984628225, 23022287426945035, 33059170731163752, 30478681365282950, 116226109997061, 1213457110139030, 48193828085738, 2379510666232342, 48193828089518, 930959931211902, 2240839057145929, 930968521146399, 24194684649734982, 48193828039880, 963739121614854) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFA59900000007 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFA59900000009 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:10:36',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000002, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:10:36', `sessionId`=0x46F6B80F59068E92, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/2024USGroceryShopperTrends\\'}', `clientIPAddr`='154.54.249.194'

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:11:18',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000003, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:11:18', `sessionId`=0x39CE9A1D42E0502, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/private-brands-management-shopper-centric-approach\\'}', `clientIPAddr`='217.113.194.21'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:10:16',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000001, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:10:16', `sessionId`=0x461AECFE95EE3270, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/u-s-grocery-shopper-trends-2015-executive-summary\\'}', `clientIPAddr`='217.113.194.15'

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 15:09:53',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA59900000000, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='1', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:09:53', `sessionId`=0x2836707EAB605A8B, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.00429987907409668', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/u-s-grocery-shopper-trends-2022-shopping-trends\\'}', `clientIPAddr`='217.113.194.13' WHERE `PageRequestId`=0xCFA59900000000

0.000

1 call
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFA5990000000F AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 15:10:16',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA59900000001, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='2', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:10:16', `sessionId`=0x461AECFE95EE3270, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.00034809112548828125', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/u-s-grocery-shopper-trends-2015-executive-summary\\'}', `clientIPAddr`='217.113.194.15' WHERE `PageRequestId`=0xCFA59900000001

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 15:11:18',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA59900000003, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='4', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:11:18', `sessionId`=0x39CE9A1D42E0502, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.0003502368927001953', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/private-brands-management-shopper-centric-approach\\'}', `clientIPAddr`='217.113.194.21' WHERE `PageRequestId`=0xCFA59900000003

0.000

1 call
4 rows

0.000

SELECT * FROM MinorityType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:09:53',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000000, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:09:53', `sessionId`=0x2836707EAB605A8B, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/u-s-grocery-shopper-trends-2022-shopping-trends\\'}', `clientIPAddr`='217.113.194.13'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 15:36:51',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA59900000004, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='5', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:36:51', `sessionId`=0x2DCD7710F7C48577, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_alphaSort\\':\\'D*\\', \\'action\\':\\'find\\', \\'submit\\':\\'Create PDF\\'}', `clientIPAddr`='217.113.194.13'

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFA5990000000D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 15:10:36',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA59900000002, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='2492460', `requestNum`='3', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1431543', `startTime`='2025-09-08 15:10:36', `sessionId`=0x46F6B80F59068E92, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.0003833770751953125', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/forms/store/ProductFormPublic/2024USGroceryShopperTrends\\'}', `clientIPAddr`='154.54.249.194' WHERE `PageRequestId`=0xCFA59900000002

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFA5990000000C AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFA5990000000A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFA59900000010 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

         1235448 function calls (1225448 primitive calls) in 1.219 seconds

   Ordered by: cumulative time
   List reduced from 1734 to 100 due to restriction <100>

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    1.219    1.219 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest)
        1    0.000    0.000    1.214    1.214 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest)
        1    0.000    0.000    1.180    1.180 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall)
        1    0.000    0.000    1.180    1.180 /data/fmiam/current/generic/sites/www/forms/cas.py:186(login)
        1    0.000    0.000    1.180    1.180 /data/fmiam/current/generic/sites/www/forms/cas.py:81(_presentLoginPage)
        1    0.000    0.000    0.916    0.916 /data/fmiam/current/libs/framework/WebApp.py:277(writeHTMLWithWrap)
        1    0.000    0.000    0.916    0.916 /data/fmiam/current/libs/framework/WebApp.py:213(wrapHTML)
        1    0.000    0.000    0.791    0.791 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.000    0.000    0.788    0.788 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:268(scrape)
       12    0.000    0.000    0.325    0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__)
       12    0.000    0.000    0.325    0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed)
       12    0.000    0.000    0.325    0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed)
       12    0.000    0.000    0.322    0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse)
       12    0.000    0.000    0.322    0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse)
       12    0.012    0.001    0.321    0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
        1    0.000    0.000    0.279    0.279 /usr/lib/python3.11/urllib/request.py:139(urlopen)
        1    0.000    0.000    0.277    0.277 /usr/lib/python3.11/urllib/request.py:500(open)
        1    0.000    0.000    0.277    0.277 /usr/lib/python3.11/urllib/request.py:529(_open)
        2    0.000    0.000    0.277    0.138 /usr/lib/python3.11/urllib/request.py:489(_call_chain)
        1    0.000    0.000    0.277    0.277 /usr/lib/python3.11/urllib/request.py:1390(https_open)
        1    0.000    0.000    0.277    0.277 /usr/lib/python3.11/urllib/request.py:1307(do_open)
        1    0.000    0.000    0.275    0.275 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts)
        2    0.000    0.000    0.236    0.118 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup)
        1    0.000    0.000    0.206    0.206 /usr/lib/python3.11/http/client.py:1351(getresponse)
        1    0.000    0.000    0.206    0.206 /usr/lib/python3.11/http/client.py:318(begin)
        6    0.000    0.000    0.206    0.034 /usr/lib/python3.11/socket.py:704(readinto)
        6    0.000    0.000    0.206    0.034 /usr/lib/python3.11/ssl.py:1299(recv_into)
        6    0.000    0.000    0.206    0.034 /usr/lib/python3.11/ssl.py:1157(read)
        6    0.206    0.034    0.206    0.034 {method 'read' of '_ssl._SSLSocket' objects}
       14    0.000    0.000    0.206    0.015 {method 'readline' of '_io.BufferedReader' objects}
        1    0.000    0.000    0.206    0.206 /usr/lib/python3.11/http/client.py:285(_read_status)
35070/34756    0.020    0.000    0.169    0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter)
       10    0.000    0.000    0.165    0.017 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:374(getElm)
       10    0.000    0.000    0.165    0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select)
       10    0.000    0.000    0.165    0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select)
       10    0.000    0.000    0.162    0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select)
       17    0.000    0.000    0.162    0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect)
       17    0.003    0.000    0.162    0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
35097/34756    0.017    0.000    0.142    0.000 {built-in method builtins.__import__}
        1    0.000    0.000    0.139    0.139 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript)
        1    0.000    0.000    0.136    0.136 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS)
     7313    0.022    0.000    0.130    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
        9    0.000    0.000    0.126    0.014 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML)
     71/8    0.000    0.000    0.125    0.016 :1165(_find_and_load)
        1    0.000    0.000    0.125    0.125 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:714(process)
     71/8    0.000    0.000    0.125    0.016 :1120(_find_and_load_unlocked)
   168/12    0.000    0.000    0.122    0.010 :233(_call_with_frames_removed)
     70/7    0.000    0.000    0.122    0.017 :666(_load_unlocked)
     70/8    0.000    0.000    0.122    0.015 :934(exec_module)
     70/8    0.000    0.000    0.120    0.015 {built-in method builtins.exec}
     6294    0.007    0.000    0.113    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match)
1981/1927    0.002    0.000    0.094    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)
        1    0.000    0.000    0.084    0.084 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
     6294    0.009    0.000    0.084    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors)
        4    0.000    0.000    0.073    0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode)
   2548/4    0.017    0.000    0.073    0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode)
   2548/4    0.011    0.000    0.073    0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents)
       19    0.000    0.000    0.071    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       19    0.000    0.000    0.071    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
       19    0.000    0.000    0.071    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       19    0.070    0.004    0.070    0.004 {function Connection.query at 0xe6664b8928e0}
        1    0.000    0.000    0.070    0.070 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1()
        1    0.000    0.000    0.069    0.069 /data/fmiam/current/generic/classes/Ticket.py:42(create)
     6294    0.005    0.000    0.069    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag)
        1    0.000    0.000    0.069    0.069 /data/fmiam/current/libs/PLayer/PersistentObject.py:955(save)
     1899    0.004    0.000    0.068    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal)
        8    0.000    0.000    0.063    0.008 /data/fmiam/current/generic/classes/ClientSetting.py:97(getClientSettingValue)
     3500    0.004    0.000    0.062    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText)
       17    0.000    0.000    0.062    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all)
       17    0.009    0.001    0.062    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all)
       55    0.001    0.000    0.062    0.001 /usr/lib/python3.11/re/__init__.py:272(_compile)
       53    0.000    0.000    0.062    0.001 /usr/lib/python3.11/re/__init__.py:225(compile)
       31    0.000    0.000    0.061    0.002 /usr/lib/python3.11/re/_compiler.py:740(compile)
        1    0.000    0.000    0.061    0.061 /usr/lib/python3.11/http/client.py:1426(__init__)
        1    0.000    0.000    0.060    0.060 /usr/lib/python3.11/ssl.py:745(create_default_context)
        8    0.000    0.000    0.060    0.007 /data/fmiam/current/generic/classes/ClientSetting.py:33(getClientSetting)
        8    0.000    0.000    0.059    0.007 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria)
        1    0.000    0.000    0.059    0.059 /usr/lib/python3.11/ssl.py:591(load_default_certs)
        1    0.059    0.059    0.059    0.059 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects}
       11    0.000    0.000    0.059    0.005 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList)
     3500    0.005    0.000    0.058    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText)
        7    0.000    0.000    0.055    0.008 /data/fmiam/current/libs/framework/BaseHandler.py:831(getClientSetting)
        1    0.051    0.051    0.051    0.051 {built-in method gc.collect}
     2674    0.002    0.000    0.050    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre)
     5456    0.016    0.000    0.050    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild)
  287/253    0.000    0.000    0.049    0.000 :1207(_handle_fromlist)
        2    0.000    0.000    0.048    0.024 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__)
     6304    0.009    0.000    0.046    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants)
        6    0.000    0.000    0.045    0.008 /data/fmiam/current/libs/framework/WebApp.py:724(getClientSetting)
    15888    0.015    0.000    0.045    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search)
     6294    0.006    0.000    0.045    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname)
    23870    0.015    0.000    0.042    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag)
        1    0.000    0.000    0.035    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1()
        1    0.000    0.000    0.034    0.034 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:27(_manipulateLogin)
    12806    0.024    0.000    0.034    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower)
       31    0.000    0.000    0.033    0.001 /usr/lib/python3.11/re/_parser.py:979(parse)
209672/209354    0.030    0.000    0.033    0.000 {built-in method builtins.isinstance}
        1    0.000    0.000    0.032    0.032 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:650(prepMetaTags)
    90/31    0.001    0.000    0.032    0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub)
        1    0.000    0.000    0.032    0.032 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:161(fixRelativeStubLinks)

Sign In

Create New Account

Mega Menu

Sign Up for the

Sign In

Log In with Password

Create New Account

Mega Menu

Sign Up for the