SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509519 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509519 [ RunTime:0.003384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575973,288848,995792,5300,745529,875201,60256,582667,436830,80913,676635,323890,272420,822893,475458,340909,365101,205228,228499,452167,979215,322181,534327,907923,719871,858561,882860,750011,334560,176702,211757,965869,683844,211870,510201,904491,29060,643067,972820,90577,566922,298610,973492,158223,14596,254730,462325,33428,399333,115397,457037,425965,384127,411831,473557,625716,789219,391330,403387,341790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]