SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426022 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426022 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598220,181236,450685,779646,683296,571852,496357,251120,277969,1024856,314011,845331,569215,757318,189878,987477,93882,892653,108867,995905,189451,236537,346329,134891,395656,878334,919716,14280,22601,13554,688945,804770,101977,395732,578669,575124,482764,953089,276099,528713,674616,246356,82529,265709,657376,751828,810920,748172,86516,274834,1034532,604435,1045981,716376,993182,611504,144789,881133,772146,478982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]