SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003040s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=BP3&search=1' [ RunTime:0.005586s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001240s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000659s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002003s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.002422s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001654s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001332s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BP3' LIMIT 1 [ RunTime:0.033849s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-24 02:08:57' WHERE `partno` = 'BP3' [ RunTime:0.020036s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004283s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027118s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225169 LIMIT 5 [ RunTime:0.005939s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225169 ORDER BY `minOrder` ASC [ RunTime:0.008878s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12225169 ORDER BY `unit` DESC [ RunTime:0.013343s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12225169 LIMIT 2 [ RunTime:0.029213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225169 ORDER BY `minOrder` ASC [ RunTime:0.015735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244242 LIMIT 5 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244242 ORDER BY `minOrder` ASC [ RunTime:0.026425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13244242 ORDER BY `unit` DESC [ RunTime:0.011686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13244242 LIMIT 2 [ RunTime:0.021881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244242 ORDER BY `minOrder` ASC [ RunTime:0.015997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11976155 LIMIT 5 [ RunTime:0.039749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11976155 ORDER BY `minOrder` ASC [ RunTime:0.016662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11976155 ORDER BY `unit` DESC [ RunTime:0.020956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11976155 LIMIT 2 [ RunTime:0.037978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11976155 ORDER BY `minOrder` ASC [ RunTime:0.029608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991618 LIMIT 5 [ RunTime:0.016671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991618 ORDER BY `minOrder` ASC [ RunTime:0.009483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991618 ORDER BY `unit` DESC [ RunTime:0.005091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991618 LIMIT 2 [ RunTime:0.010959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991618 ORDER BY `minOrder` ASC [ RunTime:0.009667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991620 LIMIT 5 [ RunTime:0.032365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991620 ORDER BY `minOrder` ASC [ RunTime:0.027738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991620 ORDER BY `unit` DESC [ RunTime:0.009744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991620 LIMIT 2 [ RunTime:0.029030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991620 ORDER BY `minOrder` ASC [ RunTime:0.012576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973912 LIMIT 5 [ RunTime:0.010494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973912 ORDER BY `minOrder` ASC [ RunTime:0.010684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11973912 ORDER BY `unit` DESC [ RunTime:0.007794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11973912 LIMIT 2 [ RunTime:0.034679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973912 ORDER BY `minOrder` ASC [ RunTime:0.008698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991615 LIMIT 5 [ RunTime:0.015201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991615 ORDER BY `minOrder` ASC [ RunTime:0.020240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991615 ORDER BY `unit` DESC [ RunTime:0.001807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991615 LIMIT 2 [ RunTime:0.010211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991615 ORDER BY `minOrder` ASC [ RunTime:0.005156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273311 LIMIT 5 [ RunTime:0.018546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273311 ORDER BY `minOrder` ASC [ RunTime:0.048971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14273311 ORDER BY `unit` DESC [ RunTime:0.024447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14273311 LIMIT 2 [ RunTime:0.040354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273311 ORDER BY `minOrder` ASC [ RunTime:0.016311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12409564 LIMIT 5 [ RunTime:0.027455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409564 ORDER BY `minOrder` ASC [ RunTime:0.006776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12409564 ORDER BY `unit` DESC [ RunTime:0.022169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12409564 LIMIT 2 [ RunTime:0.014009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409564 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
select * from pdf where partno='BP35C5-T01' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.038648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12071666 LIMIT 5 [ RunTime:0.034336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12071666 ORDER BY `minOrder` ASC [ RunTime:0.012556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12071666 ORDER BY `unit` DESC [ RunTime:0.010484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12071666 LIMIT 2 [ RunTime:0.016024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12071666 ORDER BY `minOrder` ASC [ RunTime:0.015842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19018803 LIMIT 5 [ RunTime:0.040857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19018803 ORDER BY `minOrder` ASC [ RunTime:0.012474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19018803 ORDER BY `unit` DESC [ RunTime:0.028830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19018803 LIMIT 2 [ RunTime:0.026340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19018803 ORDER BY `minOrder` ASC [ RunTime:0.006522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18854386 LIMIT 5 [ RunTime:0.041711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18854386 ORDER BY `minOrder` ASC [ RunTime:0.063477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18854386 ORDER BY `unit` DESC [ RunTime:0.040005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18854386 LIMIT 2 [ RunTime:0.011212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18854386 ORDER BY `minOrder` ASC [ RunTime:0.005893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850075 LIMIT 5 [ RunTime:0.012134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850075 ORDER BY `minOrder` ASC [ RunTime:0.027057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850075 ORDER BY `unit` DESC [ RunTime:0.004410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850075 LIMIT 2 [ RunTime:0.013527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850075 ORDER BY `minOrder` ASC [ RunTime:0.001682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849967 LIMIT 5 [ RunTime:0.005508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849967 ORDER BY `minOrder` ASC [ RunTime:0.023267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849967 ORDER BY `unit` DESC [ RunTime:0.013986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849967 LIMIT 2 [ RunTime:0.014878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849967 ORDER BY `minOrder` ASC [ RunTime:0.009036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849905 LIMIT 5 [ RunTime:0.006182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849905 ORDER BY `minOrder` ASC [ RunTime:0.010006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849905 ORDER BY `unit` DESC [ RunTime:0.010811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849905 LIMIT 2 [ RunTime:0.018850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849905 ORDER BY `minOrder` ASC [ RunTime:0.006852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849303 LIMIT 5 [ RunTime:0.005701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849303 ORDER BY `minOrder` ASC [ RunTime:0.009768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849303 ORDER BY `unit` DESC [ RunTime:0.004226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849303 LIMIT 2 [ RunTime:0.007090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849303 ORDER BY `minOrder` ASC [ RunTime:0.005532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848366 LIMIT 5 [ RunTime:0.016363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848366 ORDER BY `minOrder` ASC [ RunTime:0.025853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848366 ORDER BY `unit` DESC [ RunTime:0.004952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848366 LIMIT 2 [ RunTime:0.002241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848366 ORDER BY `minOrder` ASC [ RunTime:0.007200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848362 LIMIT 5 [ RunTime:0.013752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848362 ORDER BY `minOrder` ASC [ RunTime:0.028973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848362 ORDER BY `unit` DESC [ RunTime:0.026628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848362 LIMIT 2 [ RunTime:0.010531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848362 ORDER BY `minOrder` ASC [ RunTime:0.023233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800241 LIMIT 5 [ RunTime:0.031974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800241 ORDER BY `minOrder` ASC [ RunTime:0.032861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800241 ORDER BY `unit` DESC [ RunTime:0.016617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800241 LIMIT 2 [ RunTime:0.026291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800241 ORDER BY `minOrder` ASC [ RunTime:0.003354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273359 LIMIT 5 [ RunTime:0.018298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273359 ORDER BY `minOrder` ASC [ RunTime:0.017819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14273359 ORDER BY `unit` DESC [ RunTime:0.013220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14273359 LIMIT 2 [ RunTime:0.014800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273359 ORDER BY `minOrder` ASC [ RunTime:0.003796s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32298281 LIMIT 5 [ RunTime:0.019804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32298281 ORDER BY `minOrder` ASC [ RunTime:0.013924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32298281 ORDER BY `unit` DESC [ RunTime:0.013821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32298281 LIMIT 2 [ RunTime:0.007716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32298281 ORDER BY `minOrder` ASC [ RunTime:0.009836s ]
select * from pdf where partno='bp35c5' and brandshort='rohm semiconductor' limit 1 [ RunTime:0.008850s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bp35c5' OR `brand` LIKE 'rohm semiconductor%' ) ) LIMIT 1 [ RunTime:0.006809s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51258658 LIMIT 5 [ RunTime:0.004509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51258658 ORDER BY `minOrder` ASC [ RunTime:0.004053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51258658 ORDER BY `unit` DESC [ RunTime:0.008698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51258658 LIMIT 2 [ RunTime:0.009859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51258658 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
select * from pdf where partno='BP3AD6SS-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.029685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3AD6SS-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.024516s ]
SELECT `id` FROM `stock` WHERE `id` <> 51258658 AND `partno` = 'BP3AD6SS-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.015138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51260722 LIMIT 5 [ RunTime:0.002502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51260722 ORDER BY `minOrder` ASC [ RunTime:0.005781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51260722 ORDER BY `unit` DESC [ RunTime:0.004451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51260722 LIMIT 2 [ RunTime:0.001977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51260722 ORDER BY `minOrder` ASC [ RunTime:0.003849s ]
select * from pdf where partno='BP3AM6MS-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.004716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3AM6MS-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.001455s ]
SELECT `id` FROM `stock` WHERE `id` <> 51260722 AND `partno` = 'BP3AM6MS-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.008358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51261851 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261851 ORDER BY `minOrder` ASC [ RunTime:0.023953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51261851 ORDER BY `unit` DESC [ RunTime:0.014142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51261851 LIMIT 2 [ RunTime:0.006366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261851 ORDER BY `minOrder` ASC [ RunTime:0.002738s ]
select * from pdf where partno='BP3AM6MS-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3AM6MS-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.008435s ]
SELECT `id` FROM `stock` WHERE `id` <> 51261851 AND `partno` = 'BP3AM6MS-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.014728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225169 [ RunTime:0.007938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51256588 LIMIT 5 [ RunTime:0.023502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51256588 ORDER BY `minOrder` ASC [ RunTime:0.023670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51256588 ORDER BY `unit` DESC [ RunTime:0.011245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51256588 LIMIT 2 [ RunTime:0.010864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51256588 ORDER BY `minOrder` ASC [ RunTime:0.002379s ]
select * from pdf where partno='BP3AM1MS-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.002185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3AM1MS-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.005180s ]
SELECT `id` FROM `stock` WHERE `id` <> 51256588 AND `partno` = 'BP3AM1MS-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.007765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51257155 LIMIT 5 [ RunTime:0.003981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51257155 ORDER BY `minOrder` ASC [ RunTime:0.009714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51257155 ORDER BY `unit` DESC [ RunTime:0.002524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51257155 LIMIT 2 [ RunTime:0.001372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51257155 ORDER BY `minOrder` ASC [ RunTime:0.006174s ]
select * from pdf where partno='BP3AD1SS-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.004740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3AD1SS-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.000688s ]
SELECT `id` FROM `stock` WHERE `id` <> 51257155 AND `partno` = 'BP3AD1SS-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.031301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409315 LIMIT 5 [ RunTime:0.018579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409315 ORDER BY `minOrder` ASC [ RunTime:0.009473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409315 ORDER BY `unit` DESC [ RunTime:0.004862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409315 LIMIT 2 [ RunTime:0.011361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409315 ORDER BY `minOrder` ASC [ RunTime:0.007546s ]
select * from pdf where partno='BP35C5' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.010452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP35C5' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.023346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606743 LIMIT 5 [ RunTime:0.011905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606743 ORDER BY `minOrder` ASC [ RunTime:0.004510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606743 ORDER BY `unit` DESC [ RunTime:0.005109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606743 LIMIT 2 [ RunTime:0.013285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606743 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
select * from pdf where partno='BP35C5' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.000674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP35C5' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55641153 LIMIT 5 [ RunTime:0.008134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55641153 ORDER BY `minOrder` ASC [ RunTime:0.016901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55641153 ORDER BY `unit` DESC [ RunTime:0.012482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55641153 LIMIT 2 [ RunTime:0.009723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55641153 ORDER BY `minOrder` ASC [ RunTime:0.015529s ]
select * from pdf where partno='BP3W3C2' and brandshort='TYCLON' limit 1 [ RunTime:0.009725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3W3C2' OR `brand` LIKE 'TYCLON%' ) ) LIMIT 1 [ RunTime:0.014076s ]
SELECT `id` FROM `stock` WHERE `id` <> 55641153 AND `partno` = 'BP3W3C2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tyclon%' ) [ RunTime:0.009816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50410020 LIMIT 5 [ RunTime:0.009258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50410020 ORDER BY `minOrder` ASC [ RunTime:0.008665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50410020 ORDER BY `unit` DESC [ RunTime:0.011116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50410020 LIMIT 2 [ RunTime:0.004178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50410020 ORDER BY `minOrder` ASC [ RunTime:0.009726s ]
select * from pdf where partno='BP3622' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3622' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37607440 LIMIT 5 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607440 ORDER BY `minOrder` ASC [ RunTime:0.003647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37607440 ORDER BY `unit` DESC [ RunTime:0.010413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37607440 LIMIT 2 [ RunTime:0.012794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607440 ORDER BY `minOrder` ASC [ RunTime:0.004526s ]
select * from pdf where partno='BP3622' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.008003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3622' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56639281 LIMIT 5 [ RunTime:0.005630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56639281 ORDER BY `minOrder` ASC [ RunTime:0.010749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56639281 ORDER BY `unit` DESC [ RunTime:0.009957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56639281 LIMIT 2 [ RunTime:0.001123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56639281 ORDER BY `minOrder` ASC [ RunTime:0.006481s ]
select * from pdf where partno='BP3024CS' and brandshort='Stahlin' limit 1 [ RunTime:0.010233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3024CS' OR `brand` LIKE 'Stahlin%' ) ) LIMIT 1 [ RunTime:0.016441s ]
SELECT `id` FROM `stock` WHERE `id` <> 56639281 AND `partno` = 'BP3024CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stahlin%' ) [ RunTime:0.021067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991620 [ RunTime:0.004625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50410316 LIMIT 5 [ RunTime:0.006183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50410316 ORDER BY `minOrder` ASC [ RunTime:0.028114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50410316 ORDER BY `unit` DESC [ RunTime:0.019706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50410316 LIMIT 2 [ RunTime:0.023415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50410316 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
select * from pdf where partno='BP3621' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.022657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3621' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.036378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37607737 LIMIT 5 [ RunTime:0.026758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607737 ORDER BY `minOrder` ASC [ RunTime:0.028924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37607737 ORDER BY `unit` DESC [ RunTime:0.022446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37607737 LIMIT 2 [ RunTime:0.026777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607737 ORDER BY `minOrder` ASC [ RunTime:0.008768s ]
select * from pdf where partno='BP3621' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.035982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3621' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.011652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56027536 LIMIT 5 [ RunTime:0.027963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56027536 ORDER BY `minOrder` ASC [ RunTime:0.029222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56027536 ORDER BY `unit` DESC [ RunTime:0.023346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56027536 LIMIT 2 [ RunTime:0.044671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56027536 ORDER BY `minOrder` ASC [ RunTime:0.016817s ]
select * from pdf where partno='BP3W3DV' and brandshort='TYCLON' limit 1 [ RunTime:0.031888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3W3DV' OR `brand` LIKE 'TYCLON%' ) ) LIMIT 1 [ RunTime:0.050705s ]
SELECT `id` FROM `stock` WHERE `id` <> 56027536 AND `partno` = 'BP3W3DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tyclon%' ) [ RunTime:0.073003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50991332 LIMIT 5 [ RunTime:0.028767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50991332 ORDER BY `minOrder` ASC [ RunTime:0.043320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50991332 ORDER BY `unit` DESC [ RunTime:0.025722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50991332 LIMIT 2 [ RunTime:0.011011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50991332 ORDER BY `minOrder` ASC [ RunTime:0.014215s ]
select * from pdf where partno='BP35C5-T01' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.005946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP35C5-T01' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.029777s ]
SELECT `id` FROM `stock` WHERE `id` <> 50991332 AND `partno` = 'BP35C5-T01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.024566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12409564 [ RunTime:0.046701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38526791 LIMIT 5 [ RunTime:0.027904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38526791 ORDER BY `minOrder` ASC [ RunTime:0.033899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38526791 ORDER BY `unit` DESC [ RunTime:0.032659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38526791 LIMIT 2 [ RunTime:0.033417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38526791 ORDER BY `minOrder` ASC [ RunTime:0.020803s ]
select * from pdf where partno='BP35C5-T01' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.025023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP35C5-T01' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003009s ]
SELECT `id` FROM `stock` WHERE `id` <> 38526791 AND `partno` = 'BP35C5-T01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.016991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12409564 [ RunTime:0.005845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56027542 LIMIT 5 [ RunTime:0.017701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56027542 ORDER BY `minOrder` ASC [ RunTime:0.014341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56027542 ORDER BY `unit` DESC [ RunTime:0.020231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56027542 LIMIT 2 [ RunTime:0.008525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56027542 ORDER BY `minOrder` ASC [ RunTime:0.009229s ]
select * from pdf where partno='BP3W5FC' and brandshort='TYCLON' limit 1 [ RunTime:0.021456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3W5FC' OR `brand` LIKE 'TYCLON%' ) ) LIMIT 1 [ RunTime:0.002503s ]
SELECT `id` FROM `stock` WHERE `id` <> 56027542 AND `partno` = 'BP3W5FC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tyclon%' ) [ RunTime:0.026389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56027538 LIMIT 5 [ RunTime:0.023918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56027538 ORDER BY `minOrder` ASC [ RunTime:0.015106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56027538 ORDER BY `unit` DESC [ RunTime:0.002400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56027538 LIMIT 2 [ RunTime:0.019929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56027538 ORDER BY `minOrder` ASC [ RunTime:0.019489s ]
select * from pdf where partno='BP3W1.5DV' and brandshort='TYCLON' limit 1 [ RunTime:0.013728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP3W1.5DV' OR `brand` LIKE 'TYCLON%' ) ) LIMIT 1 [ RunTime:0.028047s ]
SELECT `id` FROM `stock` WHERE `id` <> 56027538 AND `partno` = 'BP3W1.5DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tyclon%' ) [ RunTime:0.011128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51220907 LIMIT 5 [ RunTime:0.013808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51220907 ORDER BY `minOrder` ASC [ RunTime:0.013107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51220907 ORDER BY `unit` DESC [ RunTime:0.032034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51220907 LIMIT 2 [ RunTime:0.016197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51220907 ORDER BY `minOrder` ASC [ RunTime:0.005574s ]
select * from pdf where partno='BP33-12S-B7' and brandshort='B B Battery' limit 1 [ RunTime:0.011455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP33-12S-B7' OR `brand` LIKE 'B B Battery%' ) ) LIMIT 1 [ RunTime:0.018601s ]
SELECT `id` FROM `stock` WHERE `id` <> 51220907 AND `partno` = 'BP33-12S-B7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b b battery%' ) [ RunTime:0.019209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273311 [ RunTime:0.008918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57310111 LIMIT 5 [ RunTime:0.005968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310111 ORDER BY `minOrder` ASC [ RunTime:0.011189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57310111 ORDER BY `unit` DESC [ RunTime:0.019801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57310111 LIMIT 2 [ RunTime:0.005586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310111 ORDER BY `minOrder` ASC [ RunTime:0.002926s ]
select * from pdf where partno='BP36RT' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.006047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BP36RT' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.016496s ]
SELECT `id` FROM `stock` WHERE `id` <> 57310111 AND `partno` = 'BP36RT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.005101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12071666 [ RunTime:0.009530s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004031s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007952s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004034s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006146s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017517s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015683s ]
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 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016004s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BP3%' OR `brand` LIKE 'BP3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010979s ]