SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681929 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681929 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532468,497481,105677,21192,43326,801175,517125,1009943,970793,118958,1002637,109655,211018,644007,692336,864018,827859,247950,535869,147917,1027738,347404,601588,130907,65397,840533,482637,118129,462689,690264,344070,194859,397939,652036,98053,885299,969669,1033625,22928,1003838,446612,651662,790170,661073,989897,730940,568218,552591,815146,37416,263571,764568,990573,119344,955555,575492,303648,279850,36142,414933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]