SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486823 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486823 [ RunTime:0.004573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462741,191085,975649,239681,102403,96261,407125,965294,439020,672984,440170,603411,475240,576974,595663,540590,376220,20786,85136,840881,545277,593626,48393,503467,757175,157122,570134,109641,1000063,677618,476069,542874,1022957,687631,578957,419995,638359,1011154,38148,134815,88936,1001372,112223,501654,391306,347386,227456,443085,86564,524865,150233,378497,927199,395699,311934,673686,17853,923388,572078,821388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001464s ]