SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540178 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540178 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694068,957250,326061,156645,771866,398584,930090,564878,703479,150204,523649,949978,66351,825508,144558,210408,859594,858702,989882,492964,82896,148681,857375,229766,205749,791712,330136,73366,675287,766168,542798,165238,342743,7676,926476,999382,10434,884184,555851,978663,278253,77135,980224,584171,695681,440370,913018,723825,356656,612754,169367,894103,766038,905898,552277,689880,975553,512478,469277,185889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]