SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495681 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495681 [ RunTime:0.001320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436874,577794,857927,870974,332196,958304,669632,803475,649899,1041217,79123,419137,452435,755915,619240,38244,461505,225584,638106,147219,150899,330598,195282,664180,853237,336065,969302,308411,675326,321808,339265,752977,729477,887508,30127,859197,672640,119910,838051,941248,813387,92487,227404,61788,92234,367899,692196,229054,453413,901262,852405,420708,973989,1017114,657794,484841,365895,280252,172727,153986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]