SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982186 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982186 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437263,483142,482046,440445,849270,631393,644396,882122,403979,298808,503366,1030754,635813,986444,362208,751665,769773,934839,671426,72295,502083,21794,833676,975183,117022,896467,439158,456772,115269,834382,58595,73436,1041265,886041,1033528,200158,951666,476627,226756,757355,394955,57269,466122,530797,375335,23048,560495,339377,239375,844304,73022,654220,594868,17842,579109,686521,245740,158336,289428,463714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]