SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045479 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045479 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000223,577334,696181,770246,78136,297332,352728,593808,225446,803219,279102,229639,662335,619761,417740,431967,124946,447886,213212,722220,263554,502846,673095,1028692,211838,97804,51517,1026291,170141,966665,538749,142853,803992,678024,277331,104551,302258,486804,574672,877808,234669,400631,95821,926114,325278,809584,1019386,842652,880378,825370,697793,450167,724893,889259,1010780,389503,986930,550490,345975,198837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]