SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41816 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41816 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954829,116833,496261,331300,482012,274344,771770,370353,861297,1011982,750887,759335,234806,1003420,50701,380652,342163,997221,869607,366439,856104,362074,607554,1031950,887773,235161,430865,647235,190137,688475,51147,903983,734867,705776,524262,497540,130712,442785,571578,651776,875719,697260,788919,759656,952609,838392,1031458,469308,747594,459239,91406,1003262,362982,597040,465603,273421,695731,931414,657064,135505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]