SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001949s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=Z20-20&search=1' [ RunTime:0.003334s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001214s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000557s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001688s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001831s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003172s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001431s ]
SELECT * FROM `stock_search` WHERE `partno` = 'Z20-20' LIMIT 1 [ RunTime:0.011871s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 03:45:01' WHERE `partno` = 'Z20-20' [ RunTime:0.004045s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002584s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012831s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986767 LIMIT 5 [ RunTime:0.005761s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13986767 ORDER BY `minOrder` ASC [ RunTime:0.009693s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13986767 ORDER BY `unit` DESC [ RunTime:0.007597s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13986767 LIMIT 2 [ RunTime:0.016691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13986767 ORDER BY `minOrder` ASC [ RunTime:0.045130s ]
select * from pdf where partno='Z20-20-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.018109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909642 LIMIT 5 [ RunTime:0.020628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909642 ORDER BY `minOrder` ASC [ RunTime:0.026156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909642 ORDER BY `unit` DESC [ RunTime:0.017198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909642 LIMIT 2 [ RunTime:0.030518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909642 ORDER BY `minOrder` ASC [ RunTime:0.026886s ]
select * from pdf where partno='Z20-20-IEEE-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.010127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909592 LIMIT 5 [ RunTime:0.023291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909592 ORDER BY `minOrder` ASC [ RunTime:0.045986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909592 ORDER BY `unit` DESC [ RunTime:0.062165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909592 LIMIT 2 [ RunTime:0.030299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909592 ORDER BY `minOrder` ASC [ RunTime:0.011899s ]
select * from pdf where partno='Z20-20-LAN-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.011012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909889 LIMIT 5 [ RunTime:0.052722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909889 ORDER BY `minOrder` ASC [ RunTime:0.056526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909889 ORDER BY `unit` DESC [ RunTime:0.032723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909889 LIMIT 2 [ RunTime:0.070139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909889 ORDER BY `minOrder` ASC [ RunTime:0.035399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909801 LIMIT 5 [ RunTime:0.045866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909801 ORDER BY `minOrder` ASC [ RunTime:0.030482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909801 ORDER BY `unit` DESC [ RunTime:0.029625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909801 LIMIT 2 [ RunTime:0.031118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909801 ORDER BY `minOrder` ASC [ RunTime:0.006987s ]
select * from pdf where partno='Z20-20-LAN-L-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.019200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909774 LIMIT 5 [ RunTime:0.012834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909774 ORDER BY `minOrder` ASC [ RunTime:0.027055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909774 ORDER BY `unit` DESC [ RunTime:0.021596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909774 LIMIT 2 [ RunTime:0.006858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909774 ORDER BY `minOrder` ASC [ RunTime:0.003590s ]
select * from pdf where partno='Z20-20-IS420-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.014262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909773 LIMIT 5 [ RunTime:0.016235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909773 ORDER BY `minOrder` ASC [ RunTime:0.018829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909773 ORDER BY `unit` DESC [ RunTime:0.018192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909773 LIMIT 2 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909773 ORDER BY `minOrder` ASC [ RunTime:0.013109s ]
select * from pdf where partno='Z20-20-IS510-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.011165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909764 LIMIT 5 [ RunTime:0.016277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909764 ORDER BY `minOrder` ASC [ RunTime:0.012761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909764 ORDER BY `unit` DESC [ RunTime:0.041826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909764 LIMIT 2 [ RunTime:0.031679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909764 ORDER BY `minOrder` ASC [ RunTime:0.011661s ]
select * from pdf where partno='Z20-20-L-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.018801s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076610 LIMIT 5 [ RunTime:0.001716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076610 ORDER BY `minOrder` ASC [ RunTime:0.018772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076610 ORDER BY `unit` DESC [ RunTime:0.039174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076610 LIMIT 2 [ RunTime:0.034467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076610 ORDER BY `minOrder` ASC [ RunTime:0.006004s ]
select * from pdf where partno='z20-20-u' and brandshort='tdk-lambda' limit 1 [ RunTime:0.017623s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'z20-20-u' OR `brand` LIKE 'tdk-lambda%' ) ) LIMIT 1 [ RunTime:0.009856s ]
SELECT `id` FROM `stock` WHERE `id` <> 51076610 AND `partno` = 'z20-20-u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.032371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986767 [ RunTime:0.004124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283041 LIMIT 5 [ RunTime:0.019114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283041 ORDER BY `minOrder` ASC [ RunTime:0.020185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283041 ORDER BY `unit` DESC [ RunTime:0.036668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283041 LIMIT 2 [ RunTime:0.030731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283041 ORDER BY `minOrder` ASC [ RunTime:0.014817s ]
select * from pdf where partno='z20-20-ieee-u' and brandshort='tdk-lambda' limit 1 [ RunTime:0.018402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'z20-20-ieee-u' OR `brand` LIKE 'tdk-lambda%' ) ) LIMIT 1 [ RunTime:0.054533s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283041 AND `partno` = 'z20-20-ieee-u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.019840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909642 [ RunTime:0.012932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282961 LIMIT 5 [ RunTime:0.017121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282961 ORDER BY `minOrder` ASC [ RunTime:0.031668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282961 ORDER BY `unit` DESC [ RunTime:0.025028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282961 LIMIT 2 [ RunTime:0.008760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282961 ORDER BY `minOrder` ASC [ RunTime:0.007535s ]
select * from pdf where partno='z20-20-lan-u' and brandshort='tdk-lambda' limit 1 [ RunTime:0.018268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'z20-20-lan-u' OR `brand` LIKE 'tdk-lambda%' ) ) LIMIT 1 [ RunTime:0.022583s ]
SELECT `id` FROM `stock` WHERE `id` <> 32282961 AND `partno` = 'z20-20-lan-u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.015989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909592 [ RunTime:0.014649s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523795 LIMIT 5 [ RunTime:0.004004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523795 ORDER BY `minOrder` ASC [ RunTime:0.032116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523795 ORDER BY `unit` DESC [ RunTime:0.023347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523795 LIMIT 2 [ RunTime:0.044281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523795 ORDER BY `minOrder` ASC [ RunTime:0.025917s ]
select * from pdf where partno='Z20-20-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.005857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.017224s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523795 AND `partno` = 'Z20-20-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.017520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986767 [ RunTime:0.004823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523797 LIMIT 5 [ RunTime:0.026706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523797 ORDER BY `minOrder` ASC [ RunTime:0.019301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523797 ORDER BY `unit` DESC [ RunTime:0.006319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523797 LIMIT 2 [ RunTime:0.013418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523797 ORDER BY `minOrder` ASC [ RunTime:0.003269s ]
select * from pdf where partno='Z20-20-LAN-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.011484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-LAN-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.011033s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523797 AND `partno` = 'Z20-20-LAN-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.024491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909592 [ RunTime:0.012096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523937 LIMIT 5 [ RunTime:0.013878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523937 ORDER BY `minOrder` ASC [ RunTime:0.019541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523937 ORDER BY `unit` DESC [ RunTime:0.022608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523937 LIMIT 2 [ RunTime:0.018468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523937 ORDER BY `minOrder` ASC [ RunTime:0.012215s ]
select * from pdf where partno='Z20-20-IEEE-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.010774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-IEEE-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.012408s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523937 AND `partno` = 'Z20-20-IEEE-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.007436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909642 [ RunTime:0.008806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524144 LIMIT 5 [ RunTime:0.011682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524144 ORDER BY `minOrder` ASC [ RunTime:0.024719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524144 ORDER BY `unit` DESC [ RunTime:0.051813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524144 LIMIT 2 [ RunTime:0.051380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524144 ORDER BY `minOrder` ASC [ RunTime:0.010514s ]
select * from pdf where partno='Z20-20-LAN-L-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.003692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-LAN-L-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.026242s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524144 AND `partno` = 'Z20-20-LAN-L-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.023224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909801 [ RunTime:0.015613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524102 LIMIT 5 [ RunTime:0.034559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524102 ORDER BY `minOrder` ASC [ RunTime:0.030299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524102 ORDER BY `unit` DESC [ RunTime:0.010573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524102 LIMIT 2 [ RunTime:0.029382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524102 ORDER BY `minOrder` ASC [ RunTime:0.007798s ]
select * from pdf where partno='Z20-20-IS420-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.009655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-IS420-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.019716s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524102 AND `partno` = 'Z20-20-IS420-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.030087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909774 [ RunTime:0.015998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524101 LIMIT 5 [ RunTime:0.026931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524101 ORDER BY `minOrder` ASC [ RunTime:0.037808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524101 ORDER BY `unit` DESC [ RunTime:0.054348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524101 LIMIT 2 [ RunTime:0.018245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524101 ORDER BY `minOrder` ASC [ RunTime:0.025301s ]
select * from pdf where partno='Z20-20-IS510-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.006380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-IS510-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.023846s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524101 AND `partno` = 'Z20-20-IS510-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.020347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909773 [ RunTime:0.045277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524089 LIMIT 5 [ RunTime:0.022695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524089 ORDER BY `minOrder` ASC [ RunTime:0.013819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524089 ORDER BY `unit` DESC [ RunTime:0.040620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524089 LIMIT 2 [ RunTime:0.033536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524089 ORDER BY `minOrder` ASC [ RunTime:0.014023s ]
select * from pdf where partno='Z20-20-L-U' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.014417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'Z20-20-L-U' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.032910s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524089 AND `partno` = 'Z20-20-L-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.013486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909764 [ RunTime:0.013883s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021834s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035868s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031115s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022766s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009690s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036629s ]
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 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065366s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'Z20-20%' OR `brand` LIKE 'Z20-20%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030469s ]