SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175838 LIMIT 1 [ RunTime:0.000740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175838 [ RunTime:0.004921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100148,608381,936022,715119,163291,364369,1034480,190073,542704,452105,385330,144131,46598,972184,459284,46652,99890,397766,183568,936413,535010,906504,465179,489004,833138,157737,370436,266232,46504,1038351,128581,341513,549593,769827,705661,570484,713154,1029195,338737,318892,466818,58403,880267,726913,839793,453315,414092,437237,440416,561108,412373,97381,386573,584169,551009,266225,489894,639534,441956,377140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001178s ]