SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681869 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681869 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362267,915678,60791,408561,229030,1031986,97385,133965,350259,192050,755337,1019504,240547,454581,140466,809667,439864,32327,822494,48461,591216,47228,867179,723649,242644,205918,430643,349658,603877,766659,990175,818221,670404,771007,690347,624835,602433,1013099,742318,445686,426123,485005,723030,360231,769111,434947,476048,183954,48306,621821,908416,363987,585556,588384,207473,447247,1022846,164630,388816,161933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681869 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681869 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002179s ]