SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001752s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=6535&search=1' [ RunTime:0.015152s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003159s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.012686s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001624s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.016218s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001257s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.021158s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001134s ]
SELECT * FROM `stock_search` WHERE `partno` = '6535' LIMIT 1 [ RunTime:0.030648s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-25 20:21:28' WHERE `partno` = '6535' [ RunTime:0.032147s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002602s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.171332s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.024510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035956 LIMIT 5 [ RunTime:0.038373s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035956 ORDER BY `minOrder` ASC [ RunTime:0.066511s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035956 ORDER BY `unit` DESC [ RunTime:0.013871s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035956 LIMIT 2 [ RunTime:0.061685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035956 ORDER BY `minOrder` ASC [ RunTime:0.067579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140272 LIMIT 5 [ RunTime:0.018072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140272 ORDER BY `minOrder` ASC [ RunTime:0.020084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140272 ORDER BY `unit` DESC [ RunTime:0.064628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140272 LIMIT 2 [ RunTime:0.092502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140272 ORDER BY `minOrder` ASC [ RunTime:0.023877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983428 LIMIT 5 [ RunTime:0.017236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983428 ORDER BY `minOrder` ASC [ RunTime:0.002303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18983428 ORDER BY `unit` DESC [ RunTime:0.077222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18983428 LIMIT 2 [ RunTime:0.036266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983428 ORDER BY `minOrder` ASC [ RunTime:0.018721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18758646 LIMIT 5 [ RunTime:0.024277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18758646 ORDER BY `minOrder` ASC [ RunTime:0.017374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18758646 ORDER BY `unit` DESC [ RunTime:0.030829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18758646 LIMIT 2 [ RunTime:0.018086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18758646 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18758560 LIMIT 5 [ RunTime:0.075336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18758560 ORDER BY `minOrder` ASC [ RunTime:0.007528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18758560 ORDER BY `unit` DESC [ RunTime:0.036136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18758560 LIMIT 2 [ RunTime:0.013388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18758560 ORDER BY `minOrder` ASC [ RunTime:0.020510s ]
select * from pdf where partno='653598-4' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.009942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754739 LIMIT 5 [ RunTime:0.052698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754739 ORDER BY `minOrder` ASC [ RunTime:0.018563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754739 ORDER BY `unit` DESC [ RunTime:0.026560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754739 LIMIT 2 [ RunTime:0.029302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754739 ORDER BY `minOrder` ASC [ RunTime:0.032418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754418 LIMIT 5 [ RunTime:0.005649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754418 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754418 ORDER BY `unit` DESC [ RunTime:0.004002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754418 LIMIT 2 [ RunTime:0.011109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754418 ORDER BY `minOrder` ASC [ RunTime:0.004960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754381 LIMIT 5 [ RunTime:0.015796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754381 ORDER BY `minOrder` ASC [ RunTime:0.052484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754381 ORDER BY `unit` DESC [ RunTime:0.020541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754381 LIMIT 2 [ RunTime:0.040533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754381 ORDER BY `minOrder` ASC [ RunTime:0.006568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754355 LIMIT 5 [ RunTime:0.026660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754355 ORDER BY `minOrder` ASC [ RunTime:0.017639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754355 ORDER BY `unit` DESC [ RunTime:0.011648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754355 LIMIT 2 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754355 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754354 LIMIT 5 [ RunTime:0.003761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754354 ORDER BY `minOrder` ASC [ RunTime:0.001284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754354 ORDER BY `unit` DESC [ RunTime:0.006447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754354 LIMIT 2 [ RunTime:0.013250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754354 ORDER BY `minOrder` ASC [ RunTime:0.011941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754353 LIMIT 5 [ RunTime:0.007547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754353 ORDER BY `minOrder` ASC [ RunTime:0.002952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754353 ORDER BY `unit` DESC [ RunTime:0.007228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754353 LIMIT 2 [ RunTime:0.003740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754353 ORDER BY `minOrder` ASC [ RunTime:0.002340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18746053 LIMIT 5 [ RunTime:0.010996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18746053 ORDER BY `minOrder` ASC [ RunTime:0.002466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18746053 ORDER BY `unit` DESC [ RunTime:0.006122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18746053 LIMIT 2 [ RunTime:0.022556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18746053 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18739673 LIMIT 5 [ RunTime:0.029755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18739673 ORDER BY `minOrder` ASC [ RunTime:0.016800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18739673 ORDER BY `unit` DESC [ RunTime:0.001956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18739673 LIMIT 2 [ RunTime:0.003455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18739673 ORDER BY `minOrder` ASC [ RunTime:0.007447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18736713 LIMIT 5 [ RunTime:0.005174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18736713 ORDER BY `minOrder` ASC [ RunTime:0.008457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18736713 ORDER BY `unit` DESC [ RunTime:0.011691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18736713 LIMIT 2 [ RunTime:0.008267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18736713 ORDER BY `minOrder` ASC [ RunTime:0.011260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18735306 LIMIT 5 [ RunTime:0.022067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18735306 ORDER BY `minOrder` ASC [ RunTime:0.023371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18735306 ORDER BY `unit` DESC [ RunTime:0.043300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18735306 LIMIT 2 [ RunTime:0.014356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18735306 ORDER BY `minOrder` ASC [ RunTime:0.006530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734769 LIMIT 5 [ RunTime:0.030319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734769 ORDER BY `minOrder` ASC [ RunTime:0.040706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734769 ORDER BY `unit` DESC [ RunTime:0.050148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734769 LIMIT 2 [ RunTime:0.049129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734769 ORDER BY `minOrder` ASC [ RunTime:0.020977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734747 LIMIT 5 [ RunTime:0.020014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734747 ORDER BY `minOrder` ASC [ RunTime:0.011724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734747 ORDER BY `unit` DESC [ RunTime:0.020449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734747 LIMIT 2 [ RunTime:0.041845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734747 ORDER BY `minOrder` ASC [ RunTime:0.006021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734745 LIMIT 5 [ RunTime:0.011774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734745 ORDER BY `minOrder` ASC [ RunTime:0.048251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734745 ORDER BY `unit` DESC [ RunTime:0.018334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734745 LIMIT 2 [ RunTime:0.031886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734745 ORDER BY `minOrder` ASC [ RunTime:0.007870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734627 LIMIT 5 [ RunTime:0.028277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734627 ORDER BY `minOrder` ASC [ RunTime:0.035753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734627 ORDER BY `unit` DESC [ RunTime:0.037318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734627 LIMIT 2 [ RunTime:0.026684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734627 ORDER BY `minOrder` ASC [ RunTime:0.001817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17051450 LIMIT 5 [ RunTime:0.052111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17051450 ORDER BY `minOrder` ASC [ RunTime:0.050162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17051450 ORDER BY `unit` DESC [ RunTime:0.040278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17051450 LIMIT 2 [ RunTime:0.072444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17051450 ORDER BY `minOrder` ASC [ RunTime:0.018084s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218624 LIMIT 5 [ RunTime:0.008119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218624 ORDER BY `minOrder` ASC [ RunTime:0.050168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218624 ORDER BY `unit` DESC [ RunTime:0.013910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218624 LIMIT 2 [ RunTime:0.018542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218624 ORDER BY `minOrder` ASC [ RunTime:0.008882s ]
select * from pdf where partno='6535th' and brandshort='flambeau' limit 1 [ RunTime:0.026362s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535th' OR `brand` LIKE 'flambeau%' ) ) LIMIT 1 [ RunTime:0.024167s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218624 AND `partno` = '6535th' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau%' ) [ RunTime:0.047861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32185680 [ RunTime:0.015185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035956 [ RunTime:0.028927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32185680 LIMIT 5 [ RunTime:0.015369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185680 ORDER BY `minOrder` ASC [ RunTime:0.049036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32185680 ORDER BY `unit` DESC [ RunTime:0.006375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32185680 LIMIT 2 [ RunTime:0.011839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185680 ORDER BY `minOrder` ASC [ RunTime:0.011913s ]
select * from pdf where partno='6535th' and brandshort='flambeau' limit 1 [ RunTime:0.011491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535th' OR `brand` LIKE 'flambeau%' ) ) LIMIT 1 [ RunTime:0.012720s ]
SELECT `id` FROM `stock` WHERE `id` <> 32185680 AND `partno` = '6535th' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau%' ) [ RunTime:0.035462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218624 [ RunTime:0.026854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035956 [ RunTime:0.009140s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64158313 LIMIT 5 [ RunTime:0.022005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158313 ORDER BY `minOrder` ASC [ RunTime:0.022973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64158313 ORDER BY `unit` DESC [ RunTime:0.023162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64158313 LIMIT 2 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158313 ORDER BY `minOrder` ASC [ RunTime:0.005656s ]
select * from pdf where partno='6535BP46A1180001E' and brandshort='Johanson Technology Inc.' limit 1 [ RunTime:0.013093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535BP46A1180001E' OR `brand` LIKE 'Johanson Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.016192s ]
SELECT `id` FROM `stock` WHERE `id` <> 64158313 AND `partno` = '6535BP46A1180001E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%johanson technology inc.%' ) [ RunTime:0.003596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423364 LIMIT 5 [ RunTime:0.043611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423364 ORDER BY `minOrder` ASC [ RunTime:0.054915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423364 ORDER BY `unit` DESC [ RunTime:0.031408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423364 LIMIT 2 [ RunTime:0.010524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423364 ORDER BY `minOrder` ASC [ RunTime:0.009249s ]
select * from pdf where partno='6535TH' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.027815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535TH' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.029432s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423364 AND `partno` = '6535TH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.020222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035956 [ RunTime:0.028551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64810784 LIMIT 5 [ RunTime:0.020724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810784 ORDER BY `minOrder` ASC [ RunTime:0.024570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64810784 ORDER BY `unit` DESC [ RunTime:0.019998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64810784 LIMIT 2 [ RunTime:0.018305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810784 ORDER BY `minOrder` ASC [ RunTime:0.020662s ]
select * from pdf where partno='653593-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.022483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653593-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.047102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527613 LIMIT 5 [ RunTime:0.023337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527613 ORDER BY `minOrder` ASC [ RunTime:0.028407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527613 ORDER BY `unit` DESC [ RunTime:0.020987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527613 LIMIT 2 [ RunTime:0.048552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527613 ORDER BY `minOrder` ASC [ RunTime:0.023439s ]
select * from pdf where partno='653595-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.023410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653595-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.044707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58537878 LIMIT 5 [ RunTime:0.052282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58537878 ORDER BY `minOrder` ASC [ RunTime:0.054053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58537878 ORDER BY `unit` DESC [ RunTime:0.044827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58537878 LIMIT 2 [ RunTime:0.035636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58537878 ORDER BY `minOrder` ASC [ RunTime:0.008995s ]
select * from pdf where partno='653594-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.026128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653594-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.053057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811079 LIMIT 5 [ RunTime:0.026706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811079 ORDER BY `minOrder` ASC [ RunTime:0.051300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811079 ORDER BY `unit` DESC [ RunTime:0.019613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811079 LIMIT 2 [ RunTime:0.022925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811079 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
select * from pdf where partno='6535.000.00' and brandshort='FEIG Electronic' limit 1 [ RunTime:0.019673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535.000.00' OR `brand` LIKE 'FEIG Electronic%' ) ) LIMIT 1 [ RunTime:0.005404s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811079 AND `partno` = '6535.000.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%feig electronic%' ) [ RunTime:0.017810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983428 [ RunTime:0.015987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521732 LIMIT 5 [ RunTime:0.017334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521732 ORDER BY `minOrder` ASC [ RunTime:0.008966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521732 ORDER BY `unit` DESC [ RunTime:0.001986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521732 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521732 ORDER BY `minOrder` ASC [ RunTime:0.004027s ]
select * from pdf where partno='65359' and brandshort='Brady Corporation' limit 1 [ RunTime:0.022246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '65359' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007271s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521732 AND `partno` = '65359' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458558 [ RunTime:0.011171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521730 LIMIT 5 [ RunTime:0.007541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521730 ORDER BY `minOrder` ASC [ RunTime:0.030489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521730 ORDER BY `unit` DESC [ RunTime:0.011092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521730 LIMIT 2 [ RunTime:0.016668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521730 ORDER BY `minOrder` ASC [ RunTime:0.010800s ]
select * from pdf where partno='65357' and brandshort='Brady Corporation' limit 1 [ RunTime:0.037788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '65357' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020859s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521730 AND `partno` = '65357' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.028280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458556 [ RunTime:0.047063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521643 LIMIT 5 [ RunTime:0.016858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521643 ORDER BY `minOrder` ASC [ RunTime:0.032726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521643 ORDER BY `unit` DESC [ RunTime:0.026299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521643 LIMIT 2 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521643 ORDER BY `minOrder` ASC [ RunTime:0.003981s ]
select * from pdf where partno='65358' and brandshort='Brady Corporation' limit 1 [ RunTime:0.031259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '65358' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.012683s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521643 AND `partno` = '65358' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345074 [ RunTime:0.025185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521439 LIMIT 5 [ RunTime:0.017753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521439 ORDER BY `minOrder` ASC [ RunTime:0.015293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521439 ORDER BY `unit` DESC [ RunTime:0.026564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521439 LIMIT 2 [ RunTime:0.034169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521439 ORDER BY `minOrder` ASC [ RunTime:0.022551s ]
select * from pdf where partno='65350' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '65350' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022723s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521439 AND `partno` = '65350' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.056360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458417 [ RunTime:0.024107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64438379 LIMIT 5 [ RunTime:0.012566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64438379 ORDER BY `minOrder` ASC [ RunTime:0.035121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64438379 ORDER BY `unit` DESC [ RunTime:0.019731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64438379 LIMIT 2 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64438379 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
select * from pdf where partno='65351' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.017620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '65351' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.036348s ]
SELECT `id` FROM `stock` WHERE `id` <> 64438379 AND `partno` = '65351' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.084587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140272 [ RunTime:0.021034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63454491 LIMIT 5 [ RunTime:0.008180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63454491 ORDER BY `minOrder` ASC [ RunTime:0.034555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63454491 ORDER BY `unit` DESC [ RunTime:0.005876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63454491 LIMIT 2 [ RunTime:0.024190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63454491 ORDER BY `minOrder` ASC [ RunTime:0.042674s ]
select * from pdf where partno='65356' and brandshort='Weidmüller' limit 1 [ RunTime:0.027718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '65356' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.064272s ]
SELECT `id` FROM `stock` WHERE `id` <> 63454491 AND `partno` = '65356' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.051297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17051450 [ RunTime:0.060008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63415272 LIMIT 5 [ RunTime:0.033232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415272 ORDER BY `minOrder` ASC [ RunTime:0.035124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63415272 ORDER BY `unit` DESC [ RunTime:0.006729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63415272 LIMIT 2 [ RunTime:0.022196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415272 ORDER BY `minOrder` ASC [ RunTime:0.007356s ]
select * from pdf where partno='6535-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.070446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.025591s ]
SELECT `id` FROM `stock` WHERE `id` <> 63415272 AND `partno` = '6535-BLACK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.057134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63415040 LIMIT 5 [ RunTime:0.031232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415040 ORDER BY `minOrder` ASC [ RunTime:0.043265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63415040 ORDER BY `unit` DESC [ RunTime:0.050998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63415040 LIMIT 2 [ RunTime:0.035345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415040 ORDER BY `minOrder` ASC [ RunTime:0.016425s ]
select * from pdf where partno='6535' and brandshort='80/20, LLC' limit 1 [ RunTime:0.010384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6535' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.043480s ]
SELECT `id` FROM `stock` WHERE `id` <> 63415040 AND `partno` = '6535' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.066918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44040866 LIMIT 5 [ RunTime:0.036121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44040866 ORDER BY `minOrder` ASC [ RunTime:0.061707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44040866 ORDER BY `unit` DESC [ RunTime:0.016971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44040866 LIMIT 2 [ RunTime:0.018274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44040866 ORDER BY `minOrder` ASC [ RunTime:0.026918s ]
select * from pdf where partno='653522-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.007563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653522-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.007795s ]
SELECT `id` FROM `stock` WHERE `id` <> 44040866 AND `partno` = '653522-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.012949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216197 [ RunTime:0.059386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44034732 LIMIT 5 [ RunTime:0.027566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034732 ORDER BY `minOrder` ASC [ RunTime:0.053241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44034732 ORDER BY `unit` DESC [ RunTime:0.030263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44034732 LIMIT 2 [ RunTime:0.028149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034732 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
select * from pdf where partno='653575-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.002549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653575-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.009953s ]
SELECT `id` FROM `stock` WHERE `id` <> 44034732 AND `partno` = '653575-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.039085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18746053 [ RunTime:0.013988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44034458 LIMIT 5 [ RunTime:0.008997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034458 ORDER BY `minOrder` ASC [ RunTime:0.027498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44034458 ORDER BY `unit` DESC [ RunTime:0.003002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44034458 LIMIT 2 [ RunTime:0.006775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034458 ORDER BY `minOrder` ASC [ RunTime:0.008600s ]
select * from pdf where partno='653575-4' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.024712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653575-4' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002431s ]
SELECT `id` FROM `stock` WHERE `id` <> 44034458 AND `partno` = '653575-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.002331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003865 [ RunTime:0.011217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44033472 LIMIT 5 [ RunTime:0.013453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44033472 ORDER BY `minOrder` ASC [ RunTime:0.019317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44033472 ORDER BY `unit` DESC [ RunTime:0.006291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44033472 LIMIT 2 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44033472 ORDER BY `minOrder` ASC [ RunTime:0.010790s ]
select * from pdf where partno='653572-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.019341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653572-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.027310s ]
SELECT `id` FROM `stock` WHERE `id` <> 44033472 AND `partno` = '653572-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.025219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14174991 [ RunTime:0.014951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44033286 LIMIT 5 [ RunTime:0.013443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44033286 ORDER BY `minOrder` ASC [ RunTime:0.018419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44033286 ORDER BY `unit` DESC [ RunTime:0.019108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44033286 LIMIT 2 [ RunTime:0.014526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44033286 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
select * from pdf where partno='653598-5' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.015923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653598-5' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.011214s ]
SELECT `id` FROM `stock` WHERE `id` <> 44033286 AND `partno` = '653598-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.005621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003692 [ RunTime:0.005328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44032876 LIMIT 5 [ RunTime:0.008736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032876 ORDER BY `minOrder` ASC [ RunTime:0.011086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44032876 ORDER BY `unit` DESC [ RunTime:0.002994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44032876 LIMIT 2 [ RunTime:0.023439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032876 ORDER BY `minOrder` ASC [ RunTime:0.004134s ]
select * from pdf where partno='653593-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.003940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '653593-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.007465s ]
SELECT `id` FROM `stock` WHERE `id` <> 44032876 AND `partno` = '653593-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.012154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14175221 [ RunTime:0.018058s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014594s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008846s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010229s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021833s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025443s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013693s ]
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 '6535%' OR `brand` LIKE '6535%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021434s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6535%' OR `brand` LIKE '6535%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022289s ]