SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001407s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011183s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226311 LIMIT 5 [ RunTime:0.003036s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226311 ORDER BY `minOrder` ASC [ RunTime:0.008902s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11226311 ORDER BY `unit` DESC [ RunTime:0.006202s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11226311 LIMIT 2 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226311 ORDER BY `minOrder` ASC [ RunTime:0.007439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349000 LIMIT 5 [ RunTime:0.013198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349000 ORDER BY `minOrder` ASC [ RunTime:0.006175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349000 ORDER BY `unit` DESC [ RunTime:0.001845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349000 LIMIT 2 [ RunTime:0.004181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349000 ORDER BY `minOrder` ASC [ RunTime:0.002445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532855 LIMIT 5 [ RunTime:0.010695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532855 ORDER BY `minOrder` ASC [ RunTime:0.008263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13532855 ORDER BY `unit` DESC [ RunTime:0.005628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13532855 LIMIT 2 [ RunTime:0.010847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532855 ORDER BY `minOrder` ASC [ RunTime:0.004084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602719 LIMIT 5 [ RunTime:0.003611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602719 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19602719 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19602719 LIMIT 2 [ RunTime:0.009058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602719 ORDER BY `minOrder` ASC [ RunTime:0.001650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602718 LIMIT 5 [ RunTime:0.012540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602718 ORDER BY `minOrder` ASC [ RunTime:0.007537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19602718 ORDER BY `unit` DESC [ RunTime:0.001737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19602718 LIMIT 2 [ RunTime:0.004473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602718 ORDER BY `minOrder` ASC [ RunTime:0.004210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687654 LIMIT 5 [ RunTime:0.000222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687654 ORDER BY `minOrder` ASC [ RunTime:0.000192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687654 ORDER BY `unit` DESC [ RunTime:0.000187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687654 LIMIT 2 [ RunTime:0.002472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687654 ORDER BY `minOrder` ASC [ RunTime:0.000182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439147 LIMIT 5 [ RunTime:0.001196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439147 ORDER BY `minOrder` ASC [ RunTime:0.007106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439147 ORDER BY `unit` DESC [ RunTime:0.002141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439147 LIMIT 2 [ RunTime:0.003944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439147 ORDER BY `minOrder` ASC [ RunTime:0.001291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13287951 LIMIT 5 [ RunTime:0.005645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13287951 ORDER BY `minOrder` ASC [ RunTime:0.011108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13287951 ORDER BY `unit` DESC [ RunTime:0.002991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13287951 LIMIT 2 [ RunTime:0.014469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13287951 ORDER BY `minOrder` ASC [ RunTime:0.002591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12022985 LIMIT 5 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12022985 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12022985 ORDER BY `unit` DESC [ RunTime:0.001966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12022985 LIMIT 2 [ RunTime:0.009714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12022985 ORDER BY `minOrder` ASC [ RunTime:0.012091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179782 LIMIT 5 [ RunTime:0.010217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179782 ORDER BY `minOrder` ASC [ RunTime:0.009058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11179782 ORDER BY `unit` DESC [ RunTime:0.005683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11179782 LIMIT 2 [ RunTime:0.008509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179782 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10749814 LIMIT 5 [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749814 ORDER BY `minOrder` ASC [ RunTime:0.007009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10749814 ORDER BY `unit` DESC [ RunTime:0.004931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10749814 LIMIT 2 [ RunTime:0.002056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10749814 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272673 LIMIT 5 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272673 ORDER BY `minOrder` ASC [ RunTime:0.004763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272673 ORDER BY `unit` DESC [ RunTime:0.001266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272673 LIMIT 2 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272673 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='100503l' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.001010s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100503l' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.006631s ]
SELECT `id` FROM `stock` WHERE `id` <> 32272673 AND `partno` = '100503l' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.006164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266152 [ RunTime:0.003872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266152 LIMIT 5 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266152 ORDER BY `minOrder` ASC [ RunTime:0.005118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32266152 ORDER BY `unit` DESC [ RunTime:0.002458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32266152 LIMIT 2 [ RunTime:0.006602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266152 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='100503l' and brandshort='te connectivity / deutsch' limit 1 [ RunTime:0.000305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100503l' OR `brand` LIKE 'te connectivity / deutsch%' ) ) LIMIT 1 [ RunTime:0.000567s ]
SELECT `id` FROM `stock` WHERE `id` <> 32266152 AND `partno` = '100503l' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / deutsch%' ) [ RunTime:0.011843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272673 [ RunTime:0.011016s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61098653 LIMIT 5 [ RunTime:0.002184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61098653 ORDER BY `minOrder` ASC [ RunTime:0.006264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61098653 ORDER BY `unit` DESC [ RunTime:0.002534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61098653 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61098653 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
select * from pdf where partno='100505L' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100505L' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.018985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58141475 LIMIT 5 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58141475 ORDER BY `minOrder` ASC [ RunTime:0.001568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58141475 ORDER BY `unit` DESC [ RunTime:0.004060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58141475 LIMIT 2 [ RunTime:0.006859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58141475 ORDER BY `minOrder` ASC [ RunTime:0.001653s ]
select * from pdf where partno='10050-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.002067s ]
SELECT `id` FROM `stock` WHERE `id` <> 58141475 AND `partno` = '10050-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.004105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226311 [ RunTime:0.006970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559295 LIMIT 5 [ RunTime:0.003946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559295 ORDER BY `minOrder` ASC [ RunTime:0.013174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559295 ORDER BY `unit` DESC [ RunTime:0.020164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559295 LIMIT 2 [ RunTime:0.028949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559295 ORDER BY `minOrder` ASC [ RunTime:0.002087s ]
select * from pdf where partno='10050CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009700s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559295 AND `partno` = '10050CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349000 [ RunTime:0.001791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63114261 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63114261 ORDER BY `minOrder` ASC [ RunTime:0.000972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63114261 ORDER BY `unit` DESC [ RunTime:0.001003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63114261 LIMIT 2 [ RunTime:0.003057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63114261 ORDER BY `minOrder` ASC [ RunTime:0.006947s ]
select * from pdf where partno='1005088' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1005088' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64810616 LIMIT 5 [ RunTime:0.001118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810616 ORDER BY `minOrder` ASC [ RunTime:0.010919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64810616 ORDER BY `unit` DESC [ RunTime:0.001566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64810616 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810616 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
select * from pdf where partno='1005050' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1005050' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63444547 LIMIT 5 [ RunTime:0.005667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63444547 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63444547 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63444547 LIMIT 2 [ RunTime:0.001512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63444547 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='1005000' and brandshort='Rittal' limit 1 [ RunTime:0.000594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1005000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.000354s ]
SELECT `id` FROM `stock` WHERE `id` <> 63444547 AND `partno` = '1005000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380736 LIMIT 5 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380736 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380736 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380736 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380736 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='10050F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.002289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000668s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380736 AND `partno` = '10050F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.002928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380164 LIMIT 5 [ RunTime:0.004624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380164 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380164 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380164 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380164 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='10050' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000350s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380164 AND `partno` = '10050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60575153 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60575153 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60575153 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60575153 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60575153 ORDER BY `minOrder` ASC [ RunTime:0.002944s ]
select * from pdf where partno='10050.4' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050.4' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000296s ]
SELECT `id` FROM `stock` WHERE `id` <> 60575153 AND `partno` = '10050.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602719 [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60575152 LIMIT 5 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60575152 ORDER BY `minOrder` ASC [ RunTime:0.006385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60575152 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60575152 LIMIT 2 [ RunTime:0.009517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60575152 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='10050.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.010117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 60575152 AND `partno` = '10050.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602718 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60340731 LIMIT 5 [ RunTime:0.010696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60340731 ORDER BY `minOrder` ASC [ RunTime:0.008185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60340731 ORDER BY `unit` DESC [ RunTime:0.006683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60340731 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60340731 ORDER BY `minOrder` ASC [ RunTime:0.004425s ]
select * from pdf where partno='100504-233' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100504-233' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005138s ]
SELECT `id` FROM `stock` WHERE `id` <> 60340731 AND `partno` = '100504-233' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60340399 LIMIT 5 [ RunTime:0.014515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60340399 ORDER BY `minOrder` ASC [ RunTime:0.001362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60340399 ORDER BY `unit` DESC [ RunTime:0.002144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60340399 LIMIT 2 [ RunTime:0.002333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60340399 ORDER BY `minOrder` ASC [ RunTime:0.005262s ]
select * from pdf where partno='100503SL' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100503SL' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011214s ]
SELECT `id` FROM `stock` WHERE `id` <> 60340399 AND `partno` = '100503SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59392172 LIMIT 5 [ RunTime:0.006630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59392172 ORDER BY `minOrder` ASC [ RunTime:0.009254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59392172 ORDER BY `unit` DESC [ RunTime:0.004235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59392172 LIMIT 2 [ RunTime:0.004087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59392172 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
select * from pdf where partno='1005004' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1005004' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58508167 LIMIT 5 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58508167 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58508167 ORDER BY `unit` DESC [ RunTime:0.000254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58508167 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58508167 ORDER BY `minOrder` ASC [ RunTime:0.006543s ]
select * from pdf where partno='100500F00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.003048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100500F00000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000347s ]
SELECT `id` FROM `stock` WHERE `id` <> 58508167 AND `partno` = '100500F00000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.000293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687654 [ RunTime:0.000249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58157302 LIMIT 5 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58157302 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58157302 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58157302 LIMIT 2 [ RunTime:0.002346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58157302 ORDER BY `minOrder` ASC [ RunTime:0.004374s ]
select * from pdf where partno='10050-ST' and brandshort='StarTech.com' limit 1 [ RunTime:0.002172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10050-ST' OR `brand` LIKE 'StarTech.com%' ) ) LIMIT 1 [ RunTime:0.004126s ]
SELECT `id` FROM `stock` WHERE `id` <> 58157302 AND `partno` = '10050-ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%startech.com%' ) [ RunTime:0.003217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32711172 LIMIT 5 [ RunTime:0.002229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32711172 ORDER BY `minOrder` ASC [ RunTime:0.008730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32711172 ORDER BY `unit` DESC [ RunTime:0.003372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32711172 LIMIT 2 [ RunTime:0.002867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32711172 ORDER BY `minOrder` ASC [ RunTime:0.006830s ]
select * from pdf where partno='100506-33' and brandshort='Dwyer' limit 1 [ RunTime:0.003744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100506-33' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.017342s ]
SELECT `id` FROM `stock` WHERE `id` <> 32711172 AND `partno` = '100506-33' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.015809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32707798 LIMIT 5 [ RunTime:0.018765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32707798 ORDER BY `minOrder` ASC [ RunTime:0.004928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32707798 ORDER BY `unit` DESC [ RunTime:0.010392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32707798 LIMIT 2 [ RunTime:0.017487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32707798 ORDER BY `minOrder` ASC [ RunTime:0.004988s ]
select * from pdf where partno='100506-32' and brandshort='Dwyer' limit 1 [ RunTime:0.001169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100506-32' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.002191s ]
SELECT `id` FROM `stock` WHERE `id` <> 32707798 AND `partno` = '100506-32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.003989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706535 LIMIT 5 [ RunTime:0.014831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32706535 ORDER BY `minOrder` ASC [ RunTime:0.044990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32706535 ORDER BY `unit` DESC [ RunTime:0.023253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32706535 LIMIT 2 [ RunTime:0.023328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32706535 ORDER BY `minOrder` ASC [ RunTime:0.004700s ]
select * from pdf where partno='100506-35' and brandshort='Dwyer' limit 1 [ RunTime:0.001007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100506-35' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.017817s ]
SELECT `id` FROM `stock` WHERE `id` <> 32706535 AND `partno` = '100506-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.023042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32701241 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32701241 ORDER BY `minOrder` ASC [ RunTime:0.001237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32701241 ORDER BY `unit` DESC [ RunTime:0.044877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32701241 LIMIT 2 [ RunTime:0.031243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32701241 ORDER BY `minOrder` ASC [ RunTime:0.005822s ]
select * from pdf where partno='100506-31' and brandshort='Dwyer' limit 1 [ RunTime:0.005958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100506-31' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.009394s ]
SELECT `id` FROM `stock` WHERE `id` <> 32701241 AND `partno` = '100506-31' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.020808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32699779 LIMIT 5 [ RunTime:0.011494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32699779 ORDER BY `minOrder` ASC [ RunTime:0.018450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32699779 ORDER BY `unit` DESC [ RunTime:0.009969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32699779 LIMIT 2 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32699779 ORDER BY `minOrder` ASC [ RunTime:0.010475s ]
select * from pdf where partno='100506-34' and brandshort='Dwyer' limit 1 [ RunTime:0.001888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100506-34' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.004019s ]
SELECT `id` FROM `stock` WHERE `id` <> 32699779 AND `partno` = '100506-34' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.008600s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016694s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010400s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008019s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004427s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011285s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011285s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004381s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10050%' OR `brand` LIKE '10050%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001370s ]