SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914496 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914496 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366474,595667,362872,201758,153294,470665,151821,906318,414966,905679,709417,896345,672442,680206,260325,528361,773638,928903,496699,531958,291051,353711,452160,63440,791321,16487,173638,289140,290452,335730,304442,338409,897360,130605,526736,628778,617971,987111,98462,1020144,531230,850558,237214,871601,408050,142010,176942,444843,13847,798738,1023522,359130,183985,230666,38847,303210,845744,815203,519253,520971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]