SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351748 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351748 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793637,603639,597393,338867,1007081,403019,751723,87197,379859,810810,867224,350397,838056,482265,78004,486793,463691,1021966,492965,916892,140522,221787,453691,500177,905554,1009801,548962,728342,814938,215118,953418,868728,875157,514980,494046,630105,345565,940339,658664,894008,93677,419227,52578,859485,456124,154650,931063,823882,96008,428382,707754,1024725,259482,752545,545694,727503,554727,593603,131407,254016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]