SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381075 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381075 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238088,582942,701070,754508,1033848,878513,665662,431344,204741,629147,733409,529348,790389,659600,881593,533414,214487,936308,604257,551290,1036409,519043,418884,584363,386495,913048,554124,1001261,116897,883773,144807,521682,231977,382195,364233,941603,119105,644182,497165,1015963,199061,260557,152849,966509,894818,110454,708460,608079,764942,21242,502503,337550,436061,558578,816160,413107,509128,808031,238933,511028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]