SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003251s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=M4L-3-3&search=1' [ RunTime:0.002419s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002097s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002353s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.001355s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002246s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002834s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002517s ]
SELECT * FROM `stock_search` WHERE `partno` = 'M4L-3-3' LIMIT 1 [ RunTime:0.001847s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-11 20:02:40' WHERE `partno` = 'M4L-3-3' [ RunTime:0.001760s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002856s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031002s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468586 LIMIT 5 [ RunTime:0.022797s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468586 ORDER BY `minOrder` ASC [ RunTime:0.025479s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12468586 ORDER BY `unit` DESC [ RunTime:0.012101s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12468586 LIMIT 2 [ RunTime:0.051861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468586 ORDER BY `minOrder` ASC [ RunTime:0.005184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468534 LIMIT 5 [ RunTime:0.014111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468534 ORDER BY `minOrder` ASC [ RunTime:0.031492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12468534 ORDER BY `unit` DESC [ RunTime:0.006096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12468534 LIMIT 2 [ RunTime:0.040691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468534 ORDER BY `minOrder` ASC [ RunTime:0.032828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468531 LIMIT 5 [ RunTime:0.031644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468531 ORDER BY `minOrder` ASC [ RunTime:0.085438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12468531 ORDER BY `unit` DESC [ RunTime:0.048517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12468531 LIMIT 2 [ RunTime:0.047548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468531 ORDER BY `minOrder` ASC [ RunTime:0.018195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468530 LIMIT 5 [ RunTime:0.050870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468530 ORDER BY `minOrder` ASC [ RunTime:0.039915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12468530 ORDER BY `unit` DESC [ RunTime:0.084654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12468530 LIMIT 2 [ RunTime:0.046014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468530 ORDER BY `minOrder` ASC [ RunTime:0.011805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378753 LIMIT 5 [ RunTime:0.032083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378753 ORDER BY `minOrder` ASC [ RunTime:0.027544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11378753 ORDER BY `unit` DESC [ RunTime:0.040697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11378753 LIMIT 2 [ RunTime:0.026476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378753 ORDER BY `minOrder` ASC [ RunTime:0.040183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378749 LIMIT 5 [ RunTime:0.032654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378749 ORDER BY `minOrder` ASC [ RunTime:0.031682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11378749 ORDER BY `unit` DESC [ RunTime:0.003991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11378749 LIMIT 2 [ RunTime:0.036700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378749 ORDER BY `minOrder` ASC [ RunTime:0.027987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378748 LIMIT 5 [ RunTime:0.017038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378748 ORDER BY `minOrder` ASC [ RunTime:0.048495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11378748 ORDER BY `unit` DESC [ RunTime:0.013178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11378748 LIMIT 2 [ RunTime:0.016525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378748 ORDER BY `minOrder` ASC [ RunTime:0.010937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378746 LIMIT 5 [ RunTime:0.010779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378746 ORDER BY `minOrder` ASC [ RunTime:0.021207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11378746 ORDER BY `unit` DESC [ RunTime:0.010223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11378746 LIMIT 2 [ RunTime:0.035703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378746 ORDER BY `minOrder` ASC [ RunTime:0.008823s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002321s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265460 LIMIT 5 [ RunTime:0.004435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265460 ORDER BY `minOrder` ASC [ RunTime:0.006347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265460 ORDER BY `unit` DESC [ RunTime:0.004564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265460 LIMIT 2 [ RunTime:0.006663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265460 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
select * from pdf where partno='M4L-3-3' and brandshort='Signal Transformer' limit 1 [ RunTime:0.001947s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.005538s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265460 AND `partno` = 'M4L-3-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.003726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468586 [ RunTime:0.003008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265348 LIMIT 5 [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265348 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265348 ORDER BY `unit` DESC [ RunTime:0.003470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265348 LIMIT 2 [ RunTime:0.008624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265348 ORDER BY `minOrder` ASC [ RunTime:0.010751s ]
select * from pdf where partno='M4L-3-3-115' and brandshort='Signal Transformer' limit 1 [ RunTime:0.003438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-115' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.001050s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265348 AND `partno` = 'M4L-3-3-115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265347 LIMIT 5 [ RunTime:0.008987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265347 ORDER BY `minOrder` ASC [ RunTime:0.014773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265347 ORDER BY `unit` DESC [ RunTime:0.034678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265347 LIMIT 2 [ RunTime:0.010871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265347 ORDER BY `minOrder` ASC [ RunTime:0.007888s ]
select * from pdf where partno='M4L-3-3-230' and brandshort='Signal Transformer' limit 1 [ RunTime:0.001174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-230' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.011473s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265347 AND `partno` = 'M4L-3-3-230' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.023230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378753 [ RunTime:0.022125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265346 LIMIT 5 [ RunTime:0.001271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265346 ORDER BY `minOrder` ASC [ RunTime:0.005176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265346 ORDER BY `unit` DESC [ RunTime:0.023503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265346 LIMIT 2 [ RunTime:0.019637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265346 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
select * from pdf where partno='M4L-3-3-40' and brandshort='Signal Transformer' limit 1 [ RunTime:0.011627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-40' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.021918s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265346 AND `partno` = 'M4L-3-3-40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.008352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468534 [ RunTime:0.005409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265344 LIMIT 5 [ RunTime:0.010976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265344 ORDER BY `minOrder` ASC [ RunTime:0.022500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265344 ORDER BY `unit` DESC [ RunTime:0.009173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265344 LIMIT 2 [ RunTime:0.008231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265344 ORDER BY `minOrder` ASC [ RunTime:0.006142s ]
select * from pdf where partno='M4L-3-3-36' and brandshort='Signal Transformer' limit 1 [ RunTime:0.010110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-36' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.008151s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265344 AND `partno` = 'M4L-3-3-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.003420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468531 [ RunTime:0.031791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265342 LIMIT 5 [ RunTime:0.024986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265342 ORDER BY `minOrder` ASC [ RunTime:0.020005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265342 ORDER BY `unit` DESC [ RunTime:0.005188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265342 LIMIT 2 [ RunTime:0.026482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265342 ORDER BY `minOrder` ASC [ RunTime:0.002123s ]
select * from pdf where partno='M4L-3-3-20' and brandshort='Signal Transformer' limit 1 [ RunTime:0.007429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-20' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.003461s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265342 AND `partno` = 'M4L-3-3-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.009493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468530 [ RunTime:0.007985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265341 LIMIT 5 [ RunTime:0.013111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265341 ORDER BY `minOrder` ASC [ RunTime:0.029198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265341 ORDER BY `unit` DESC [ RunTime:0.011907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265341 LIMIT 2 [ RunTime:0.011336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265341 ORDER BY `minOrder` ASC [ RunTime:0.003721s ]
select * from pdf where partno='M4L-3-3-32' and brandshort='Signal Transformer' limit 1 [ RunTime:0.004934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-32' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.012974s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265341 AND `partno` = 'M4L-3-3-32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.009988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378749 [ RunTime:0.008081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265340 LIMIT 5 [ RunTime:0.012455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265340 ORDER BY `minOrder` ASC [ RunTime:0.019826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265340 ORDER BY `unit` DESC [ RunTime:0.013893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265340 LIMIT 2 [ RunTime:0.019821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265340 ORDER BY `minOrder` ASC [ RunTime:0.004914s ]
select * from pdf where partno='M4L-3-3-16' and brandshort='Signal Transformer' limit 1 [ RunTime:0.002878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-16' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.004819s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265340 AND `partno` = 'M4L-3-3-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.012744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378748 [ RunTime:0.001597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265338 LIMIT 5 [ RunTime:0.003356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265338 ORDER BY `minOrder` ASC [ RunTime:0.009959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265338 ORDER BY `unit` DESC [ RunTime:0.004571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265338 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265338 ORDER BY `minOrder` ASC [ RunTime:0.004619s ]
select * from pdf where partno='M4L-3-3-24' and brandshort='Signal Transformer' limit 1 [ RunTime:0.004171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-24' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.009609s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265338 AND `partno` = 'M4L-3-3-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.017113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265336 LIMIT 5 [ RunTime:0.006662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265336 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265336 ORDER BY `unit` DESC [ RunTime:0.015561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265336 LIMIT 2 [ RunTime:0.009716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265336 ORDER BY `minOrder` ASC [ RunTime:0.006442s ]
select * from pdf where partno='M4L-3-3-28' and brandshort='Signal Transformer' limit 1 [ RunTime:0.006063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-28' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.008790s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265336 AND `partno` = 'M4L-3-3-28' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.004929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58265334 LIMIT 5 [ RunTime:0.002785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265334 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58265334 ORDER BY `unit` DESC [ RunTime:0.022926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58265334 LIMIT 2 [ RunTime:0.002178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58265334 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
select * from pdf where partno='M4L-3-3-48' and brandshort='Signal Transformer' limit 1 [ RunTime:0.012742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M4L-3-3-48' OR `brand` LIKE 'Signal Transformer%' ) ) LIMIT 1 [ RunTime:0.015608s ]
SELECT `id` FROM `stock` WHERE `id` <> 58265334 AND `partno` = 'M4L-3-3-48' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%signal transformer%' ) [ RunTime:0.030314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378746 [ RunTime:0.011419s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041113s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024728s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029709s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052261s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025662s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033761s ]
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 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050341s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'M4L-3-3%' OR `brand` LIKE 'M4L-3-3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.043172s ]