SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039403 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039403 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200204,600739,299343,34514,799592,243450,1011318,1018309,208219,708488,880443,591369,604489,756563,297097,1008221,92691,957911,850723,238807,605266,435147,926489,105712,799378,997562,611679,966252,553102,82724,32689,1035942,823795,993562,842337,617186,279701,132129,432743,392977,306638,710792,190023,108454,727027,520377,947281,581739,26077,874299,859051,795725,919054,650921,480948,900311,617668,800231,844525,220138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]