SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003022s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069491s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316180 LIMIT 5 [ RunTime:0.024836s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316180 ORDER BY `minOrder` ASC [ RunTime:0.039262s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316180 ORDER BY `unit` DESC [ RunTime:0.033478s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316180 LIMIT 2 [ RunTime:0.011207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316180 ORDER BY `minOrder` ASC [ RunTime:0.009120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316203 LIMIT 5 [ RunTime:0.031778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316203 ORDER BY `minOrder` ASC [ RunTime:0.036812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316203 ORDER BY `unit` DESC [ RunTime:0.023381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316203 LIMIT 2 [ RunTime:0.040019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316203 ORDER BY `minOrder` ASC [ RunTime:0.020715s ]
select * from pdf where partno='1220T-25-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.067393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351605 LIMIT 5 [ RunTime:0.033181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351605 ORDER BY `minOrder` ASC [ RunTime:0.040952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351605 ORDER BY `unit` DESC [ RunTime:0.024410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351605 LIMIT 2 [ RunTime:0.094570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351605 ORDER BY `minOrder` ASC [ RunTime:0.031417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17762906 LIMIT 5 [ RunTime:0.036844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17762906 ORDER BY `minOrder` ASC [ RunTime:0.029877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17762906 ORDER BY `unit` DESC [ RunTime:0.045415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17762906 LIMIT 2 [ RunTime:0.037224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17762906 ORDER BY `minOrder` ASC [ RunTime:0.011107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796184 LIMIT 5 [ RunTime:0.012445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796184 ORDER BY `minOrder` ASC [ RunTime:0.013184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14796184 ORDER BY `unit` DESC [ RunTime:0.012920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14796184 LIMIT 2 [ RunTime:0.010379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796184 ORDER BY `minOrder` ASC [ RunTime:0.016649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351132 LIMIT 5 [ RunTime:0.013300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351132 ORDER BY `minOrder` ASC [ RunTime:0.013181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351132 ORDER BY `unit` DESC [ RunTime:0.008531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351132 LIMIT 2 [ RunTime:0.008188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351132 ORDER BY `minOrder` ASC [ RunTime:0.014297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348085 LIMIT 5 [ RunTime:0.012088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348085 ORDER BY `minOrder` ASC [ RunTime:0.009888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348085 ORDER BY `unit` DESC [ RunTime:0.010654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348085 LIMIT 2 [ RunTime:0.012081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348085 ORDER BY `minOrder` ASC [ RunTime:0.009028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041434 LIMIT 5 [ RunTime:0.009757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041434 ORDER BY `minOrder` ASC [ RunTime:0.005755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041434 ORDER BY `unit` DESC [ RunTime:0.007498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041434 LIMIT 2 [ RunTime:0.013292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041434 ORDER BY `minOrder` ASC [ RunTime:0.004545s ]
select * from pdf where partno='1220-25-PH' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.006181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348654 LIMIT 5 [ RunTime:0.006038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348654 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348654 ORDER BY `unit` DESC [ RunTime:0.002919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348654 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348654 ORDER BY `minOrder` ASC [ RunTime:0.005896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517272 LIMIT 5 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517272 ORDER BY `minOrder` ASC [ RunTime:0.001256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517272 ORDER BY `unit` DESC [ RunTime:0.006000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517272 LIMIT 2 [ RunTime:0.003512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517272 ORDER BY `minOrder` ASC [ RunTime:0.001955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351928 LIMIT 5 [ RunTime:0.003535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351928 ORDER BY `minOrder` ASC [ RunTime:0.003200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351928 ORDER BY `unit` DESC [ RunTime:0.001546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351928 LIMIT 2 [ RunTime:0.005300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351928 ORDER BY `minOrder` ASC [ RunTime:0.016137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352052 LIMIT 5 [ RunTime:0.033020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352052 ORDER BY `minOrder` ASC [ RunTime:0.013020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352052 ORDER BY `unit` DESC [ RunTime:0.010296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352052 LIMIT 2 [ RunTime:0.038208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352052 ORDER BY `minOrder` ASC [ RunTime:0.008834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315060 LIMIT 5 [ RunTime:0.068489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315060 ORDER BY `minOrder` ASC [ RunTime:0.044768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315060 ORDER BY `unit` DESC [ RunTime:0.007736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315060 LIMIT 2 [ RunTime:0.021342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315060 ORDER BY `minOrder` ASC [ RunTime:0.023190s ]
select * from pdf where partno='1220-25-S-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.008043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267913 LIMIT 5 [ RunTime:0.023744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267913 ORDER BY `minOrder` ASC [ RunTime:0.024556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267913 ORDER BY `unit` DESC [ RunTime:0.035158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267913 LIMIT 2 [ RunTime:0.019966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267913 ORDER BY `minOrder` ASC [ RunTime:0.005822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315836 LIMIT 5 [ RunTime:0.025895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315836 ORDER BY `minOrder` ASC [ RunTime:0.048023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315836 ORDER BY `unit` DESC [ RunTime:0.046265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315836 LIMIT 2 [ RunTime:0.033396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315836 ORDER BY `minOrder` ASC [ RunTime:0.014284s ]
select * from pdf where partno='1220-25-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.042663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195274 LIMIT 5 [ RunTime:0.029349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195274 ORDER BY `minOrder` ASC [ RunTime:0.036008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195274 ORDER BY `unit` DESC [ RunTime:0.045980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195274 LIMIT 2 [ RunTime:0.051471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195274 ORDER BY `minOrder` ASC [ RunTime:0.040032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17152023 LIMIT 5 [ RunTime:0.010003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17152023 ORDER BY `minOrder` ASC [ RunTime:0.029324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17152023 ORDER BY `unit` DESC [ RunTime:0.013506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17152023 LIMIT 2 [ RunTime:0.023043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17152023 ORDER BY `minOrder` ASC [ RunTime:0.008243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19280517 LIMIT 5 [ RunTime:0.007840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19280517 ORDER BY `minOrder` ASC [ RunTime:0.018920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19280517 ORDER BY `unit` DESC [ RunTime:0.020914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19280517 LIMIT 2 [ RunTime:0.031018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19280517 ORDER BY `minOrder` ASC [ RunTime:0.010739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19280366 LIMIT 5 [ RunTime:0.014862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19280366 ORDER BY `minOrder` ASC [ RunTime:0.023669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19280366 ORDER BY `unit` DESC [ RunTime:0.024346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19280366 LIMIT 2 [ RunTime:0.021293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19280366 ORDER BY `minOrder` ASC [ RunTime:0.012038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15372288 LIMIT 5 [ RunTime:0.037360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15372288 ORDER BY `minOrder` ASC [ RunTime:0.015491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15372288 ORDER BY `unit` DESC [ RunTime:0.030761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15372288 LIMIT 2 [ RunTime:0.005923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15372288 ORDER BY `minOrder` ASC [ RunTime:0.005397s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096601 LIMIT 5 [ RunTime:0.074577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096601 ORDER BY `minOrder` ASC [ RunTime:0.020142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096601 ORDER BY `unit` DESC [ RunTime:0.023958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096601 LIMIT 2 [ RunTime:0.015268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096601 ORDER BY `minOrder` ASC [ RunTime:0.011229s ]
select * from pdf where partno='1220' and brandshort='adafruit' limit 1 [ RunTime:0.020733s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.026142s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63392702 LIMIT 5 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392702 ORDER BY `minOrder` ASC [ RunTime:0.028432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63392702 ORDER BY `unit` DESC [ RunTime:0.028065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63392702 LIMIT 2 [ RunTime:0.025689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392702 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
select * from pdf where partno='1220-25-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.002005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-25-N' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.016035s ]
SELECT `id` FROM `stock` WHERE `id` <> 63392702 AND `partno` = '1220-25-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.001381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316180 [ RunTime:0.006840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63392816 LIMIT 5 [ RunTime:0.009723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392816 ORDER BY `minOrder` ASC [ RunTime:0.012648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63392816 ORDER BY `unit` DESC [ RunTime:0.001464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63392816 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392816 ORDER BY `minOrder` ASC [ RunTime:0.001364s ]
select * from pdf where partno='1220T-25-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220T-25-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.001024s ]
SELECT `id` FROM `stock` WHERE `id` <> 63392816 AND `partno` = '1220T-25-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.012549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316203 [ RunTime:0.024299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64557947 LIMIT 5 [ RunTime:0.009167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64557947 ORDER BY `minOrder` ASC [ RunTime:0.029209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64557947 ORDER BY `unit` DESC [ RunTime:0.003974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64557947 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64557947 ORDER BY `minOrder` ASC [ RunTime:0.003336s ]
select * from pdf where partno='12200CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12200CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013601s ]
SELECT `id` FROM `stock` WHERE `id` <> 64557947 AND `partno` = '12200CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.041739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348085 [ RunTime:0.002198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541325 LIMIT 5 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541325 ORDER BY `minOrder` ASC [ RunTime:0.011749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541325 ORDER BY `unit` DESC [ RunTime:0.016548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541325 LIMIT 2 [ RunTime:0.002253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541325 ORDER BY `minOrder` ASC [ RunTime:0.002054s ]
select * from pdf where partno='1220-10-I1-480M1' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-10-I1-480M1' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.013524s ]
SELECT `id` FROM `stock` WHERE `id` <> 64541325 AND `partno` = '1220-10-I1-480M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.010325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658240 [ RunTime:0.012514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541322 LIMIT 5 [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541322 ORDER BY `minOrder` ASC [ RunTime:0.002457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541322 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541322 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541322 ORDER BY `minOrder` ASC [ RunTime:0.008033s ]
select * from pdf where partno='1220-10-I2-120M1' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-10-I2-120M1' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003472s ]
SELECT `id` FROM `stock` WHERE `id` <> 64541322 AND `partno` = '1220-10-I2-120M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.010525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660094 [ RunTime:0.019170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541324 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541324 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541324 ORDER BY `unit` DESC [ RunTime:0.002898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541324 LIMIT 2 [ RunTime:0.002483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541324 ORDER BY `minOrder` ASC [ RunTime:0.001959s ]
select * from pdf where partno='1220-10-I2-400M1' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-10-I2-400M1' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004352s ]
SELECT `id` FROM `stock` WHERE `id` <> 64541324 AND `partno` = '1220-10-I2-400M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13903468 [ RunTime:0.008294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541323 LIMIT 5 [ RunTime:0.006183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541323 ORDER BY `minOrder` ASC [ RunTime:0.005005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541323 ORDER BY `unit` DESC [ RunTime:0.019711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541323 LIMIT 2 [ RunTime:0.020056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541323 ORDER BY `minOrder` ASC [ RunTime:0.008704s ]
select * from pdf where partno='1220-10-I2-277M1' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.009874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-10-I2-277M1' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004047s ]
SELECT `id` FROM `stock` WHERE `id` <> 64541323 AND `partno` = '1220-10-I2-277M1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.030442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660095 [ RunTime:0.025479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558816 LIMIT 5 [ RunTime:0.027426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558816 ORDER BY `minOrder` ASC [ RunTime:0.018739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558816 ORDER BY `unit` DESC [ RunTime:0.021531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558816 LIMIT 2 [ RunTime:0.014126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558816 ORDER BY `minOrder` ASC [ RunTime:0.001974s ]
select * from pdf where partno='12206CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12206CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008694s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558816 AND `partno` = '12206CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.016973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348654 [ RunTime:0.006548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63392964 LIMIT 5 [ RunTime:0.006992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392964 ORDER BY `minOrder` ASC [ RunTime:0.005269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63392964 ORDER BY `unit` DESC [ RunTime:0.003797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63392964 LIMIT 2 [ RunTime:0.005166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392964 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='1220-25-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-25-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.024098s ]
SELECT `id` FROM `stock` WHERE `id` <> 63392964 AND `partno` = '1220-25-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.007536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409638 LIMIT 5 [ RunTime:0.006654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409638 ORDER BY `minOrder` ASC [ RunTime:0.003379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409638 ORDER BY `unit` DESC [ RunTime:0.006333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409638 LIMIT 2 [ RunTime:0.003290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409638 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='122010400' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.001268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '122010400' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.008245s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409638 AND `partno` = '122010400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.017797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563185 LIMIT 5 [ RunTime:0.002918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563185 ORDER BY `minOrder` ASC [ RunTime:0.019418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563185 ORDER BY `unit` DESC [ RunTime:0.003733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563185 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563185 ORDER BY `minOrder` ASC [ RunTime:0.003201s ]
select * from pdf where partno='12204CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12204CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003486s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563185 AND `partno` = '12204CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351605 [ RunTime:0.019381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58070953 LIMIT 5 [ RunTime:0.043646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58070953 ORDER BY `minOrder` ASC [ RunTime:0.017281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58070953 ORDER BY `unit` DESC [ RunTime:0.021632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58070953 LIMIT 2 [ RunTime:0.038902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58070953 ORDER BY `minOrder` ASC [ RunTime:0.008251s ]
select * from pdf where partno='1220A' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220A' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024971s ]
SELECT `id` FROM `stock` WHERE `id` <> 58070953 AND `partno` = '1220A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.035644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17762906 [ RunTime:0.035166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563613 LIMIT 5 [ RunTime:0.035947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563613 ORDER BY `minOrder` ASC [ RunTime:0.027240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563613 ORDER BY `unit` DESC [ RunTime:0.047533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563613 LIMIT 2 [ RunTime:0.009518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563613 ORDER BY `minOrder` ASC [ RunTime:0.014669s ]
select * from pdf where partno='12202CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.056620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12202CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.026167s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563613 AND `partno` = '12202CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.034571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351928 [ RunTime:0.011213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409802 LIMIT 5 [ RunTime:0.014038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409802 ORDER BY `minOrder` ASC [ RunTime:0.035295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409802 ORDER BY `unit` DESC [ RunTime:0.014638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409802 LIMIT 2 [ RunTime:0.026539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409802 ORDER BY `minOrder` ASC [ RunTime:0.006649s ]
select * from pdf where partno='122010150' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.019866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '122010150' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.008574s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409802 AND `partno` = '122010150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.001043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541308 LIMIT 5 [ RunTime:0.007802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541308 ORDER BY `minOrder` ASC [ RunTime:0.018214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541308 ORDER BY `unit` DESC [ RunTime:0.013491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541308 LIMIT 2 [ RunTime:0.029844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541308 ORDER BY `minOrder` ASC [ RunTime:0.006941s ]
select * from pdf where partno='1220-20-I4-480M2' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.008821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-20-I4-480M2' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.017473s ]
SELECT `id` FROM `stock` WHERE `id` <> 64541308 AND `partno` = '1220-20-I4-480M2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.014224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796578 [ RunTime:0.031158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409816 LIMIT 5 [ RunTime:0.006743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409816 ORDER BY `minOrder` ASC [ RunTime:0.014052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409816 ORDER BY `unit` DESC [ RunTime:0.008343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409816 LIMIT 2 [ RunTime:0.018655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409816 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
select * from pdf where partno='122010250' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.012694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '122010250' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.008850s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409816 AND `partno` = '122010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.006961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64541309 LIMIT 5 [ RunTime:0.009396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541309 ORDER BY `minOrder` ASC [ RunTime:0.011020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64541309 ORDER BY `unit` DESC [ RunTime:0.006249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64541309 LIMIT 2 [ RunTime:0.021494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64541309 ORDER BY `minOrder` ASC [ RunTime:0.008662s ]
select * from pdf where partno='1220-20-I4-480M3' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-20-I4-480M3' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.016390s ]
SELECT `id` FROM `stock` WHERE `id` <> 64541309 AND `partno` = '1220-20-I4-480M3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.016449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658243 [ RunTime:0.021294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60641320 LIMIT 5 [ RunTime:0.004219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641320 ORDER BY `minOrder` ASC [ RunTime:0.023359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60641320 ORDER BY `unit` DESC [ RunTime:0.019316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60641320 LIMIT 2 [ RunTime:0.007612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60641320 ORDER BY `minOrder` ASC [ RunTime:0.012861s ]
select * from pdf where partno='1220' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.026319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.018660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63393471 LIMIT 5 [ RunTime:0.019750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393471 ORDER BY `minOrder` ASC [ RunTime:0.010356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63393471 ORDER BY `unit` DESC [ RunTime:0.020627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63393471 LIMIT 2 [ RunTime:0.012454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393471 ORDER BY `minOrder` ASC [ RunTime:0.010352s ]
select * from pdf where partno='1220-25-PH' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.002701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-25-PH' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.007425s ]
SELECT `id` FROM `stock` WHERE `id` <> 63393471 AND `partno` = '1220-25-PH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.015648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041434 [ RunTime:0.012122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395974 LIMIT 5 [ RunTime:0.008837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395974 ORDER BY `minOrder` ASC [ RunTime:0.032457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395974 ORDER BY `unit` DESC [ RunTime:0.013689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395974 LIMIT 2 [ RunTime:0.012210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395974 ORDER BY `minOrder` ASC [ RunTime:0.011360s ]
select * from pdf where partno='1220-10-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.014581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220-10-N' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.014524s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395974 AND `partno` = '1220-10-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.023230s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018676s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018886s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024932s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018489s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019054s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031719s ]
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 '1220%' OR `brand` LIKE '1220%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044384s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1220%' OR `brand` LIKE '1220%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037049s ]