SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 157613 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 157613 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564748,634003,566467,56048,254595,680751,282330,280028,576806,934548,48478,307945,280677,109290,527038,458209,118053,715050,603890,21345,1008557,362490,653133,983388,707641,23028,1043480,787196,223393,755698,907511,211088,426311,226761,436039,825652,239274,771113,875236,799268,532486,734118,279229,187910,426517,932448,1005780,197984,825034,72291,233588,549156,315008,606917,262147,579107,324982,6121,129519,114153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 157613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 157613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]