SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831912 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831912 [ RunTime:0.001373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524891,453478,815843,342632,2162,672620,856329,1045114,623606,1030324,749310,59465,820635,334495,865237,547817,755742,126781,321770,295353,847425,74443,580016,1009850,284784,936345,1025203,556228,757824,222055,560870,371902,811212,969519,701700,803874,283137,411787,529327,341436,410105,602534,217362,416063,1044823,1023385,915205,704163,323315,114305,294379,783880,151719,992764,72618,857946,852440,146499,171800,525712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]