SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468545 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468545 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349092,700159,275271,23552,393445,664827,957699,506282,589642,830681,353686,788635,403856,696252,434100,721760,551954,579458,518533,1012309,459569,670146,204681,126384,702693,130964,742606,629591,510999,691802,780610,150438,948180,31625,15456,500981,959989,1003,466245,959201,5691,977330,708490,266975,493033,753255,196953,945470,113172,526163,394046,219371,640586,404550,264547,629223,362536,746554,753110,47592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]