SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303909 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303909 [ RunTime:0.004325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045377,340058,1018830,265069,828349,799298,823146,641464,414760,798800,282280,738731,557923,724973,483400,521606,393360,717927,530659,949379,125487,532402,299207,919552,277959,803684,146158,658839,748314,821732,288267,695258,406291,460348,372785,747410,79066,808865,630497,537190,750299,205279,90369,762568,140542,871461,212167,561929,201585,302227,152959,716539,464348,639502,625213,151246,423373,768968,137071,374563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001025s ]