SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499712 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499712 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357121,1022786,2778,22705,983306,227882,418466,523490,83167,62141,890271,481553,930824,326056,337911,250594,609131,1035006,262830,636218,428985,230283,84289,19921,194670,447286,244604,932075,926841,931304,184864,437862,733562,930403,926252,451562,859286,839799,626039,170240,588038,134406,859327,293503,805820,446037,305810,860995,413071,150622,634122,520554,1019219,268195,469532,214522,1023700,776031,486688,172549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]