SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50170 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50170 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945700,789526,484694,1048074,664844,68244,905052,225018,98651,507326,431387,794708,341886,417661,818023,954013,688861,175635,360541,544519,675166,759595,917846,674624,759917,399095,352711,1020592,671416,63759,865829,430900,981805,463969,474414,713355,957473,166923,525193,35937,113593,328571,129586,909044,942347,253364,947979,754960,467342,436574,950539,934973,880486,137271,206657,102039,527071,933897,342732,514184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]