SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29956 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29956 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438509,76084,262962,282619,913828,169899,1047739,226296,846308,821031,561637,26267,987827,854189,744204,96137,449030,1035262,965788,603687,611047,183168,247246,206336,857087,56433,612102,720006,124816,986305,898908,584329,382395,733517,996495,615711,571810,543340,603853,986680,323232,411802,608693,979606,119314,621920,422758,310675,1004863,989855,192501,12748,839318,1015880,343816,734100,492054,575918,654600,1043634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]