SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505455 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505455 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893629,336901,112385,413484,311154,400686,707112,187612,400155,750843,15643,123846,264283,821392,171889,171947,225370,772395,821669,403141,22145,897525,149186,150659,746992,75925,491118,634354,887715,910292,146423,101475,973025,610272,795020,15022,730940,672026,98135,8881,598942,686028,297720,697553,876476,692695,296678,11342,469172,568619,963548,442564,468742,336667,770794,588341,367676,882266,349639,1023279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]