SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981316 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981316 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477105,481796,102078,443420,332501,415032,159666,146782,4036,985601,605650,965273,511073,408474,648446,109992,807035,762147,184118,680622,306029,832497,84481,414388,396098,914180,416146,135555,91785,775997,680343,490646,702389,954217,858778,1018953,1029592,998241,490622,927158,1509,591371,615130,909342,933186,1029776,70515,292705,828575,609675,675085,429249,830351,112535,605949,25907,176035,155831,997799,67509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]