SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538002 LIMIT 1 [ RunTime:0.000987s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538002 [ RunTime:0.003312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960568,377685,965739,215135,184308,384310,718516,231080,433583,634322,700301,625905,822793,788926,821427,995575,208268,414498,975068,23835,982351,690828,116046,101644,639560,1001093,273742,401155,323699,422779,416967,554560,637973,933750,174716,920314,916993,440112,290778,558025,1046244,809383,1006045,356923,819601,82645,464466,162110,930242,627407,354325,922430,886427,1027055,119528,1042838,70115,389176,204594,386314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]