SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504357 LIMIT 1 [ RunTime:0.003622s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504357 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413285,1040276,941701,843793,923553,914049,98587,974403,140391,1026650,155016,939148,1009162,820593,925120,301948,543541,439403,647972,217694,294831,427220,235082,87035,611785,992309,67436,635044,321720,398910,983498,1001870,464998,247350,561487,58536,870275,360999,128189,913719,742540,814282,983710,829115,791185,594342,925047,734222,171866,436973,122903,54699,962364,461794,514051,360803,810612,130573,999700,959562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504357 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504357 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]