SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456540 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456540 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472528,833204,611185,340790,257007,157536,419375,171354,522583,954241,51200,496372,263151,907852,235763,98913,468846,680735,979057,797010,471014,31421,585105,611641,778978,97627,199306,149581,978357,611354,238130,930450,143081,281848,294808,792898,603859,369010,727058,718027,378293,532367,301380,489214,208092,440162,330082,303755,787264,298369,675558,327560,980413,588790,700889,429510,217851,954568,751256,1005005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]