SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039422 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039422 [ RunTime:0.003612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463028,507360,240945,292822,431532,875953,696344,540170,287805,860491,165999,941081,884159,821797,281384,278997,107311,351562,580601,906652,124135,922718,891061,239440,512907,181840,960673,350397,152702,555783,257109,258912,184543,96618,588677,882104,483417,405178,715107,654607,783096,381038,126722,970228,635680,867447,858569,463176,715795,514156,200205,798304,72377,70541,542750,214894,798657,93445,515438,763067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]