SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397969 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397969 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038110,1040707,545178,2524,642516,323521,171904,501661,1032240,79573,663977,329573,991681,445021,921524,25765,739204,938001,473973,183413,1008045,25584,875525,496225,728762,403826,507100,862077,387413,866918,737410,664284,608009,29412,85981,903456,877025,598122,420366,465381,285619,683594,237786,159841,523144,841457,972445,474007,627328,890857,68506,1017492,434056,797899,944109,751949,431551,463804,352521,563441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]