SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023438 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023438 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332435,910849,638591,85149,791330,36726,81242,957077,578098,826718,1021218,837846,598244,582703,97722,326251,819709,413410,417731,808551,957696,272137,540122,987384,288814,880917,59146,783241,627158,553638,653894,813509,140662,552405,575622,225937,292170,414621,476537,54741,67038,990619,57491,322978,574145,148126,672299,539314,849551,387348,250029,818819,945847,890261,82103,816643,214871,305282,752108,702971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]