SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001203s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004603s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353816 LIMIT 5 [ RunTime:0.001760s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353816 ORDER BY `minOrder` ASC [ RunTime:0.001094s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353816 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353816 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353816 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991593 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991593 ORDER BY `minOrder` ASC [ RunTime:0.006420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991593 ORDER BY `unit` DESC [ RunTime:0.021023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991593 LIMIT 2 [ RunTime:0.007202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991593 ORDER BY `minOrder` ASC [ RunTime:0.018161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004377 LIMIT 5 [ RunTime:0.034038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004377 ORDER BY `minOrder` ASC [ RunTime:0.025081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004377 ORDER BY `unit` DESC [ RunTime:0.010667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004377 LIMIT 2 [ RunTime:0.022040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004377 ORDER BY `minOrder` ASC [ RunTime:0.012540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065050 LIMIT 5 [ RunTime:0.013744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065050 ORDER BY `minOrder` ASC [ RunTime:0.001472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065050 ORDER BY `unit` DESC [ RunTime:0.009978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065050 LIMIT 2 [ RunTime:0.016707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065050 ORDER BY `minOrder` ASC [ RunTime:0.001032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632368 LIMIT 5 [ RunTime:0.005806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632368 ORDER BY `minOrder` ASC [ RunTime:0.012631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632368 ORDER BY `unit` DESC [ RunTime:0.023724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632368 LIMIT 2 [ RunTime:0.012071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632368 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19563289 LIMIT 5 [ RunTime:0.018217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19563289 ORDER BY `minOrder` ASC [ RunTime:0.033437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19563289 ORDER BY `unit` DESC [ RunTime:0.011796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19563289 LIMIT 2 [ RunTime:0.014613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19563289 ORDER BY `minOrder` ASC [ RunTime:0.001271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991518 LIMIT 5 [ RunTime:0.019667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991518 ORDER BY `minOrder` ASC [ RunTime:0.017083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991518 ORDER BY `unit` DESC [ RunTime:0.017900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991518 LIMIT 2 [ RunTime:0.004457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991518 ORDER BY `minOrder` ASC [ RunTime:0.012368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143670 LIMIT 5 [ RunTime:0.006443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143670 ORDER BY `minOrder` ASC [ RunTime:0.007882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17143670 ORDER BY `unit` DESC [ RunTime:0.011532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17143670 LIMIT 2 [ RunTime:0.010415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143670 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658289 LIMIT 5 [ RunTime:0.010530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16658289 ORDER BY `minOrder` ASC [ RunTime:0.004558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16658289 ORDER BY `unit` DESC [ RunTime:0.009909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16658289 LIMIT 2 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16658289 ORDER BY `minOrder` ASC [ RunTime:0.014049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363684 LIMIT 5 [ RunTime:0.010011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363684 ORDER BY `minOrder` ASC [ RunTime:0.003530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15363684 ORDER BY `unit` DESC [ RunTime:0.009126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15363684 LIMIT 2 [ RunTime:0.012238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363684 ORDER BY `minOrder` ASC [ RunTime:0.015080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401208 LIMIT 5 [ RunTime:0.027530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401208 ORDER BY `minOrder` ASC [ RunTime:0.002691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401208 ORDER BY `unit` DESC [ RunTime:0.010859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401208 LIMIT 2 [ RunTime:0.013887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401208 ORDER BY `minOrder` ASC [ RunTime:0.005222s ]
select * from pdf where partno='2638.0109' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.010243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401207 LIMIT 5 [ RunTime:0.016787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401207 ORDER BY `minOrder` ASC [ RunTime:0.013428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401207 ORDER BY `unit` DESC [ RunTime:0.014004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401207 LIMIT 2 [ RunTime:0.029358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401207 ORDER BY `minOrder` ASC [ RunTime:0.033155s ]
select * from pdf where partno='2638.0108' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401206 LIMIT 5 [ RunTime:0.006843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401206 ORDER BY `minOrder` ASC [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401206 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401206 LIMIT 2 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401206 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='2638.0105' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401205 LIMIT 5 [ RunTime:0.017886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401205 ORDER BY `minOrder` ASC [ RunTime:0.014579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401205 ORDER BY `unit` DESC [ RunTime:0.002084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401205 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401205 ORDER BY `minOrder` ASC [ RunTime:0.005526s ]
select * from pdf where partno='2638.0104' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.004648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401204 LIMIT 5 [ RunTime:0.007459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401204 ORDER BY `minOrder` ASC [ RunTime:0.011652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401204 ORDER BY `unit` DESC [ RunTime:0.005072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401204 LIMIT 2 [ RunTime:0.014296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401204 ORDER BY `minOrder` ASC [ RunTime:0.008725s ]
select * from pdf where partno='2638.0103' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.009342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401203 LIMIT 5 [ RunTime:0.005344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401203 ORDER BY `minOrder` ASC [ RunTime:0.003866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401203 ORDER BY `unit` DESC [ RunTime:0.003042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401203 LIMIT 2 [ RunTime:0.001601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401203 ORDER BY `minOrder` ASC [ RunTime:0.010981s ]
select * from pdf where partno='2638.0102' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531378 LIMIT 5 [ RunTime:0.010088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531378 ORDER BY `minOrder` ASC [ RunTime:0.004722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13531378 ORDER BY `unit` DESC [ RunTime:0.010485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13531378 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531378 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531377 LIMIT 5 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531377 ORDER BY `minOrder` ASC [ RunTime:0.001951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13531377 ORDER BY `unit` DESC [ RunTime:0.002186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13531377 LIMIT 2 [ RunTime:0.002057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531377 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531376 LIMIT 5 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531376 ORDER BY `minOrder` ASC [ RunTime:0.002285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13531376 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13531376 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531376 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531375 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531375 ORDER BY `minOrder` ASC [ RunTime:0.001423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13531375 ORDER BY `unit` DESC [ RunTime:0.002210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13531375 LIMIT 2 [ RunTime:0.001470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531375 ORDER BY `minOrder` ASC [ RunTime:0.003563s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001180s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49635392 LIMIT 5 [ RunTime:0.007104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49635392 ORDER BY `minOrder` ASC [ RunTime:0.007208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49635392 ORDER BY `unit` DESC [ RunTime:0.001202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49635392 LIMIT 2 [ RunTime:0.004652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49635392 ORDER BY `minOrder` ASC [ RunTime:0.001009s ]
select * from pdf where partno='2638340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000557s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001543s ]
SELECT `id` FROM `stock` WHERE `id` <> 49635392 AND `partno` = '2638340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991518 [ RunTime:0.003302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36828548 LIMIT 5 [ RunTime:0.003157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36828548 ORDER BY `minOrder` ASC [ RunTime:0.003289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36828548 ORDER BY `unit` DESC [ RunTime:0.012667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36828548 LIMIT 2 [ RunTime:0.009242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36828548 ORDER BY `minOrder` ASC [ RunTime:0.002982s ]
select * from pdf where partno='2638340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000274s ]
SELECT `id` FROM `stock` WHERE `id` <> 36828548 AND `partno` = '2638340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991518 [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50735052 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50735052 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50735052 ORDER BY `unit` DESC [ RunTime:0.002936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50735052 LIMIT 2 [ RunTime:0.002684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50735052 ORDER BY `minOrder` ASC [ RunTime:0.001226s ]
select * from pdf where partno='2638CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003694s ]
SELECT `id` FROM `stock` WHERE `id` <> 50735052 AND `partno` = '2638CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065050 [ RunTime:0.003661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38134471 LIMIT 5 [ RunTime:0.002800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38134471 ORDER BY `minOrder` ASC [ RunTime:0.001563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38134471 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38134471 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38134471 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='2638CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 38134471 AND `partno` = '2638CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065050 [ RunTime:0.007093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53597874 LIMIT 5 [ RunTime:0.003993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53597874 ORDER BY `minOrder` ASC [ RunTime:0.005623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53597874 ORDER BY `unit` DESC [ RunTime:0.001449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53597874 LIMIT 2 [ RunTime:0.009289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53597874 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
select * from pdf where partno='2638490000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638490000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005544s ]
SELECT `id` FROM `stock` WHERE `id` <> 53597874 AND `partno` = '2638490000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353816 [ RunTime:0.009802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43761620 LIMIT 5 [ RunTime:0.001463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761620 ORDER BY `minOrder` ASC [ RunTime:0.001284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43761620 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43761620 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761620 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='2638330000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638330000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003992s ]
SELECT `id` FROM `stock` WHERE `id` <> 43761620 AND `partno` = '2638330000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143670 [ RunTime:0.003163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43761621 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761621 ORDER BY `minOrder` ASC [ RunTime:0.001161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43761621 ORDER BY `unit` DESC [ RunTime:0.006177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43761621 LIMIT 2 [ RunTime:0.005739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761621 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
select * from pdf where partno='2638320000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638320000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001764s ]
SELECT `id` FROM `stock` WHERE `id` <> 43761621 AND `partno` = '2638320000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363684 [ RunTime:0.011959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53769083 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53769083 ORDER BY `minOrder` ASC [ RunTime:0.008350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53769083 ORDER BY `unit` DESC [ RunTime:0.000888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53769083 LIMIT 2 [ RunTime:0.004934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53769083 ORDER BY `minOrder` ASC [ RunTime:0.005020s ]
select * from pdf where partno='2638770000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638770000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002532s ]
SELECT `id` FROM `stock` WHERE `id` <> 53769083 AND `partno` = '2638770000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53701647 LIMIT 5 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53701647 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53701647 ORDER BY `unit` DESC [ RunTime:0.004564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53701647 LIMIT 2 [ RunTime:0.005654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53701647 ORDER BY `minOrder` ASC [ RunTime:0.002040s ]
select * from pdf where partno='2638890000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638890000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011952s ]
SELECT `id` FROM `stock` WHERE `id` <> 53701647 AND `partno` = '2638890000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632368 [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53595344 LIMIT 5 [ RunTime:0.001547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53595344 ORDER BY `minOrder` ASC [ RunTime:0.008813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53595344 ORDER BY `unit` DESC [ RunTime:0.004352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53595344 LIMIT 2 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53595344 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
select * from pdf where partno='2638860000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638860000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010471s ]
SELECT `id` FROM `stock` WHERE `id` <> 53595344 AND `partno` = '2638860000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12865785 [ RunTime:0.007790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51643235 LIMIT 5 [ RunTime:0.008165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51643235 ORDER BY `minOrder` ASC [ RunTime:0.004829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51643235 ORDER BY `unit` DESC [ RunTime:0.014765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51643235 LIMIT 2 [ RunTime:0.004240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51643235 ORDER BY `minOrder` ASC [ RunTime:0.003026s ]
select * from pdf where partno='26388-2-4039' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.015082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26388-2-4039' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.024436s ]
SELECT `id` FROM `stock` WHERE `id` <> 51643235 AND `partno` = '26388-2-4039' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.019437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004377 [ RunTime:0.000880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720939 LIMIT 5 [ RunTime:0.005646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720939 ORDER BY `minOrder` ASC [ RunTime:0.003858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720939 ORDER BY `unit` DESC [ RunTime:0.000939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720939 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720939 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='2638070000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638070000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008565s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720939 AND `partno` = '2638070000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658289 [ RunTime:0.002225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50680239 LIMIT 5 [ RunTime:0.004007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50680239 ORDER BY `minOrder` ASC [ RunTime:0.001390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50680239 ORDER BY `unit` DESC [ RunTime:0.000797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50680239 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50680239 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='2638500000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638500000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003753s ]
SELECT `id` FROM `stock` WHERE `id` <> 50680239 AND `partno` = '2638500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13475168 [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49637657 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49637657 ORDER BY `minOrder` ASC [ RunTime:0.004236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49637657 ORDER BY `unit` DESC [ RunTime:0.006025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49637657 LIMIT 2 [ RunTime:0.010092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49637657 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
select * from pdf where partno='2638340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007653s ]
SELECT `id` FROM `stock` WHERE `id` <> 49637657 AND `partno` = '2638340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991518 [ RunTime:0.006979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49570734 LIMIT 5 [ RunTime:0.011248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49570734 ORDER BY `minOrder` ASC [ RunTime:0.013385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49570734 ORDER BY `unit` DESC [ RunTime:0.012698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49570734 LIMIT 2 [ RunTime:0.005231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49570734 ORDER BY `minOrder` ASC [ RunTime:0.006985s ]
select * from pdf where partno='2638' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.001016s ]
SELECT `id` FROM `stock` WHERE `id` <> 49570734 AND `partno` = '2638' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36763997 [ RunTime:0.003243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348630 LIMIT 5 [ RunTime:0.002649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348630 ORDER BY `minOrder` ASC [ RunTime:0.010165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348630 ORDER BY `unit` DESC [ RunTime:0.030610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348630 LIMIT 2 [ RunTime:0.002631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348630 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
select * from pdf where partno='2638.0109' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638.0109' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001043s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348630 AND `partno` = '2638.0109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.010585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401208 [ RunTime:0.003001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348629 LIMIT 5 [ RunTime:0.001013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348629 ORDER BY `minOrder` ASC [ RunTime:0.003714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348629 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348629 LIMIT 2 [ RunTime:0.002541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348629 ORDER BY `minOrder` ASC [ RunTime:0.005948s ]
select * from pdf where partno='2638.0105' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.006078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638.0105' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.004470s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348629 AND `partno` = '2638.0105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.004844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401206 [ RunTime:0.000733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348628 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348628 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348628 ORDER BY `unit` DESC [ RunTime:0.007235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348628 LIMIT 2 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348628 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='2638.0104' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638.0104' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000918s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348628 AND `partno` = '2638.0104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401205 [ RunTime:0.002931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348627 LIMIT 5 [ RunTime:0.003513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348627 ORDER BY `minOrder` ASC [ RunTime:0.010733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348627 ORDER BY `unit` DESC [ RunTime:0.018160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348627 LIMIT 2 [ RunTime:0.003681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348627 ORDER BY `minOrder` ASC [ RunTime:0.010615s ]
select * from pdf where partno='2638.0101' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.013643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638.0101' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002233s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348627 AND `partno` = '2638.0101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.012811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531376 [ RunTime:0.009451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49347874 LIMIT 5 [ RunTime:0.003791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347874 ORDER BY `minOrder` ASC [ RunTime:0.007644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49347874 ORDER BY `unit` DESC [ RunTime:0.012436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49347874 LIMIT 2 [ RunTime:0.007218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347874 ORDER BY `minOrder` ASC [ RunTime:0.007990s ]
select * from pdf where partno='2638.0108' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2638.0108' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.004781s ]
SELECT `id` FROM `stock` WHERE `id` <> 49347874 AND `partno` = '2638.0108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401207 [ RunTime:0.000473s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002767s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002213s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004105s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002006s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007808s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003690s ]
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 '2638%' OR `brand` LIKE '2638%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002549s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2638%' OR `brand` LIKE '2638%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004220s ]