SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 970628 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 970628 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467532,1007247,792568,587090,92492,501181,1030383,886566,1030051,876561,576227,475513,615012,147767,653668,866888,119500,313601,259784,607147,229652,24549,189092,844940,502565,533029,1010530,556555,499977,705763,718049,748292,832870,505021,682556,919981,473409,864423,249846,577562,580719,568510,495340,246287,873810,112988,51755,496297,837120,422737,17586,344623,335797,84510,435915,124542,1019873,841359,963501,418483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 970628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 970628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]