SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508191 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508191 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989432,310778,71196,588037,1024575,959390,109509,954662,5071,621150,358850,706696,426859,410756,120016,467884,889114,494013,14388,975402,233992,316579,792284,597297,682369,961009,644702,365295,117441,361606,111705,323125,264105,811929,40617,233957,371922,1016190,288487,7410,219938,962980,520147,298080,236901,501081,68113,194529,467619,133928,862890,254948,427057,566162,960430,1000946,458428,338096,358125,928728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]