SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015281 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015281 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107768,109153,613769,103282,1046367,307193,556524,907738,520280,141869,538230,614005,617499,40322,272227,964719,20638,906833,204355,672920,303187,319164,100806,5558,639492,624002,91651,439581,250334,654649,1011256,694619,692020,869832,356322,392540,893288,892862,247859,100005,647761,479400,311546,29673,306448,15260,605523,619456,166217,285019,570695,880890,133017,810053,845494,631520,375630,515651,808013,679273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]