SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301571 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301571 [ RunTime:0.003128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713710,622473,225034,627796,493696,550206,440245,424332,579027,780360,471120,472621,124758,886458,419211,575501,1046780,844824,745598,209188,697495,360326,242538,51735,892901,38376,227067,90860,277174,767497,1026100,718160,998852,811663,579630,516732,856474,247133,810674,703447,692677,760115,267030,870184,208895,561591,212864,174596,550679,778723,493549,1040821,419962,837652,188456,834360,23512,813133,509274,8108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]