SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50358 LIMIT 1 [ RunTime:0.003981s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50358 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211314,610947,482159,540351,218060,627551,753361,397317,414713,360821,613821,938236,933654,466448,741964,372703,86923,531292,838206,612169,60482,387459,19249,23858,621383,810552,79042,381718,106364,572347,777211,601712,475005,821800,926651,870893,227977,816301,672609,349885,401630,913900,729989,766609,133253,1025195,683084,301685,474993,776540,746926,617924,744648,749689,711165,38992,241661,447648,705469,387756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]