SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001957s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=JR28-RYG-D&search=1' [ RunTime:0.001881s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002117s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002351s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.002283s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001914s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002515s ]
SELECT * FROM `stock_search` WHERE `partno` = 'JR28-RYG-D' LIMIT 1 [ RunTime:0.005839s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 21:06:12' WHERE `partno` = 'JR28-RYG-D' [ RunTime:0.003823s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002106s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023931s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237502 LIMIT 5 [ RunTime:0.009341s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237502 ORDER BY `minOrder` ASC [ RunTime:0.004100s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15237502 ORDER BY `unit` DESC [ RunTime:0.008131s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15237502 LIMIT 2 [ RunTime:0.008335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237502 ORDER BY `minOrder` ASC [ RunTime:0.004281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842629 LIMIT 5 [ RunTime:0.007768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842629 ORDER BY `minOrder` ASC [ RunTime:0.012416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842629 ORDER BY `unit` DESC [ RunTime:0.009542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842629 LIMIT 2 [ RunTime:0.011872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842629 ORDER BY `minOrder` ASC [ RunTime:0.001013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237526 LIMIT 5 [ RunTime:0.005692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237526 ORDER BY `minOrder` ASC [ RunTime:0.009124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15237526 ORDER BY `unit` DESC [ RunTime:0.015270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15237526 LIMIT 2 [ RunTime:0.009087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237526 ORDER BY `minOrder` ASC [ RunTime:0.004890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843555 LIMIT 5 [ RunTime:0.004057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843555 ORDER BY `minOrder` ASC [ RunTime:0.008666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843555 ORDER BY `unit` DESC [ RunTime:0.017545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843555 LIMIT 2 [ RunTime:0.002888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843555 ORDER BY `minOrder` ASC [ RunTime:0.003435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843554 LIMIT 5 [ RunTime:0.001285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843554 ORDER BY `minOrder` ASC [ RunTime:0.003165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843554 ORDER BY `unit` DESC [ RunTime:0.011058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843554 LIMIT 2 [ RunTime:0.014180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843554 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843553 LIMIT 5 [ RunTime:0.001561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843553 ORDER BY `minOrder` ASC [ RunTime:0.001287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843553 ORDER BY `unit` DESC [ RunTime:0.009787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843553 LIMIT 2 [ RunTime:0.004470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843553 ORDER BY `minOrder` ASC [ RunTime:0.010406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843552 LIMIT 5 [ RunTime:0.011354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843552 ORDER BY `minOrder` ASC [ RunTime:0.001250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843552 ORDER BY `unit` DESC [ RunTime:0.008056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843552 LIMIT 2 [ RunTime:0.003053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843552 ORDER BY `minOrder` ASC [ RunTime:0.002493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843551 LIMIT 5 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843551 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843551 ORDER BY `unit` DESC [ RunTime:0.018517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843551 LIMIT 2 [ RunTime:0.005213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843551 ORDER BY `minOrder` ASC [ RunTime:0.002700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843550 LIMIT 5 [ RunTime:0.002805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843550 ORDER BY `minOrder` ASC [ RunTime:0.003346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843550 ORDER BY `unit` DESC [ RunTime:0.019562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843550 LIMIT 2 [ RunTime:0.003412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843550 ORDER BY `minOrder` ASC [ RunTime:0.001361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843549 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843549 ORDER BY `minOrder` ASC [ RunTime:0.009000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843549 ORDER BY `unit` DESC [ RunTime:0.016290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843549 LIMIT 2 [ RunTime:0.003726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843549 ORDER BY `minOrder` ASC [ RunTime:0.002205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843548 LIMIT 5 [ RunTime:0.003016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843548 ORDER BY `minOrder` ASC [ RunTime:0.010747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843548 ORDER BY `unit` DESC [ RunTime:0.009097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843548 LIMIT 2 [ RunTime:0.010821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843548 ORDER BY `minOrder` ASC [ RunTime:0.008899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843547 LIMIT 5 [ RunTime:0.004578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843547 ORDER BY `minOrder` ASC [ RunTime:0.008410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843547 ORDER BY `unit` DESC [ RunTime:0.010775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843547 LIMIT 2 [ RunTime:0.001844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843547 ORDER BY `minOrder` ASC [ RunTime:0.008407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843546 LIMIT 5 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843546 ORDER BY `minOrder` ASC [ RunTime:0.002409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843546 ORDER BY `unit` DESC [ RunTime:0.001661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843546 LIMIT 2 [ RunTime:0.006472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843546 ORDER BY `minOrder` ASC [ RunTime:0.005195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843545 LIMIT 5 [ RunTime:0.002202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843545 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843545 ORDER BY `unit` DESC [ RunTime:0.004557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843545 LIMIT 2 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843545 ORDER BY `minOrder` ASC [ RunTime:0.002933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843544 LIMIT 5 [ RunTime:0.000866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843544 ORDER BY `minOrder` ASC [ RunTime:0.002146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843544 ORDER BY `unit` DESC [ RunTime:0.003482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843544 LIMIT 2 [ RunTime:0.005290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843544 ORDER BY `minOrder` ASC [ RunTime:0.003781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843543 LIMIT 5 [ RunTime:0.006470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843543 ORDER BY `minOrder` ASC [ RunTime:0.008012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843543 ORDER BY `unit` DESC [ RunTime:0.002502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843543 LIMIT 2 [ RunTime:0.009129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843543 ORDER BY `minOrder` ASC [ RunTime:0.001432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843542 LIMIT 5 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843542 ORDER BY `minOrder` ASC [ RunTime:0.006581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843542 ORDER BY `unit` DESC [ RunTime:0.007342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843542 LIMIT 2 [ RunTime:0.001619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843542 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843541 LIMIT 5 [ RunTime:0.005919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843541 ORDER BY `minOrder` ASC [ RunTime:0.003873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843541 ORDER BY `unit` DESC [ RunTime:0.004769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843541 LIMIT 2 [ RunTime:0.003680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843541 ORDER BY `minOrder` ASC [ RunTime:0.001417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843540 LIMIT 5 [ RunTime:0.003440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843540 ORDER BY `minOrder` ASC [ RunTime:0.006481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843540 ORDER BY `unit` DESC [ RunTime:0.005677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843540 LIMIT 2 [ RunTime:0.006771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843540 ORDER BY `minOrder` ASC [ RunTime:0.006991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843539 LIMIT 5 [ RunTime:0.001866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843539 ORDER BY `minOrder` ASC [ RunTime:0.004802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18843539 ORDER BY `unit` DESC [ RunTime:0.004278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18843539 LIMIT 2 [ RunTime:0.002623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18843539 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005579s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57636542 LIMIT 5 [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57636542 ORDER BY `minOrder` ASC [ RunTime:0.019569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57636542 ORDER BY `unit` DESC [ RunTime:0.011925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57636542 LIMIT 2 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57636542 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
select * from pdf where partno='JR28-RYG-DMCT1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.006176s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMCT1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.011642s ]
SELECT `id` FROM `stock` WHERE `id` <> 57636542 AND `partno` = 'JR28-RYG-DMCT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.008389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237526 [ RunTime:0.002459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57636516 LIMIT 5 [ RunTime:0.012011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57636516 ORDER BY `minOrder` ASC [ RunTime:0.008261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57636516 ORDER BY `unit` DESC [ RunTime:0.005492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57636516 LIMIT 2 [ RunTime:0.008308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57636516 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
select * from pdf where partno='JR28-RYG-D' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.005193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-D' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.001560s ]
SELECT `id` FROM `stock` WHERE `id` <> 57636516 AND `partno` = 'JR28-RYG-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.010788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237502 [ RunTime:0.003580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57637132 LIMIT 5 [ RunTime:0.005620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57637132 ORDER BY `minOrder` ASC [ RunTime:0.005488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57637132 ORDER BY `unit` DESC [ RunTime:0.007742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57637132 LIMIT 2 [ RunTime:0.003818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57637132 ORDER BY `minOrder` ASC [ RunTime:0.002218s ]
select * from pdf where partno='JR28-RYG-DLCT115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.007401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLCT115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.007030s ]
SELECT `id` FROM `stock` WHERE `id` <> 57637132 AND `partno` = 'JR28-RYG-DLCT115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.010751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842629 [ RunTime:0.005506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638933 LIMIT 5 [ RunTime:0.004114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638933 ORDER BY `minOrder` ASC [ RunTime:0.006385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638933 ORDER BY `unit` DESC [ RunTime:0.002701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638933 LIMIT 2 [ RunTime:0.013801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638933 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
select * from pdf where partno='JR28-RYG-DLCM1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.010140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLCM1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.004317s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638933 AND `partno` = 'JR28-RYG-DLCM1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.015975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237707 [ RunTime:0.009405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638902 LIMIT 5 [ RunTime:0.010551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638902 ORDER BY `minOrder` ASC [ RunTime:0.016000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638902 ORDER BY `unit` DESC [ RunTime:0.009384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638902 LIMIT 2 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638902 ORDER BY `minOrder` ASC [ RunTime:0.013810s ]
select * from pdf where partno='JR28-RYG-DLMP1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.007915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLMP1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.013045s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638902 AND `partno` = 'JR28-RYG-DLMP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.016970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843555 [ RunTime:0.007097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638901 LIMIT 5 [ RunTime:0.025231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638901 ORDER BY `minOrder` ASC [ RunTime:0.012674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638901 ORDER BY `unit` DESC [ RunTime:0.027459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638901 LIMIT 2 [ RunTime:0.017620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638901 ORDER BY `minOrder` ASC [ RunTime:0.005895s ]
select * from pdf where partno='JR28-RYG-DMMP115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.003701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMMP115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.008603s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638901 AND `partno` = 'JR28-RYG-DMMP115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.012904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843554 [ RunTime:0.012510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638900 LIMIT 5 [ RunTime:0.008197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638900 ORDER BY `minOrder` ASC [ RunTime:0.015152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638900 ORDER BY `unit` DESC [ RunTime:0.004883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638900 LIMIT 2 [ RunTime:0.013184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638900 ORDER BY `minOrder` ASC [ RunTime:0.001885s ]
select * from pdf where partno='JR28-RYG-DLCM115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.006325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLCM115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.010978s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638900 AND `partno` = 'JR28-RYG-DLCM115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.018358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843553 [ RunTime:0.019323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638899 LIMIT 5 [ RunTime:0.013410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638899 ORDER BY `minOrder` ASC [ RunTime:0.025819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638899 ORDER BY `unit` DESC [ RunTime:0.018462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638899 LIMIT 2 [ RunTime:0.020851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638899 ORDER BY `minOrder` ASC [ RunTime:0.012324s ]
select * from pdf where partno='JR28-RYG-DMMP1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.036597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMMP1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.021082s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638899 AND `partno` = 'JR28-RYG-DMMP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.012720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843552 [ RunTime:0.012457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638898 LIMIT 5 [ RunTime:0.015933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638898 ORDER BY `minOrder` ASC [ RunTime:0.016047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638898 ORDER BY `unit` DESC [ RunTime:0.011852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638898 LIMIT 2 [ RunTime:0.029498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638898 ORDER BY `minOrder` ASC [ RunTime:0.010781s ]
select * from pdf where partno='JR28-RYG-DMDP315' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.015756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMDP315' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.011489s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638898 AND `partno` = 'JR28-RYG-DMDP315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.010939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843551 [ RunTime:0.013518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638897 LIMIT 5 [ RunTime:0.001725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638897 ORDER BY `minOrder` ASC [ RunTime:0.005850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638897 ORDER BY `unit` DESC [ RunTime:0.017189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638897 LIMIT 2 [ RunTime:0.023582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638897 ORDER BY `minOrder` ASC [ RunTime:0.012888s ]
select * from pdf where partno='JR28-RYG-DLFP115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.025690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLFP115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.009531s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638897 AND `partno` = 'JR28-RYG-DLFP115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.014781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843550 [ RunTime:0.012031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638896 LIMIT 5 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638896 ORDER BY `minOrder` ASC [ RunTime:0.011223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638896 ORDER BY `unit` DESC [ RunTime:0.022609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638896 LIMIT 2 [ RunTime:0.016692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638896 ORDER BY `minOrder` ASC [ RunTime:0.004679s ]
select * from pdf where partno='JR28-RYG-DMCM1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.013160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMCM1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.017139s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638896 AND `partno` = 'JR28-RYG-DMCM1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.001707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843549 [ RunTime:0.036436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638895 LIMIT 5 [ RunTime:0.020008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638895 ORDER BY `minOrder` ASC [ RunTime:0.013619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638895 ORDER BY `unit` DESC [ RunTime:0.007928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638895 LIMIT 2 [ RunTime:0.018527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638895 ORDER BY `minOrder` ASC [ RunTime:0.007123s ]
select * from pdf where partno='JR28-RYG-DMDP3' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.011055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMDP3' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.008464s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638895 AND `partno` = 'JR28-RYG-DMDP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.017339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14185895 [ RunTime:0.020132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638894 LIMIT 5 [ RunTime:0.007490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638894 ORDER BY `minOrder` ASC [ RunTime:0.006593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638894 ORDER BY `unit` DESC [ RunTime:0.040879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638894 LIMIT 2 [ RunTime:0.022488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638894 ORDER BY `minOrder` ASC [ RunTime:0.009417s ]
select * from pdf where partno='JR28-RYG-DMFP1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.011981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMFP1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.009536s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638894 AND `partno` = 'JR28-RYG-DMFP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.012891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843548 [ RunTime:0.024799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638893 LIMIT 5 [ RunTime:0.012829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638893 ORDER BY `minOrder` ASC [ RunTime:0.019682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638893 ORDER BY `unit` DESC [ RunTime:0.010156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638893 LIMIT 2 [ RunTime:0.011188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638893 ORDER BY `minOrder` ASC [ RunTime:0.006290s ]
select * from pdf where partno='JR28-RYG-DLDP215' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.007729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLDP215' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.008234s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638893 AND `partno` = 'JR28-RYG-DLDP215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.010244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14185894 [ RunTime:0.027273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638892 LIMIT 5 [ RunTime:0.009416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638892 ORDER BY `minOrder` ASC [ RunTime:0.018692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638892 ORDER BY `unit` DESC [ RunTime:0.011950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638892 LIMIT 2 [ RunTime:0.018200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638892 ORDER BY `minOrder` ASC [ RunTime:0.010983s ]
select * from pdf where partno='JR28-RYG-DMCT115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.022716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMCT115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.011373s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638892 AND `partno` = 'JR28-RYG-DMCT115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.016220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237705 [ RunTime:0.026914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638891 LIMIT 5 [ RunTime:0.042472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638891 ORDER BY `minOrder` ASC [ RunTime:0.036941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638891 ORDER BY `unit` DESC [ RunTime:0.010523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638891 LIMIT 2 [ RunTime:0.020826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638891 ORDER BY `minOrder` ASC [ RunTime:0.014386s ]
select * from pdf where partno='JR28-RYG-DMDP2' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.017336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMDP2' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.015125s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638891 AND `partno` = 'JR28-RYG-DMDP2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.035806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843547 [ RunTime:0.050137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638890 LIMIT 5 [ RunTime:0.025123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638890 ORDER BY `minOrder` ASC [ RunTime:0.022465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638890 ORDER BY `unit` DESC [ RunTime:0.027270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638890 LIMIT 2 [ RunTime:0.013290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638890 ORDER BY `minOrder` ASC [ RunTime:0.009524s ]
select * from pdf where partno='JR28-RYG-DMFP115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.039078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMFP115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.010898s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638890 AND `partno` = 'JR28-RYG-DMFP115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.028533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843546 [ RunTime:0.012082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638889 LIMIT 5 [ RunTime:0.006833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638889 ORDER BY `minOrder` ASC [ RunTime:0.035445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638889 ORDER BY `unit` DESC [ RunTime:0.004302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638889 LIMIT 2 [ RunTime:0.025097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638889 ORDER BY `minOrder` ASC [ RunTime:0.004620s ]
select * from pdf where partno='JR28-RYG-DLFP1' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.012197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLFP1' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.012269s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638889 AND `partno` = 'JR28-RYG-DLFP1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.005433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843545 [ RunTime:0.007161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638888 LIMIT 5 [ RunTime:0.006257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638888 ORDER BY `minOrder` ASC [ RunTime:0.004117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638888 ORDER BY `unit` DESC [ RunTime:0.014419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638888 LIMIT 2 [ RunTime:0.010528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638888 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
select * from pdf where partno='JR28-RYG-DMSP115' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.012327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DMSP115' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.006175s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638888 AND `partno` = 'JR28-RYG-DMSP115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.016090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843544 [ RunTime:0.003287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57638887 LIMIT 5 [ RunTime:0.013067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638887 ORDER BY `minOrder` ASC [ RunTime:0.012952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57638887 ORDER BY `unit` DESC [ RunTime:0.009995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57638887 LIMIT 2 [ RunTime:0.023449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57638887 ORDER BY `minOrder` ASC [ RunTime:0.013705s ]
select * from pdf where partno='JR28-RYG-DLDP2' and brandshort='Mallory Sonalert Products Inc.' limit 1 [ RunTime:0.014543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JR28-RYG-DLDP2' OR `brand` LIKE 'Mallory Sonalert Products Inc.%' ) ) LIMIT 1 [ RunTime:0.014603s ]
SELECT `id` FROM `stock` WHERE `id` <> 57638887 AND `partno` = 'JR28-RYG-DLDP2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mallory sonalert products inc.%' ) [ RunTime:0.017449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18843543 [ RunTime:0.017703s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025177s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006419s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010473s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030851s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024101s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017045s ]
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 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007215s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JR28-RYG-D%' OR `brand` LIKE 'JR28-RYG-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008983s ]