SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801122 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801122 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262772,256229,67949,144034,709388,885525,732923,520264,272891,317833,342225,507672,714511,639058,490910,372466,180341,825468,176008,802150,43346,880159,556408,511691,898071,169286,747651,153861,658969,84565,477628,296707,227361,1011779,451065,398249,1036188,937286,709436,164432,1031479,13524,899968,853168,687085,81908,629904,62223,215593,740790,808246,260642,424411,231908,726345,765691,605600,384181,501426,856923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]