SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038016 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038016 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256154,909958,806533,580543,459791,754322,873812,322441,207000,591186,863521,112617,825096,123451,963561,153541,745643,606161,729469,857736,578441,235848,60040,308163,555347,551673,145549,20057,955283,74947,306637,917943,347894,1040406,1001113,183288,976929,95321,169570,914723,321469,826803,125379,463186,540615,114852,488407,164677,929738,441076,632787,423766,923850,574216,631743,888810,223263,276273,48378,339077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]