SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018270 LIMIT 1 [ RunTime:0.001285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018270 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442033,941532,659800,1012890,575837,693283,628642,864461,923470,111782,365861,856596,735082,746070,708081,908077,251346,308454,805778,500655,689043,282834,285945,1015701,322272,967526,389730,270461,310175,34132,1038207,621800,2518,577785,388231,726524,498857,188651,545929,167601,514666,899715,768012,825567,704343,39721,192822,428727,864960,594504,402278,258824,750342,822165,445970,682460,110121,983269,294013,263266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]