SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002849s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `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=JT00A-12-8P&search=1' [ RunTime:0.001845s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001534s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001316s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001590s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.001008s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001713s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002847s ]
SELECT * FROM `stock_search` WHERE `partno` = 'JT00A-12-8P' LIMIT 1 [ RunTime:0.022287s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-14 00:11:24' WHERE `partno` = 'JT00A-12-8P' [ RunTime:0.006571s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002793s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019945s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963866 LIMIT 5 [ RunTime:0.021032s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963866 ORDER BY `minOrder` ASC [ RunTime:0.039581s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963866 ORDER BY `unit` DESC [ RunTime:0.025968s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963866 LIMIT 2 [ RunTime:0.002554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963866 ORDER BY `minOrder` ASC [ RunTime:0.011624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963865 LIMIT 5 [ RunTime:0.019075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963865 ORDER BY `minOrder` ASC [ RunTime:0.020276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963865 ORDER BY `unit` DESC [ RunTime:0.018331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963865 LIMIT 2 [ RunTime:0.021133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963865 ORDER BY `minOrder` ASC [ RunTime:0.004717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963863 LIMIT 5 [ RunTime:0.007666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963863 ORDER BY `minOrder` ASC [ RunTime:0.026032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12963863 ORDER BY `unit` DESC [ RunTime:0.015114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12963863 LIMIT 2 [ RunTime:0.021999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12963863 ORDER BY `minOrder` ASC [ RunTime:0.006784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962286 LIMIT 5 [ RunTime:0.011248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962286 ORDER BY `minOrder` ASC [ RunTime:0.029161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962286 ORDER BY `unit` DESC [ RunTime:0.022444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962286 LIMIT 2 [ RunTime:0.016337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962286 ORDER BY `minOrder` ASC [ RunTime:0.014686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962285 LIMIT 5 [ RunTime:0.013237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962285 ORDER BY `minOrder` ASC [ RunTime:0.014408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962285 ORDER BY `unit` DESC [ RunTime:0.010804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962285 LIMIT 2 [ RunTime:0.031081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962285 ORDER BY `minOrder` ASC [ RunTime:0.007238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962284 LIMIT 5 [ RunTime:0.010157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962284 ORDER BY `minOrder` ASC [ RunTime:0.006009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962284 ORDER BY `unit` DESC [ RunTime:0.014852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962284 LIMIT 2 [ RunTime:0.006135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962284 ORDER BY `minOrder` ASC [ RunTime:0.013436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962283 LIMIT 5 [ RunTime:0.001719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962283 ORDER BY `minOrder` ASC [ RunTime:0.026907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962283 ORDER BY `unit` DESC [ RunTime:0.012414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962283 LIMIT 2 [ RunTime:0.022473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962283 ORDER BY `minOrder` ASC [ RunTime:0.016513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962282 LIMIT 5 [ RunTime:0.003009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962282 ORDER BY `minOrder` ASC [ RunTime:0.005906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962282 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962282 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962282 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962281 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962281 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962281 ORDER BY `unit` DESC [ RunTime:0.007840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962281 LIMIT 2 [ RunTime:0.025506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962281 ORDER BY `minOrder` ASC [ RunTime:0.003303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962280 LIMIT 5 [ RunTime:0.012812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962280 ORDER BY `minOrder` ASC [ RunTime:0.012579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962280 ORDER BY `unit` DESC [ RunTime:0.002840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962280 LIMIT 2 [ RunTime:0.007703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962280 ORDER BY `minOrder` ASC [ RunTime:0.007496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962279 LIMIT 5 [ RunTime:0.008134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962279 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962279 ORDER BY `unit` DESC [ RunTime:0.002161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962279 LIMIT 2 [ RunTime:0.013999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962279 ORDER BY `minOrder` ASC [ RunTime:0.021145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11741212 LIMIT 5 [ RunTime:0.015621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11741212 ORDER BY `minOrder` ASC [ RunTime:0.006346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11741212 ORDER BY `unit` DESC [ RunTime:0.003593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11741212 LIMIT 2 [ RunTime:0.013436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11741212 ORDER BY `minOrder` ASC [ RunTime:0.007461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11740001 LIMIT 5 [ RunTime:0.007053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11740001 ORDER BY `minOrder` ASC [ RunTime:0.048022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11740001 ORDER BY `unit` DESC [ RunTime:0.008773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11740001 LIMIT 2 [ RunTime:0.011595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11740001 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11740000 LIMIT 5 [ RunTime:0.003986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11740000 ORDER BY `minOrder` ASC [ RunTime:0.010839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11740000 ORDER BY `unit` DESC [ RunTime:0.003642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11740000 LIMIT 2 [ RunTime:0.024329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11740000 ORDER BY `minOrder` ASC [ RunTime:0.003450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739999 LIMIT 5 [ RunTime:0.005618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739999 ORDER BY `minOrder` ASC [ RunTime:0.005396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11739999 ORDER BY `unit` DESC [ RunTime:0.009441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11739999 LIMIT 2 [ RunTime:0.008648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739999 ORDER BY `minOrder` ASC [ RunTime:0.039308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739998 LIMIT 5 [ RunTime:0.015912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739998 ORDER BY `minOrder` ASC [ RunTime:0.015627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11739998 ORDER BY `unit` DESC [ RunTime:0.026051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11739998 LIMIT 2 [ RunTime:0.006107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739998 ORDER BY `minOrder` ASC [ RunTime:0.008385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739997 LIMIT 5 [ RunTime:0.002709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739997 ORDER BY `minOrder` ASC [ RunTime:0.010882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11739997 ORDER BY `unit` DESC [ RunTime:0.002588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11739997 LIMIT 2 [ RunTime:0.010517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739997 ORDER BY `minOrder` ASC [ RunTime:0.006630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739996 LIMIT 5 [ RunTime:0.012640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739996 ORDER BY `minOrder` ASC [ RunTime:0.034256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11739996 ORDER BY `unit` DESC [ RunTime:0.018481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11739996 LIMIT 2 [ RunTime:0.008743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739996 ORDER BY `minOrder` ASC [ RunTime:0.011539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739995 LIMIT 5 [ RunTime:0.006919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739995 ORDER BY `minOrder` ASC [ RunTime:0.001052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11739995 ORDER BY `unit` DESC [ RunTime:0.003534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11739995 LIMIT 2 [ RunTime:0.015994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739995 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739994 LIMIT 5 [ RunTime:0.009083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739994 ORDER BY `minOrder` ASC [ RunTime:0.002818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11739994 ORDER BY `unit` DESC [ RunTime:0.008012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11739994 LIMIT 2 [ RunTime:0.015823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11739994 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009259s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60279669 LIMIT 5 [ RunTime:0.021868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279669 ORDER BY `minOrder` ASC [ RunTime:0.009425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60279669 ORDER BY `unit` DESC [ RunTime:0.003615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60279669 LIMIT 2 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279669 ORDER BY `minOrder` ASC [ RunTime:0.001373s ]
select * from pdf where partno='JT00A-12-8PC(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007172s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PC(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001205s ]
SELECT `id` FROM `stock` WHERE `id` <> 60279669 AND `partno` = 'JT00A-12-8PC(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60279668 LIMIT 5 [ RunTime:0.008208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279668 ORDER BY `minOrder` ASC [ RunTime:0.003323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60279668 ORDER BY `unit` DESC [ RunTime:0.007119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60279668 LIMIT 2 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279668 ORDER BY `minOrder` ASC [ RunTime:0.007315s ]
select * from pdf where partno='JT00A-12-8PB(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PB(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008124s ]
SELECT `id` FROM `stock` WHERE `id` <> 60279668 AND `partno` = 'JT00A-12-8PB(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60279667 LIMIT 5 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279667 ORDER BY `minOrder` ASC [ RunTime:0.010864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60279667 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60279667 LIMIT 2 [ RunTime:0.022388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279667 ORDER BY `minOrder` ASC [ RunTime:0.013987s ]
select * from pdf where partno='JT00A-12-8PD(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PD(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006992s ]
SELECT `id` FROM `stock` WHERE `id` <> 60279667 AND `partno` = 'JT00A-12-8PD(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60279666 LIMIT 5 [ RunTime:0.014599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279666 ORDER BY `minOrder` ASC [ RunTime:0.011204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60279666 ORDER BY `unit` DESC [ RunTime:0.000806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60279666 LIMIT 2 [ RunTime:0.004776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60279666 ORDER BY `minOrder` ASC [ RunTime:0.007754s ]
select * from pdf where partno='JT00A-12-8PA(363)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(363)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.007420s ]
SELECT `id` FROM `stock` WHERE `id` <> 60279666 AND `partno` = 'JT00A-12-8PA(363)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278622 LIMIT 5 [ RunTime:0.002467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278622 ORDER BY `minOrder` ASC [ RunTime:0.001292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278622 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278622 LIMIT 2 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278622 ORDER BY `minOrder` ASC [ RunTime:0.001879s ]
select * from pdf where partno='JT00A-12-8PC(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PC(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008767s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278622 AND `partno` = 'JT00A-12-8PC(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11741212 [ RunTime:0.006682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278621 LIMIT 5 [ RunTime:0.004072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278621 ORDER BY `minOrder` ASC [ RunTime:0.003281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278621 ORDER BY `unit` DESC [ RunTime:0.003929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278621 LIMIT 2 [ RunTime:0.005721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278621 ORDER BY `minOrder` ASC [ RunTime:0.011345s ]
select * from pdf where partno='JT00A-12-8PC(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PC(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.007252s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278621 AND `partno` = 'JT00A-12-8PC(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963866 [ RunTime:0.003110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278620 LIMIT 5 [ RunTime:0.005002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278620 ORDER BY `minOrder` ASC [ RunTime:0.003247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278620 ORDER BY `unit` DESC [ RunTime:0.005723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278620 LIMIT 2 [ RunTime:0.007494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278620 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
select * from pdf where partno='JT00A-12-8PC(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PC(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001291s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278620 AND `partno` = 'JT00A-12-8PC(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963865 [ RunTime:0.002287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278619 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278619 ORDER BY `minOrder` ASC [ RunTime:0.008928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278619 ORDER BY `unit` DESC [ RunTime:0.002666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278619 LIMIT 2 [ RunTime:0.003799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278619 ORDER BY `minOrder` ASC [ RunTime:0.002402s ]
select * from pdf where partno='JT00A-12-8PB(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PB(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001242s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278619 AND `partno` = 'JT00A-12-8PB(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12963863 [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278618 LIMIT 5 [ RunTime:0.005662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278618 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278618 ORDER BY `unit` DESC [ RunTime:0.006645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278618 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278618 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='JT00A-12-8PB(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PB(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000849s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278618 AND `partno` = 'JT00A-12-8PB(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278617 LIMIT 5 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278617 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278617 ORDER BY `unit` DESC [ RunTime:0.013578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278617 LIMIT 2 [ RunTime:0.012143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278617 ORDER BY `minOrder` ASC [ RunTime:0.007022s ]
select * from pdf where partno='JT00A-12-8PB(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PB(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008524s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278617 AND `partno` = 'JT00A-12-8PB(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278616 LIMIT 5 [ RunTime:0.028264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278616 ORDER BY `minOrder` ASC [ RunTime:0.010317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278616 ORDER BY `unit` DESC [ RunTime:0.014021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278616 LIMIT 2 [ RunTime:0.007164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278616 ORDER BY `minOrder` ASC [ RunTime:0.016197s ]
select * from pdf where partno='JT00A-12-8PD(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PD(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.023467s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278616 AND `partno` = 'JT00A-12-8PD(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278615 LIMIT 5 [ RunTime:0.005000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278615 ORDER BY `minOrder` ASC [ RunTime:0.017979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278615 ORDER BY `unit` DESC [ RunTime:0.016000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278615 LIMIT 2 [ RunTime:0.010582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278615 ORDER BY `minOrder` ASC [ RunTime:0.016422s ]
select * from pdf where partno='JT00A-12-8PD(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.035871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PD(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.025342s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278615 AND `partno` = 'JT00A-12-8PD(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.051263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278614 LIMIT 5 [ RunTime:0.037056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278614 ORDER BY `minOrder` ASC [ RunTime:0.030771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278614 ORDER BY `unit` DESC [ RunTime:0.010991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278614 LIMIT 2 [ RunTime:0.043184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278614 ORDER BY `minOrder` ASC [ RunTime:0.008524s ]
select * from pdf where partno='JT00A-12-8PA(302)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.022012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(302)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018546s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278614 AND `partno` = 'JT00A-12-8PA(302)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278613 LIMIT 5 [ RunTime:0.017991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278613 ORDER BY `minOrder` ASC [ RunTime:0.043631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278613 ORDER BY `unit` DESC [ RunTime:0.029584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278613 LIMIT 2 [ RunTime:0.032229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278613 ORDER BY `minOrder` ASC [ RunTime:0.014818s ]
select * from pdf where partno='JT00A-12-8PD(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.047740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PD(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.033045s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278613 AND `partno` = 'JT00A-12-8PD(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.020604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278612 LIMIT 5 [ RunTime:0.024314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278612 ORDER BY `minOrder` ASC [ RunTime:0.051257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278612 ORDER BY `unit` DESC [ RunTime:0.024942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278612 LIMIT 2 [ RunTime:0.016086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278612 ORDER BY `minOrder` ASC [ RunTime:0.003839s ]
select * from pdf where partno='JT00A-12-8PA(434)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.016394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(434)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011415s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278612 AND `partno` = 'JT00A-12-8PA(434)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60278611 LIMIT 5 [ RunTime:0.003261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278611 ORDER BY `minOrder` ASC [ RunTime:0.008710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60278611 ORDER BY `unit` DESC [ RunTime:0.022281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60278611 LIMIT 2 [ RunTime:0.012178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60278611 ORDER BY `minOrder` ASC [ RunTime:0.015077s ]
select * from pdf where partno='JT00A-12-8PA(345)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(345)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006862s ]
SELECT `id` FROM `stock` WHERE `id` <> 60278611 AND `partno` = 'JT00A-12-8PA(345)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.005274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60274178 LIMIT 5 [ RunTime:0.005521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274178 ORDER BY `minOrder` ASC [ RunTime:0.001349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60274178 ORDER BY `unit` DESC [ RunTime:0.007988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60274178 LIMIT 2 [ RunTime:0.002415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274178 ORDER BY `minOrder` ASC [ RunTime:0.006483s ]
select * from pdf where partno='JT00A-12-8PA(409)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(409)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003681s ]
SELECT `id` FROM `stock` WHERE `id` <> 60274178 AND `partno` = 'JT00A-12-8PA(409)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11740001 [ RunTime:0.003243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60274177 LIMIT 5 [ RunTime:0.018044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274177 ORDER BY `minOrder` ASC [ RunTime:0.046963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60274177 ORDER BY `unit` DESC [ RunTime:0.014477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60274177 LIMIT 2 [ RunTime:0.014727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274177 ORDER BY `minOrder` ASC [ RunTime:0.019405s ]
select * from pdf where partno='JT00A-12-8PA(328)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.023354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(328)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004030s ]
SELECT `id` FROM `stock` WHERE `id` <> 60274177 AND `partno` = 'JT00A-12-8PA(328)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.046888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11740000 [ RunTime:0.037240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60274176 LIMIT 5 [ RunTime:0.051575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274176 ORDER BY `minOrder` ASC [ RunTime:0.011310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60274176 ORDER BY `unit` DESC [ RunTime:0.008623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60274176 LIMIT 2 [ RunTime:0.008957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274176 ORDER BY `minOrder` ASC [ RunTime:0.011619s ]
select * from pdf where partno='JT00A-12-8PA(318)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(318)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.013994s ]
SELECT `id` FROM `stock` WHERE `id` <> 60274176 AND `partno` = 'JT00A-12-8PA(318)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962286 [ RunTime:0.003384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60274175 LIMIT 5 [ RunTime:0.006628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274175 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60274175 ORDER BY `unit` DESC [ RunTime:0.008361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60274175 LIMIT 2 [ RunTime:0.003200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60274175 ORDER BY `minOrder` ASC [ RunTime:0.002559s ]
select * from pdf where partno='JT00A-12-8PA(306)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-12-8PA(306)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008949s ]
SELECT `id` FROM `stock` WHERE `id` <> 60274175 AND `partno` = 'JT00A-12-8PA(306)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739999 [ RunTime:0.001564s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011439s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010900s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012127s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008885s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007484s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026914s ]
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 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003523s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JT00A-12-8P%' OR `brand` LIKE 'JT00A-12-8P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007143s ]