SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102540 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102540 [ RunTime:0.003947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183664,891130,284752,768673,181094,974583,463828,739533,461033,708128,365494,709374,601856,460868,355402,806250,310210,10145,589291,459267,314706,94833,811115,980683,840523,718875,319329,48323,621806,778050,410801,925779,784953,184464,817313,552791,851376,859328,78965,760507,902242,254584,785953,877650,697874,996703,716812,7601,796249,395969,908755,198987,128852,332216,345361,434406,98783,834993,70450,905728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]