SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416483 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416483 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105468,903353,348662,52129,686853,578691,89996,927737,576200,192536,431960,730318,117644,105142,38526,359468,660077,759357,983489,731110,620733,988340,468581,636923,692957,96874,544654,708775,509599,455613,821895,459496,378088,905316,929442,492691,532812,212388,993031,954145,243843,55963,980278,655639,639596,787348,763697,990058,314667,786357,483648,317241,478077,467597,121315,408669,1002511,512881,1038332,950694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]