SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001437s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=64013&search=1' [ RunTime:0.002863s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001678s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001475s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.004751s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001408s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001120s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001931s ]
SELECT * FROM `stock_search` WHERE `partno` = '64013' LIMIT 1 [ RunTime:0.003281s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-30 02:29:36' WHERE `partno` = '64013' [ RunTime:0.004330s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002667s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020077s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20070913 LIMIT 5 [ RunTime:0.028976s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20070913 ORDER BY `minOrder` ASC [ RunTime:0.025589s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20070913 ORDER BY `unit` DESC [ RunTime:0.016212s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20070913 LIMIT 2 [ RunTime:0.064041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20070913 ORDER BY `minOrder` ASC [ RunTime:0.007678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15546202 LIMIT 5 [ RunTime:0.037219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546202 ORDER BY `minOrder` ASC [ RunTime:0.023494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15546202 ORDER BY `unit` DESC [ RunTime:0.034734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15546202 LIMIT 2 [ RunTime:0.066913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546202 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20070950 LIMIT 5 [ RunTime:0.036236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20070950 ORDER BY `minOrder` ASC [ RunTime:0.022689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20070950 ORDER BY `unit` DESC [ RunTime:0.050752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20070950 LIMIT 2 [ RunTime:0.023973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20070950 ORDER BY `minOrder` ASC [ RunTime:0.029912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763862 LIMIT 5 [ RunTime:0.014598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763862 ORDER BY `minOrder` ASC [ RunTime:0.007177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763862 ORDER BY `unit` DESC [ RunTime:0.041451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763862 LIMIT 2 [ RunTime:0.020889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763862 ORDER BY `minOrder` ASC [ RunTime:0.013424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763861 LIMIT 5 [ RunTime:0.024125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763861 ORDER BY `minOrder` ASC [ RunTime:0.020428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763861 ORDER BY `unit` DESC [ RunTime:0.021253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763861 LIMIT 2 [ RunTime:0.033233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763861 ORDER BY `minOrder` ASC [ RunTime:0.003470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763860 LIMIT 5 [ RunTime:0.008699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763860 ORDER BY `minOrder` ASC [ RunTime:0.008856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763860 ORDER BY `unit` DESC [ RunTime:0.016139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763860 LIMIT 2 [ RunTime:0.009823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763860 ORDER BY `minOrder` ASC [ RunTime:0.011147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763859 LIMIT 5 [ RunTime:0.003493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763859 ORDER BY `minOrder` ASC [ RunTime:0.028265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763859 ORDER BY `unit` DESC [ RunTime:0.025253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763859 LIMIT 2 [ RunTime:0.012386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763859 ORDER BY `minOrder` ASC [ RunTime:0.007320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763858 LIMIT 5 [ RunTime:0.025687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763858 ORDER BY `minOrder` ASC [ RunTime:0.020578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763858 ORDER BY `unit` DESC [ RunTime:0.001992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763858 LIMIT 2 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763858 ORDER BY `minOrder` ASC [ RunTime:0.002068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763857 LIMIT 5 [ RunTime:0.015044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763857 ORDER BY `minOrder` ASC [ RunTime:0.001107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763857 ORDER BY `unit` DESC [ RunTime:0.007080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763857 LIMIT 2 [ RunTime:0.007318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763857 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763856 LIMIT 5 [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763856 ORDER BY `minOrder` ASC [ RunTime:0.012604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763856 ORDER BY `unit` DESC [ RunTime:0.004676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763856 LIMIT 2 [ RunTime:0.010356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763856 ORDER BY `minOrder` ASC [ RunTime:0.005676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369485 LIMIT 5 [ RunTime:0.007940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369485 ORDER BY `minOrder` ASC [ RunTime:0.004810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17369485 ORDER BY `unit` DESC [ RunTime:0.004638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17369485 LIMIT 2 [ RunTime:0.010070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369485 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008960 LIMIT 5 [ RunTime:0.015695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008960 ORDER BY `minOrder` ASC [ RunTime:0.010098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17008960 ORDER BY `unit` DESC [ RunTime:0.017985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17008960 LIMIT 2 [ RunTime:0.004958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008960 ORDER BY `minOrder` ASC [ RunTime:0.005291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336687 LIMIT 5 [ RunTime:0.005101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336687 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11336687 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11336687 LIMIT 2 [ RunTime:0.014242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336687 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259517 LIMIT 5 [ RunTime:0.003011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259517 ORDER BY `minOrder` ASC [ RunTime:0.008645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259517 ORDER BY `unit` DESC [ RunTime:0.003873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259517 LIMIT 2 [ RunTime:0.012559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259517 ORDER BY `minOrder` ASC [ RunTime:0.001782s ]
select * from pdf where partno='640136-2' and brandshort='te connectivity' limit 1 [ RunTime:0.004468s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640136-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.022996s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60376196 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376196 ORDER BY `minOrder` ASC [ RunTime:0.009506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60376196 ORDER BY `unit` DESC [ RunTime:0.004874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60376196 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376196 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='640136-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640136-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000875s ]
SELECT `id` FROM `stock` WHERE `id` <> 60376196 AND `partno` = '640136-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20070913 [ RunTime:0.004726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64055335 LIMIT 5 [ RunTime:0.010224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64055335 ORDER BY `minOrder` ASC [ RunTime:0.005302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64055335 ORDER BY `unit` DESC [ RunTime:0.011761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64055335 LIMIT 2 [ RunTime:0.008212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64055335 ORDER BY `minOrder` ASC [ RunTime:0.003597s ]
select * from pdf where partno='64013' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.004126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64013' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.010994s ]
SELECT `id` FROM `stock` WHERE `id` <> 64055335 AND `partno` = '64013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.007370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336687 [ RunTime:0.004719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60376274 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376274 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60376274 ORDER BY `unit` DESC [ RunTime:0.009247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60376274 LIMIT 2 [ RunTime:0.001473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376274 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
select * from pdf where partno='640136-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640136-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000551s ]
SELECT `id` FROM `stock` WHERE `id` <> 60376274 AND `partno` = '640136-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20070950 [ RunTime:0.009103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60376211 LIMIT 5 [ RunTime:0.015643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376211 ORDER BY `minOrder` ASC [ RunTime:0.006353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60376211 ORDER BY `unit` DESC [ RunTime:0.006776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60376211 LIMIT 2 [ RunTime:0.003138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376211 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
select * from pdf where partno='640136-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640136-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006688s ]
SELECT `id` FROM `stock` WHERE `id` <> 60376211 AND `partno` = '640136-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15546202 [ RunTime:0.014673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60376206 LIMIT 5 [ RunTime:0.006879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376206 ORDER BY `minOrder` ASC [ RunTime:0.003832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60376206 ORDER BY `unit` DESC [ RunTime:0.007783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60376206 LIMIT 2 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376206 ORDER BY `minOrder` ASC [ RunTime:0.004669s ]
select * from pdf where partno='640136-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640136-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003016s ]
SELECT `id` FROM `stock` WHERE `id` <> 60376206 AND `partno` = '640136-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369485 [ RunTime:0.016289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58543670 LIMIT 5 [ RunTime:0.006198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543670 ORDER BY `minOrder` ASC [ RunTime:0.023408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58543670 ORDER BY `unit` DESC [ RunTime:0.026306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58543670 LIMIT 2 [ RunTime:0.009019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543670 ORDER BY `minOrder` ASC [ RunTime:0.004558s ]
select * from pdf where partno='640137' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.008254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640137' OR `brand` LIKE 'Astro Tool Corp%' ) ) LIMIT 1 [ RunTime:0.002854s ]
SELECT `id` FROM `stock` WHERE `id` <> 58543670 AND `partno` = '640137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astro tool corp%' ) [ RunTime:0.005340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763861 [ RunTime:0.018674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58543669 LIMIT 5 [ RunTime:0.009209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543669 ORDER BY `minOrder` ASC [ RunTime:0.008377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58543669 ORDER BY `unit` DESC [ RunTime:0.019072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58543669 LIMIT 2 [ RunTime:0.002220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543669 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='640136' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.009748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640136' OR `brand` LIKE 'Astro Tool Corp%' ) ) LIMIT 1 [ RunTime:0.012446s ]
SELECT `id` FROM `stock` WHERE `id` <> 58543669 AND `partno` = '640136' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astro tool corp%' ) [ RunTime:0.003098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763860 [ RunTime:0.024244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58543668 LIMIT 5 [ RunTime:0.010688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543668 ORDER BY `minOrder` ASC [ RunTime:0.014703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58543668 ORDER BY `unit` DESC [ RunTime:0.006001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58543668 LIMIT 2 [ RunTime:0.008469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543668 ORDER BY `minOrder` ASC [ RunTime:0.006013s ]
select * from pdf where partno='640132' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.016281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640132' OR `brand` LIKE 'Astro Tool Corp%' ) ) LIMIT 1 [ RunTime:0.022300s ]
SELECT `id` FROM `stock` WHERE `id` <> 58543668 AND `partno` = '640132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astro tool corp%' ) [ RunTime:0.024626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763858 [ RunTime:0.006748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58543667 LIMIT 5 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543667 ORDER BY `minOrder` ASC [ RunTime:0.031355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58543667 ORDER BY `unit` DESC [ RunTime:0.050086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58543667 LIMIT 2 [ RunTime:0.025403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543667 ORDER BY `minOrder` ASC [ RunTime:0.005502s ]
select * from pdf where partno='640130' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.016180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640130' OR `brand` LIKE 'Astro Tool Corp%' ) ) LIMIT 1 [ RunTime:0.025752s ]
SELECT `id` FROM `stock` WHERE `id` <> 58543667 AND `partno` = '640130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astro tool corp%' ) [ RunTime:0.023720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763856 [ RunTime:0.014819s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049306s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025583s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033442s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016634s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014814s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016002s ]
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 '64013%' OR `brand` LIKE '64013%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030117s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64013%' OR `brand` LIKE '64013%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015478s ]