SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002581s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.329827s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.027908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489614 LIMIT 5 [ RunTime:0.069464s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489614 ORDER BY `minOrder` ASC [ RunTime:0.051075s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.036109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489614 ORDER BY `unit` DESC [ RunTime:0.059772s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489614 LIMIT 2 [ RunTime:0.051285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489614 ORDER BY `minOrder` ASC [ RunTime:0.010765s ]
select * from pdf where partno='3051 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.025291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321813 LIMIT 5 [ RunTime:0.091094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321813 ORDER BY `minOrder` ASC [ RunTime:0.041568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321813 ORDER BY `unit` DESC [ RunTime:0.016800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321813 LIMIT 2 [ RunTime:0.080568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321813 ORDER BY `minOrder` ASC [ RunTime:0.006616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321419 LIMIT 5 [ RunTime:0.048109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321419 ORDER BY `minOrder` ASC [ RunTime:0.027412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321419 ORDER BY `unit` DESC [ RunTime:0.038607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321419 LIMIT 2 [ RunTime:0.054479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321419 ORDER BY `minOrder` ASC [ RunTime:0.018094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321415 LIMIT 5 [ RunTime:0.029453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321415 ORDER BY `minOrder` ASC [ RunTime:0.039234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321415 ORDER BY `unit` DESC [ RunTime:0.101011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321415 LIMIT 2 [ RunTime:0.057091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321415 ORDER BY `minOrder` ASC [ RunTime:0.041927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13324411 LIMIT 5 [ RunTime:0.040744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13324411 ORDER BY `minOrder` ASC [ RunTime:0.014960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13324411 ORDER BY `unit` DESC [ RunTime:0.023235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13324411 LIMIT 2 [ RunTime:0.024990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13324411 ORDER BY `minOrder` ASC [ RunTime:0.004396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045256 LIMIT 5 [ RunTime:0.023946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045256 ORDER BY `minOrder` ASC [ RunTime:0.048012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12045256 ORDER BY `unit` DESC [ RunTime:0.008683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12045256 LIMIT 2 [ RunTime:0.021953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045256 ORDER BY `minOrder` ASC [ RunTime:0.002037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14865876 LIMIT 5 [ RunTime:0.026907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14865876 ORDER BY `minOrder` ASC [ RunTime:0.030262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14865876 ORDER BY `unit` DESC [ RunTime:0.023164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14865876 LIMIT 2 [ RunTime:0.029568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14865876 ORDER BY `minOrder` ASC [ RunTime:0.015849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388678 LIMIT 5 [ RunTime:0.001364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388678 ORDER BY `minOrder` ASC [ RunTime:0.013545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388678 ORDER BY `unit` DESC [ RunTime:0.000738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388678 LIMIT 2 [ RunTime:0.009293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388678 ORDER BY `minOrder` ASC [ RunTime:0.011501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321811 LIMIT 5 [ RunTime:0.016978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321811 ORDER BY `minOrder` ASC [ RunTime:0.024522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321811 ORDER BY `unit` DESC [ RunTime:0.006290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321811 LIMIT 2 [ RunTime:0.013424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321811 ORDER BY `minOrder` ASC [ RunTime:0.004830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13341547 LIMIT 5 [ RunTime:0.004377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13341547 ORDER BY `minOrder` ASC [ RunTime:0.018611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13341547 ORDER BY `unit` DESC [ RunTime:0.032421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13341547 LIMIT 2 [ RunTime:0.019852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13341547 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16408229 LIMIT 5 [ RunTime:0.022085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16408229 ORDER BY `minOrder` ASC [ RunTime:0.021447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16408229 ORDER BY `unit` DESC [ RunTime:0.002302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16408229 LIMIT 2 [ RunTime:0.001578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16408229 ORDER BY `minOrder` ASC [ RunTime:0.017130s ]
select * from pdf where partno='3055/1 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401164 LIMIT 5 [ RunTime:0.018393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401164 ORDER BY `minOrder` ASC [ RunTime:0.013800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401164 ORDER BY `unit` DESC [ RunTime:0.016290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401164 LIMIT 2 [ RunTime:0.002323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401164 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
select * from pdf where partno='3050 YL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489879 LIMIT 5 [ RunTime:0.005025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489879 ORDER BY `minOrder` ASC [ RunTime:0.006223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489879 ORDER BY `unit` DESC [ RunTime:0.004980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489879 LIMIT 2 [ RunTime:0.003868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489879 ORDER BY `minOrder` ASC [ RunTime:0.004420s ]
select * from pdf where partno='3050 BR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489878 LIMIT 5 [ RunTime:0.010659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489878 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489878 ORDER BY `unit` DESC [ RunTime:0.015325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489878 LIMIT 2 [ RunTime:0.002003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489878 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='3050 BL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041134 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041134 ORDER BY `minOrder` ASC [ RunTime:0.011306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041134 ORDER BY `unit` DESC [ RunTime:0.005235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041134 LIMIT 2 [ RunTime:0.009243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041134 ORDER BY `minOrder` ASC [ RunTime:0.016062s ]
select * from pdf where partno='3051-B-440-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.024063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16404976 LIMIT 5 [ RunTime:0.023756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16404976 ORDER BY `minOrder` ASC [ RunTime:0.005605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16404976 ORDER BY `unit` DESC [ RunTime:0.004503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16404976 LIMIT 2 [ RunTime:0.024770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16404976 ORDER BY `minOrder` ASC [ RunTime:0.005544s ]
select * from pdf where partno='3051 SL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321812 LIMIT 5 [ RunTime:0.008482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321812 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13321812 ORDER BY `unit` DESC [ RunTime:0.003788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13321812 LIMIT 2 [ RunTime:0.006958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13321812 ORDER BY `minOrder` ASC [ RunTime:0.006127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489615 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489615 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489615 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489615 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489615 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
select * from pdf where partno='3053 BR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493116 LIMIT 5 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13493116 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13493116 ORDER BY `unit` DESC [ RunTime:0.002030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13493116 LIMIT 2 [ RunTime:0.003490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13493116 ORDER BY `minOrder` ASC [ RunTime:0.004706s ]
select * from pdf where partno='3057 OR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15541812 LIMIT 5 [ RunTime:0.003606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15541812 ORDER BY `minOrder` ASC [ RunTime:0.001694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15541812 ORDER BY `unit` DESC [ RunTime:0.014437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15541812 LIMIT 2 [ RunTime:0.010933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15541812 ORDER BY `minOrder` ASC [ RunTime:0.007593s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51117377 LIMIT 5 [ RunTime:0.011759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51117377 ORDER BY `minOrder` ASC [ RunTime:0.007335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51117377 ORDER BY `unit` DESC [ RunTime:0.009046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51117377 LIMIT 2 [ RunTime:0.014366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51117377 ORDER BY `minOrder` ASC [ RunTime:0.014552s ]
select * from pdf where partno='3057p-1-103m' and brandshort='bourns' limit 1 [ RunTime:0.017772s ]
select foldpath,foldpath2,filename from pdf_file where id=1488613 limit 1 [ RunTime:0.008598s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057p-1-103m' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116678 LIMIT 5 [ RunTime:0.001088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116678 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116678 ORDER BY `unit` DESC [ RunTime:0.008649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116678 LIMIT 2 [ RunTime:0.007376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116678 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='3059y-1-503' and brandshort='bourns' limit 1 [ RunTime:0.011037s ]
select foldpath,foldpath2,filename from pdf_file where id=1580675 limit 1 [ RunTime:0.015826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3059y-1-503' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.011306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275288 LIMIT 5 [ RunTime:0.005309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275288 ORDER BY `minOrder` ASC [ RunTime:0.015002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275288 ORDER BY `unit` DESC [ RunTime:0.009531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275288 LIMIT 2 [ RunTime:0.017231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275288 ORDER BY `minOrder` ASC [ RunTime:0.002785s ]
select * from pdf where partno='3059731' and brandshort='phoenix contact' limit 1 [ RunTime:0.008752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3059731' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.012660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212885 LIMIT 5 [ RunTime:0.013340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212885 ORDER BY `minOrder` ASC [ RunTime:0.012911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212885 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212885 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212885 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='3050-b' and brandshort='davies molding' limit 1 [ RunTime:0.012319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050-b' OR `brand` LIKE 'davies molding%' ) ) LIMIT 1 [ RunTime:0.007831s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212885 AND `partno` = '3050-b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding%' ) [ RunTime:0.012566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13340778 [ RunTime:0.010000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51115906 LIMIT 5 [ RunTime:0.034456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115906 ORDER BY `minOrder` ASC [ RunTime:0.029258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51115906 ORDER BY `unit` DESC [ RunTime:0.007360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51115906 LIMIT 2 [ RunTime:0.023564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115906 ORDER BY `minOrder` ASC [ RunTime:0.006510s ]
select * from pdf where partno='3059y-1-500lf' and brandshort='bourns' limit 1 [ RunTime:0.026069s ]
select foldpath,foldpath2,filename from pdf_file where id=1508346 limit 1 [ RunTime:0.001753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3059y-1-500lf' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.014443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113809 LIMIT 5 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113809 ORDER BY `minOrder` ASC [ RunTime:0.005441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113809 ORDER BY `unit` DESC [ RunTime:0.003440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113809 LIMIT 2 [ RunTime:0.008257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113809 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='30504' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30504' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.010689s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113809 AND `partno` = '30504' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.007035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263117 [ RunTime:0.001893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138971 LIMIT 5 [ RunTime:0.028347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138971 ORDER BY `minOrder` ASC [ RunTime:0.020175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138971 ORDER BY `unit` DESC [ RunTime:0.024451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138971 LIMIT 2 [ RunTime:0.010030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138971 ORDER BY `minOrder` ASC [ RunTime:0.030918s ]
select * from pdf where partno='3050 bk005' and brandshort='alpha wire' limit 1 [ RunTime:0.029697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 bk005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.029042s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138971 AND `partno` = '3050 bk005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.045492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368557 [ RunTime:0.055950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291754 LIMIT 5 [ RunTime:0.125817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291754 ORDER BY `minOrder` ASC [ RunTime:0.057685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291754 ORDER BY `unit` DESC [ RunTime:0.086293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291754 LIMIT 2 [ RunTime:0.048059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291754 ORDER BY `minOrder` ASC [ RunTime:0.012992s ]
select * from pdf where partno='30500109' and brandshort='yageo nexensos' limit 1 [ RunTime:0.066385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30500109' OR `brand` LIKE 'yageo nexensos%' ) ) LIMIT 1 [ RunTime:0.041799s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291754 AND `partno` = '30500109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yageo nexensos%' ) [ RunTime:0.091159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322793 [ RunTime:0.043837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51115747 LIMIT 5 [ RunTime:0.099540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115747 ORDER BY `minOrder` ASC [ RunTime:0.039114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51115747 ORDER BY `unit` DESC [ RunTime:0.057426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51115747 LIMIT 2 [ RunTime:0.044477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51115747 ORDER BY `minOrder` ASC [ RunTime:0.058115s ]
select * from pdf where partno='3057y-1-102' and brandshort='bourns' limit 1 [ RunTime:0.048614s ]
select foldpath,foldpath2,filename from pdf_file where id=1562072 limit 1 [ RunTime:0.030975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057y-1-102' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.057005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138981 LIMIT 5 [ RunTime:0.069351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138981 ORDER BY `minOrder` ASC [ RunTime:0.033285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138981 ORDER BY `unit` DESC [ RunTime:0.011325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138981 LIMIT 2 [ RunTime:0.037593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138981 ORDER BY `minOrder` ASC [ RunTime:0.020761s ]
select * from pdf where partno='3057 rd005' and brandshort='alpha wire' limit 1 [ RunTime:0.013631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057 rd005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.016528s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138981 AND `partno` = '3057 rd005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.024453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407060 [ RunTime:0.029352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258705 LIMIT 5 [ RunTime:0.022677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258705 ORDER BY `minOrder` ASC [ RunTime:0.022752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258705 ORDER BY `unit` DESC [ RunTime:0.012307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258705 LIMIT 2 [ RunTime:0.006354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258705 ORDER BY `minOrder` ASC [ RunTime:0.024817s ]
select * from pdf where partno='305-038-500-202' and brandshort='edac' limit 1 [ RunTime:0.011881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '305-038-500-202' OR `brand` LIKE 'edac%' ) ) LIMIT 1 [ RunTime:0.006200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138976 LIMIT 5 [ RunTime:0.001379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138976 ORDER BY `minOrder` ASC [ RunTime:0.004136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138976 ORDER BY `unit` DESC [ RunTime:0.017183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138976 LIMIT 2 [ RunTime:0.029168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138976 ORDER BY `minOrder` ASC [ RunTime:0.007860s ]
select * from pdf where partno='3051 bk001' and brandshort='alpha wire' limit 1 [ RunTime:0.006346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3051 bk001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.021599s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138976 AND `partno` = '3051 bk001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.032649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407825 [ RunTime:0.023460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116798 LIMIT 5 [ RunTime:0.009903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116798 ORDER BY `minOrder` ASC [ RunTime:0.014708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116798 ORDER BY `unit` DESC [ RunTime:0.013848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116798 LIMIT 2 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116798 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='3059j-1-104mlf' and brandshort='bourns' limit 1 [ RunTime:0.027377s ]
select foldpath,foldpath2,filename from pdf_file where id=1508346 limit 1 [ RunTime:0.008226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3059j-1-104mlf' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.005860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096829 LIMIT 5 [ RunTime:0.002094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096829 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096829 ORDER BY `unit` DESC [ RunTime:0.011709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096829 LIMIT 2 [ RunTime:0.008657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096829 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='3057' and brandshort='adafruit' limit 1 [ RunTime:0.001745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.005411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138395 LIMIT 5 [ RunTime:0.004307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138395 ORDER BY `minOrder` ASC [ RunTime:0.021508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138395 ORDER BY `unit` DESC [ RunTime:0.022482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138395 LIMIT 2 [ RunTime:0.016709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138395 ORDER BY `minOrder` ASC [ RunTime:0.007875s ]
select * from pdf where partno='3050 ws005' and brandshort='alpha wire' limit 1 [ RunTime:0.006416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 ws005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.007352s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138395 AND `partno` = '3050 ws005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.019225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493959 [ RunTime:0.009351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138343 LIMIT 5 [ RunTime:0.004432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138343 ORDER BY `minOrder` ASC [ RunTime:0.002474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138343 ORDER BY `unit` DESC [ RunTime:0.011128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138343 LIMIT 2 [ RunTime:0.021137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138343 ORDER BY `minOrder` ASC [ RunTime:0.005829s ]
select * from pdf where partno='3057 wv005' and brandshort='alpha wire' limit 1 [ RunTime:0.009239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057 wv005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.002361s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138343 AND `partno` = '3057 wv005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14371100 [ RunTime:0.021548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138356 LIMIT 5 [ RunTime:0.017342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138356 ORDER BY `minOrder` ASC [ RunTime:0.053701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138356 ORDER BY `unit` DESC [ RunTime:0.033502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138356 LIMIT 2 [ RunTime:0.013891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138356 ORDER BY `minOrder` ASC [ RunTime:0.007290s ]
select * from pdf where partno='3057 wn005' and brandshort='alpha wire' limit 1 [ RunTime:0.027032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057 wn005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.016564s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138356 AND `partno` = '3057 wn005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.026312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492812 [ RunTime:0.034988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116635 LIMIT 5 [ RunTime:0.014960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116635 ORDER BY `minOrder` ASC [ RunTime:0.040032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116635 ORDER BY `unit` DESC [ RunTime:0.011084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116635 LIMIT 2 [ RunTime:0.025924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116635 ORDER BY `minOrder` ASC [ RunTime:0.030438s ]
select * from pdf where partno='3057p-1-101' and brandshort='bourns' limit 1 [ RunTime:0.035603s ]
select foldpath,foldpath2,filename from pdf_file where id=1488613 limit 1 [ RunTime:0.037059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057p-1-101' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.071372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138980 LIMIT 5 [ RunTime:0.022939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138980 ORDER BY `minOrder` ASC [ RunTime:0.020425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138980 ORDER BY `unit` DESC [ RunTime:0.015262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138980 LIMIT 2 [ RunTime:0.049127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138980 ORDER BY `minOrder` ASC [ RunTime:0.011433s ]
select * from pdf where partno='3055 gr005' and brandshort='alpha wire' limit 1 [ RunTime:0.036382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3055 gr005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.048079s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138980 AND `partno` = '3055 gr005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.024260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492049 [ RunTime:0.080780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138357 LIMIT 5 [ RunTime:0.078819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138357 ORDER BY `minOrder` ASC [ RunTime:0.059081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138357 ORDER BY `unit` DESC [ RunTime:0.061640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138357 LIMIT 2 [ RunTime:0.017976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138357 ORDER BY `minOrder` ASC [ RunTime:0.063565s ]
select * from pdf where partno='3057/1 gr005' and brandshort='alpha wire' limit 1 [ RunTime:0.034368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057/1 gr005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.013051s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138357 AND `partno` = '3057/1 gr005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407864 [ RunTime:0.006862s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.135896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041534 LIMIT 5 [ RunTime:0.019286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041534 ORDER BY `minOrder` ASC [ RunTime:0.009677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041534 ORDER BY `unit` DESC [ RunTime:0.009720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041534 LIMIT 2 [ RunTime:0.010438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041534 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
select * from pdf where partno='3051 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3051 WH001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003060s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041534 AND `partno` = '3051 WH001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489614 [ RunTime:0.007361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041539 LIMIT 5 [ RunTime:0.013706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041539 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041539 ORDER BY `unit` DESC [ RunTime:0.002503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041539 LIMIT 2 [ RunTime:0.004981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041539 ORDER BY `minOrder` ASC [ RunTime:0.007674s ]
select * from pdf where partno='3053 BR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053 BR001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005451s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041539 AND `partno` = '3053 BR001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.008722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489615 [ RunTime:0.019522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042276 LIMIT 5 [ RunTime:0.016291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042276 ORDER BY `minOrder` ASC [ RunTime:0.028079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042276 ORDER BY `unit` DESC [ RunTime:0.016968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042276 LIMIT 2 [ RunTime:0.002879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042276 ORDER BY `minOrder` ASC [ RunTime:0.008109s ]
select * from pdf where partno='3055 BK013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3055 BK013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003153s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042276 AND `partno` = '3055 BK013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16409053 [ RunTime:0.003810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042272 LIMIT 5 [ RunTime:0.002398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042272 ORDER BY `minOrder` ASC [ RunTime:0.022197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042272 ORDER BY `unit` DESC [ RunTime:0.017834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042272 LIMIT 2 [ RunTime:0.009698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042272 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
select * from pdf where partno='3053 BK013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053 BK013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003882s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042272 AND `partno` = '3053 BK013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.007030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493881 [ RunTime:0.012383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406214 LIMIT 5 [ RunTime:0.000773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406214 ORDER BY `minOrder` ASC [ RunTime:0.006432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406214 ORDER BY `unit` DESC [ RunTime:0.005083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406214 LIMIT 2 [ RunTime:0.017623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406214 ORDER BY `minOrder` ASC [ RunTime:0.005465s ]
select * from pdf where partno='3059' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.005579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3059' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.003120s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406214 AND `partno` = '3059' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.003674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321813 [ RunTime:0.010195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406061 LIMIT 5 [ RunTime:0.006524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406061 ORDER BY `minOrder` ASC [ RunTime:0.012633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406061 ORDER BY `unit` DESC [ RunTime:0.003872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406061 LIMIT 2 [ RunTime:0.020390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406061 ORDER BY `minOrder` ASC [ RunTime:0.008866s ]
select * from pdf where partno='3054' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.009605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3054' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.023113s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406061 AND `partno` = '3054' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.022365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321419 [ RunTime:0.010750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406054 LIMIT 5 [ RunTime:0.019665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406054 ORDER BY `minOrder` ASC [ RunTime:0.018391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406054 ORDER BY `unit` DESC [ RunTime:0.009799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406054 LIMIT 2 [ RunTime:0.005050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406054 ORDER BY `minOrder` ASC [ RunTime:0.015087s ]
select * from pdf where partno='3053' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.029356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.020040s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406054 AND `partno` = '3053' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321415 [ RunTime:0.031793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64564683 LIMIT 5 [ RunTime:0.021421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64564683 ORDER BY `minOrder` ASC [ RunTime:0.019962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64564683 ORDER BY `unit` DESC [ RunTime:0.022389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64564683 LIMIT 2 [ RunTime:0.011069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64564683 ORDER BY `minOrder` ASC [ RunTime:0.002801s ]
select * from pdf where partno='3059CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3059CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013605s ]
SELECT `id` FROM `stock` WHERE `id` <> 64564683 AND `partno` = '3059CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042268 LIMIT 5 [ RunTime:0.004519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042268 ORDER BY `minOrder` ASC [ RunTime:0.012088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042268 ORDER BY `unit` DESC [ RunTime:0.005319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042268 LIMIT 2 [ RunTime:0.014349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042268 ORDER BY `minOrder` ASC [ RunTime:0.008336s ]
select * from pdf where partno='3050 BR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BR013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.015775s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042268 AND `partno` = '3050 BR013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.019743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489879 [ RunTime:0.007464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042269 LIMIT 5 [ RunTime:0.021413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042269 ORDER BY `minOrder` ASC [ RunTime:0.028338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042269 ORDER BY `unit` DESC [ RunTime:0.004163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042269 LIMIT 2 [ RunTime:0.001614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042269 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='3050 BL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BL013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000591s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042269 AND `partno` = '3050 BL013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.007919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489878 [ RunTime:0.015514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042299 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042299 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042299 ORDER BY `unit` DESC [ RunTime:0.003879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042299 LIMIT 2 [ RunTime:0.012093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042299 ORDER BY `minOrder` ASC [ RunTime:0.008389s ]
select * from pdf where partno='3055/1 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3055/1 RD001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001104s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042299 AND `partno` = '3055/1 RD001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16409059 [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63386509 LIMIT 5 [ RunTime:0.003987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63386509 ORDER BY `minOrder` ASC [ RunTime:0.010182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63386509 ORDER BY `unit` DESC [ RunTime:0.008876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63386509 LIMIT 2 [ RunTime:0.012342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63386509 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='3053' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.005506s ]
SELECT `id` FROM `stock` WHERE `id` <> 63386509 AND `partno` = '3053' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.013790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13324411 [ RunTime:0.016443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406215 LIMIT 5 [ RunTime:0.008796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406215 ORDER BY `minOrder` ASC [ RunTime:0.002200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406215 ORDER BY `unit` DESC [ RunTime:0.006014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406215 LIMIT 2 [ RunTime:0.003286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406215 ORDER BY `minOrder` ASC [ RunTime:0.004439s ]
select * from pdf where partno='3057' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3057' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.020444s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406215 AND `partno` = '3057' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.006702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321811 [ RunTime:0.005363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406062 LIMIT 5 [ RunTime:0.010879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406062 ORDER BY `minOrder` ASC [ RunTime:0.005460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406062 ORDER BY `unit` DESC [ RunTime:0.000849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406062 LIMIT 2 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406062 ORDER BY `minOrder` ASC [ RunTime:0.009433s ]
select * from pdf where partno='3051' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.014066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3051' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001227s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406062 AND `partno` = '3051' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045256 [ RunTime:0.003268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104612 LIMIT 5 [ RunTime:0.013810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104612 ORDER BY `minOrder` ASC [ RunTime:0.025433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104612 ORDER BY `unit` DESC [ RunTime:0.002410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104612 LIMIT 2 [ RunTime:0.027403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104612 ORDER BY `minOrder` ASC [ RunTime:0.006055s ]
select * from pdf where partno='3050' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.016720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.007744s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104612 AND `partno` = '3050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.003842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388678 [ RunTime:0.002763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406191 LIMIT 5 [ RunTime:0.016981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406191 ORDER BY `minOrder` ASC [ RunTime:0.005655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406191 ORDER BY `unit` DESC [ RunTime:0.012119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406191 LIMIT 2 [ RunTime:0.008664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406191 ORDER BY `minOrder` ASC [ RunTime:0.005553s ]
select * from pdf where partno='3052' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3052' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.003084s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406191 AND `partno` = '3052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.009568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321793 [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63045971 LIMIT 5 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63045971 ORDER BY `minOrder` ASC [ RunTime:0.010451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63045971 ORDER BY `unit` DESC [ RunTime:0.003952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63045971 LIMIT 2 [ RunTime:0.002180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63045971 ORDER BY `minOrder` ASC [ RunTime:0.002218s ]
select * from pdf where partno='3051 WH013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3051 WH013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.009658s ]
SELECT `id` FROM `stock` WHERE `id` <> 63045971 AND `partno` = '3051 WH013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.011394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489683 [ RunTime:0.004126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63045970 LIMIT 5 [ RunTime:0.008595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63045970 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63045970 ORDER BY `unit` DESC [ RunTime:0.004089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63045970 LIMIT 2 [ RunTime:0.003792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63045970 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='3051 BL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3051 BL013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.010744s ]
SELECT `id` FROM `stock` WHERE `id` <> 63045970 AND `partno` = '3051 BL013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.007225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16400925 [ RunTime:0.012922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63043704 LIMIT 5 [ RunTime:0.009377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63043704 ORDER BY `minOrder` ASC [ RunTime:0.009681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63043704 ORDER BY `unit` DESC [ RunTime:0.010118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63043704 LIMIT 2 [ RunTime:0.004346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63043704 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
select * from pdf where partno='3055 WH013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3055 WH013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002654s ]
SELECT `id` FROM `stock` WHERE `id` <> 63043704 AND `partno` = '3055 WH013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.017414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401166 [ RunTime:0.014174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63406071 LIMIT 5 [ RunTime:0.014693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406071 ORDER BY `minOrder` ASC [ RunTime:0.005935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63406071 ORDER BY `unit` DESC [ RunTime:0.038431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63406071 LIMIT 2 [ RunTime:0.007015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63406071 ORDER BY `minOrder` ASC [ RunTime:0.024270s ]
select * from pdf where partno='3056' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3056' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.012585s ]
SELECT `id` FROM `stock` WHERE `id` <> 63406071 AND `partno` = '3056' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.012092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13321422 [ RunTime:0.024600s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053239s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043193s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037313s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037455s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003041s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032074s ]
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 '305%' OR `brand` LIKE '305%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010203s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '305%' OR `brand` LIKE '305%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.068652s ]