SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343341 LIMIT 1 [ RunTime:0.000705s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343341 [ RunTime:0.003741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564259,319851,743806,47190,965998,265426,403436,476018,847053,196856,752441,743174,623248,590903,942612,983799,395758,154124,442089,166678,644599,716979,112752,48315,896549,227184,892351,43426,730254,702921,249287,117763,143910,38040,630629,926767,617731,495385,598209,889963,488127,378429,799404,591221,943394,790094,650645,191680,296712,597276,669532,32566,678901,543983,731995,583739,438456,706082,156275,526872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000871s ]