SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408218 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408218 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471038,294006,289614,868691,328973,421416,443826,966514,583475,168895,413725,356707,56834,821043,18415,23615,424924,979464,403445,956219,777295,205877,988803,777442,627445,530242,783987,111234,689974,409407,918417,568551,708360,724858,953549,144146,453875,448466,698265,499236,787518,836037,684308,277846,631529,845612,558205,730061,110793,742347,290889,964919,547673,358692,509935,909832,965539,779308,90757,22309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000935s ]