SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304180 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304180 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028184,244943,777631,670121,190218,106755,763235,515104,592681,321647,10691,574339,536255,1023063,190155,856627,903651,249546,890036,718707,410458,851264,763900,595050,291895,709682,405341,761039,6624,559480,869591,527732,305372,36598,529039,658844,315946,660526,611850,424351,611594,102932,140534,714111,340946,837791,458718,819502,983396,964982,112244,1030072,293083,327391,380612,415919,918574,1024892,833962,1000542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]