SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331989 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331989 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410195,39689,952989,980181,679627,1016892,896844,101621,184788,140091,11438,787573,276633,973513,578442,923454,668314,689861,617687,743248,2760,124820,898354,56022,1038790,189171,357920,284326,703450,247024,26543,326401,546739,870589,704679,320896,514829,891535,783823,448000,788643,460175,974266,696446,551938,766154,692703,58053,765905,676806,697993,545862,400656,383893,562111,424189,891965,976836,58657,536562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]