SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499708 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499708 [ RunTime:0.003379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960766,267560,709687,393201,1030077,787218,780916,425022,986987,1047860,743351,232062,379384,843299,607245,518730,486271,469385,941446,810697,592610,906650,171800,307767,1030549,766578,44674,223154,589440,975761,944651,301433,997844,365390,893967,746737,398349,529653,1037043,877039,886915,429927,401507,686407,469205,310434,861991,573302,445199,911112,517410,492123,982086,1013428,914985,517589,726558,369006,855471,854905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001303s ]