SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494179 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494179 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270728,13280,548690,619049,758902,920112,656437,567077,524521,710524,708780,354757,445463,188446,873804,678481,205652,761374,770973,188243,898976,906482,1028833,833120,1001746,293454,370089,715297,292013,859607,1028243,661908,644918,244827,567137,160547,1019362,695537,134233,727653,540541,684340,663657,496547,591183,191642,838973,742884,331225,234523,239963,774377,32201,34012,803987,576482,59807,784544,638145,487034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]