SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001451s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.251' , `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=4661&search=1' [ RunTime:0.003644s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001419s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001709s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.251' ) [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001655s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002008s ]
SELECT * FROM `stock_search` WHERE `partno` = '4661' LIMIT 1 [ RunTime:0.001047s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-30 20:42:20' WHERE `partno` = '4661' [ RunTime:0.001547s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001117s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005222s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148159 LIMIT 5 [ RunTime:0.000786s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148159 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12148159 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12148159 LIMIT 2 [ RunTime:0.003361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148159 ORDER BY `minOrder` ASC [ RunTime:0.001584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258595 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258595 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258595 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258595 LIMIT 2 [ RunTime:0.001052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258595 ORDER BY `minOrder` ASC [ RunTime:0.000180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880959 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880959 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880959 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880959 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880959 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18728479 LIMIT 5 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18728479 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18728479 ORDER BY `unit` DESC [ RunTime:0.002289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18728479 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18728479 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727163 LIMIT 5 [ RunTime:0.001315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727163 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727163 ORDER BY `unit` DESC [ RunTime:0.006505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727163 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727163 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727160 LIMIT 5 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727160 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727160 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727160 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727160 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727157 LIMIT 5 [ RunTime:0.004335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727157 ORDER BY `minOrder` ASC [ RunTime:0.008531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727157 ORDER BY `unit` DESC [ RunTime:0.007094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727157 LIMIT 2 [ RunTime:0.026988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727157 ORDER BY `minOrder` ASC [ RunTime:0.006597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727154 LIMIT 5 [ RunTime:0.030789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727154 ORDER BY `minOrder` ASC [ RunTime:0.033106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727154 ORDER BY `unit` DESC [ RunTime:0.043377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727154 LIMIT 2 [ RunTime:0.021178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727154 ORDER BY `minOrder` ASC [ RunTime:0.006168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727145 LIMIT 5 [ RunTime:0.014071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727145 ORDER BY `minOrder` ASC [ RunTime:0.021656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727145 ORDER BY `unit` DESC [ RunTime:0.031749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727145 LIMIT 2 [ RunTime:0.064219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727145 ORDER BY `minOrder` ASC [ RunTime:0.033789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727125 LIMIT 5 [ RunTime:0.042050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727125 ORDER BY `minOrder` ASC [ RunTime:0.016551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727125 ORDER BY `unit` DESC [ RunTime:0.040477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727125 LIMIT 2 [ RunTime:0.024900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727125 ORDER BY `minOrder` ASC [ RunTime:0.005603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720270 LIMIT 5 [ RunTime:0.042360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720270 ORDER BY `minOrder` ASC [ RunTime:0.021624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720270 ORDER BY `unit` DESC [ RunTime:0.027912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720270 LIMIT 2 [ RunTime:0.047034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720270 ORDER BY `minOrder` ASC [ RunTime:0.036927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719580 LIMIT 5 [ RunTime:0.035823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719580 ORDER BY `minOrder` ASC [ RunTime:0.013686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719580 ORDER BY `unit` DESC [ RunTime:0.046589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719580 LIMIT 2 [ RunTime:0.035932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719580 ORDER BY `minOrder` ASC [ RunTime:0.013503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719579 LIMIT 5 [ RunTime:0.014468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719579 ORDER BY `minOrder` ASC [ RunTime:0.019349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719579 ORDER BY `unit` DESC [ RunTime:0.005687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719579 LIMIT 2 [ RunTime:0.017962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719579 ORDER BY `minOrder` ASC [ RunTime:0.017671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17488527 LIMIT 5 [ RunTime:0.052715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488527 ORDER BY `minOrder` ASC [ RunTime:0.033701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17488527 ORDER BY `unit` DESC [ RunTime:0.003815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17488527 LIMIT 2 [ RunTime:0.014726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488527 ORDER BY `minOrder` ASC [ RunTime:0.003152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16998113 LIMIT 5 [ RunTime:0.003889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16998113 ORDER BY `minOrder` ASC [ RunTime:0.021171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16998113 ORDER BY `unit` DESC [ RunTime:0.012951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16998113 LIMIT 2 [ RunTime:0.020953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16998113 ORDER BY `minOrder` ASC [ RunTime:0.025017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212384 LIMIT 5 [ RunTime:0.058753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212384 ORDER BY `minOrder` ASC [ RunTime:0.011776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212384 ORDER BY `unit` DESC [ RunTime:0.010648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212384 LIMIT 2 [ RunTime:0.011888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212384 ORDER BY `minOrder` ASC [ RunTime:0.014692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212383 LIMIT 5 [ RunTime:0.023458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212383 ORDER BY `minOrder` ASC [ RunTime:0.013138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212383 ORDER BY `unit` DESC [ RunTime:0.011167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212383 LIMIT 2 [ RunTime:0.015384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212383 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212382 LIMIT 5 [ RunTime:0.003681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212382 ORDER BY `minOrder` ASC [ RunTime:0.015809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212382 ORDER BY `unit` DESC [ RunTime:0.009161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212382 LIMIT 2 [ RunTime:0.009866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212382 ORDER BY `minOrder` ASC [ RunTime:0.011292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210771 LIMIT 5 [ RunTime:0.026166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210771 ORDER BY `minOrder` ASC [ RunTime:0.022130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210771 ORDER BY `unit` DESC [ RunTime:0.004362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210771 LIMIT 2 [ RunTime:0.013157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210771 ORDER BY `minOrder` ASC [ RunTime:0.022344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210583 LIMIT 5 [ RunTime:0.021044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210583 ORDER BY `minOrder` ASC [ RunTime:0.039107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210583 ORDER BY `unit` DESC [ RunTime:0.020813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210583 LIMIT 2 [ RunTime:0.026263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210583 ORDER BY `minOrder` ASC [ RunTime:0.013645s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019388s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51633727 LIMIT 5 [ RunTime:0.037196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51633727 ORDER BY `minOrder` ASC [ RunTime:0.018830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51633727 ORDER BY `unit` DESC [ RunTime:0.022074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51633727 LIMIT 2 [ RunTime:0.013914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51633727 ORDER BY `minOrder` ASC [ RunTime:0.023473s ]
select * from pdf where partno='4661' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.026955s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4661' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.036253s ]
SELECT `id` FROM `stock` WHERE `id` <> 51633727 AND `partno` = '4661' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.024362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148159 [ RunTime:0.021249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57607760 LIMIT 5 [ RunTime:0.045580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57607760 ORDER BY `minOrder` ASC [ RunTime:0.017212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57607760 ORDER BY `unit` DESC [ RunTime:0.008138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57607760 LIMIT 2 [ RunTime:0.002570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57607760 ORDER BY `minOrder` ASC [ RunTime:0.009118s ]
select * from pdf where partno='4661' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.018624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4661' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.021682s ]
SELECT `id` FROM `stock` WHERE `id` <> 57607760 AND `partno` = '4661' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.012503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258595 [ RunTime:0.015703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56585613 LIMIT 5 [ RunTime:0.032137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56585613 ORDER BY `minOrder` ASC [ RunTime:0.012207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56585613 ORDER BY `unit` DESC [ RunTime:0.030087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56585613 LIMIT 2 [ RunTime:0.012926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56585613 ORDER BY `minOrder` ASC [ RunTime:0.011393s ]
select * from pdf where partno='4661-1032-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.023264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4661-1032-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.013807s ]
SELECT `id` FROM `stock` WHERE `id` <> 56585613 AND `partno` = '4661-1032-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.025760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55095049 LIMIT 5 [ RunTime:0.034713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55095049 ORDER BY `minOrder` ASC [ RunTime:0.014044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55095049 ORDER BY `unit` DESC [ RunTime:0.020711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55095049 LIMIT 2 [ RunTime:0.016077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55095049 ORDER BY `minOrder` ASC [ RunTime:0.021614s ]
select * from pdf where partno='4661' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.014028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4661' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.021904s ]
SELECT `id` FROM `stock` WHERE `id` <> 55095049 AND `partno` = '4661' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.024468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880959 [ RunTime:0.031710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57712577 LIMIT 5 [ RunTime:0.043769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712577 ORDER BY `minOrder` ASC [ RunTime:0.010524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57712577 ORDER BY `unit` DESC [ RunTime:0.037853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57712577 LIMIT 2 [ RunTime:0.015133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57712577 ORDER BY `minOrder` ASC [ RunTime:0.004839s ]
select * from pdf where partno='46619' and brandshort='Brady Corporation' limit 1 [ RunTime:0.029165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46619' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016630s ]
SELECT `id` FROM `stock` WHERE `id` <> 57712577 AND `partno` = '46619' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.078698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555654 [ RunTime:0.050729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55358580 LIMIT 5 [ RunTime:0.027373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55358580 ORDER BY `minOrder` ASC [ RunTime:0.042249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55358580 ORDER BY `unit` DESC [ RunTime:0.023600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55358580 LIMIT 2 [ RunTime:0.029572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55358580 ORDER BY `minOrder` ASC [ RunTime:0.032942s ]
select * from pdf where partno='46613' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.021435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46613' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.036926s ]
SELECT `id` FROM `stock` WHERE `id` <> 55358580 AND `partno` = '46613' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.014359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17488527 [ RunTime:0.025281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53801699 LIMIT 5 [ RunTime:0.024885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53801699 ORDER BY `minOrder` ASC [ RunTime:0.019698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53801699 ORDER BY `unit` DESC [ RunTime:0.067210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53801699 LIMIT 2 [ RunTime:0.061242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53801699 ORDER BY `minOrder` ASC [ RunTime:0.012222s ]
select * from pdf where partno='4661.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.008732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4661.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.017661s ]
SELECT `id` FROM `stock` WHERE `id` <> 53801699 AND `partno` = '4661.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.032516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51674052 LIMIT 5 [ RunTime:0.032527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674052 ORDER BY `minOrder` ASC [ RunTime:0.020451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51674052 ORDER BY `unit` DESC [ RunTime:0.018756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51674052 LIMIT 2 [ RunTime:0.047677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674052 ORDER BY `minOrder` ASC [ RunTime:0.011910s ]
select * from pdf where partno='466173-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.031005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466173-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.030055s ]
SELECT `id` FROM `stock` WHERE `id` <> 51674052 AND `partno` = '466173-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.019110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673998 LIMIT 5 [ RunTime:0.035255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673998 ORDER BY `minOrder` ASC [ RunTime:0.046015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673998 ORDER BY `unit` DESC [ RunTime:0.010192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673998 LIMIT 2 [ RunTime:0.014992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673998 ORDER BY `minOrder` ASC [ RunTime:0.009043s ]
select * from pdf where partno='466173-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.019643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466173-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.031351s ]
SELECT `id` FROM `stock` WHERE `id` <> 51673998 AND `partno` = '466173-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.023624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51673997 LIMIT 5 [ RunTime:0.027053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673997 ORDER BY `minOrder` ASC [ RunTime:0.016596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51673997 ORDER BY `unit` DESC [ RunTime:0.013440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51673997 LIMIT 2 [ RunTime:0.012499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51673997 ORDER BY `minOrder` ASC [ RunTime:0.001270s ]
select * from pdf where partno='466173-3' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.009364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466173-3' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.015943s ]
SELECT `id` FROM `stock` WHERE `id` <> 51673997 AND `partno` = '466173-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.044860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667740 LIMIT 5 [ RunTime:0.043882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667740 ORDER BY `minOrder` ASC [ RunTime:0.028016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667740 ORDER BY `unit` DESC [ RunTime:0.046920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667740 LIMIT 2 [ RunTime:0.036435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667740 ORDER BY `minOrder` ASC [ RunTime:0.015567s ]
select * from pdf where partno='466168-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.006631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466168-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.011537s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667740 AND `partno` = '466168-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.052568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667416 LIMIT 5 [ RunTime:0.056132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667416 ORDER BY `minOrder` ASC [ RunTime:0.045825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667416 ORDER BY `unit` DESC [ RunTime:0.024558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667416 LIMIT 2 [ RunTime:0.046989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667416 ORDER BY `minOrder` ASC [ RunTime:0.025490s ]
select * from pdf where partno='466154-8' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.006128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466154-8' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.031494s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667416 AND `partno` = '466154-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.046050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667413 LIMIT 5 [ RunTime:0.039904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667413 ORDER BY `minOrder` ASC [ RunTime:0.052087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667413 ORDER BY `unit` DESC [ RunTime:0.055213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667413 LIMIT 2 [ RunTime:0.049050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667413 ORDER BY `minOrder` ASC [ RunTime:0.006661s ]
select * from pdf where partno='466154-6' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.042236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466154-6' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.048764s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667413 AND `partno` = '466154-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.035915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667410 LIMIT 5 [ RunTime:0.075498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667410 ORDER BY `minOrder` ASC [ RunTime:0.046211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667410 ORDER BY `unit` DESC [ RunTime:0.055922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667410 LIMIT 2 [ RunTime:0.019179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667410 ORDER BY `minOrder` ASC [ RunTime:0.025963s ]
select * from pdf where partno='466154-7' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.037760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466154-7' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.033009s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667410 AND `partno` = '466154-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.020666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667407 LIMIT 5 [ RunTime:0.044818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667407 ORDER BY `minOrder` ASC [ RunTime:0.037091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667407 ORDER BY `unit` DESC [ RunTime:0.003386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667407 LIMIT 2 [ RunTime:0.046353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667407 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
select * from pdf where partno='466145-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.057526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466145-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.038950s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667407 AND `partno` = '466145-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.086213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667398 LIMIT 5 [ RunTime:0.066359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667398 ORDER BY `minOrder` ASC [ RunTime:0.041728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667398 ORDER BY `unit` DESC [ RunTime:0.046581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667398 LIMIT 2 [ RunTime:0.027397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667398 ORDER BY `minOrder` ASC [ RunTime:0.033184s ]
select * from pdf where partno='466145-3' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.054513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466145-3' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.040689s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667398 AND `partno` = '466145-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.023008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667396 LIMIT 5 [ RunTime:0.043385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667396 ORDER BY `minOrder` ASC [ RunTime:0.042775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667396 ORDER BY `unit` DESC [ RunTime:0.131931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667396 LIMIT 2 [ RunTime:0.064784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667396 ORDER BY `minOrder` ASC [ RunTime:0.045701s ]
select * from pdf where partno='466145-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.050971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466145-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.040510s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667396 AND `partno` = '466145-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.095349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667395 LIMIT 5 [ RunTime:0.041996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667395 ORDER BY `minOrder` ASC [ RunTime:0.023132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667395 ORDER BY `unit` DESC [ RunTime:0.073907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667395 LIMIT 2 [ RunTime:0.017130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667395 ORDER BY `minOrder` ASC [ RunTime:0.036058s ]
select * from pdf where partno='466154-5' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.047516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466154-5' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.044083s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667395 AND `partno` = '466154-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.046740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51667394 LIMIT 5 [ RunTime:0.045936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667394 ORDER BY `minOrder` ASC [ RunTime:0.043528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51667394 ORDER BY `unit` DESC [ RunTime:0.040411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51667394 LIMIT 2 [ RunTime:0.028875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51667394 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
select * from pdf where partno='466193-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.020316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466193-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.007466s ]
SELECT `id` FROM `stock` WHERE `id` <> 51667394 AND `partno` = '466193-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.040857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49542898 LIMIT 5 [ RunTime:0.027863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49542898 ORDER BY `minOrder` ASC [ RunTime:0.029166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49542898 ORDER BY `unit` DESC [ RunTime:0.018370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49542898 LIMIT 2 [ RunTime:0.025730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49542898 ORDER BY `minOrder` ASC [ RunTime:0.022547s ]
select * from pdf where partno='466198' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.018793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '466198' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.014702s ]
SELECT `id` FROM `stock` WHERE `id` <> 49542898 AND `partno` = '466198' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.052122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36736281 [ RunTime:0.037899s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061085s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057262s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036106s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.137549s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069123s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063686s ]
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 '4661%' OR `brand` LIKE '4661%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053138s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4661%' OR `brand` LIKE '4661%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.036042s ]