SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311974 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311974 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902462,894432,725978,352873,247977,534341,517190,632588,695414,148107,812813,621814,551175,85525,1013044,947051,596116,849875,229923,568470,487468,99125,582443,374352,161526,591610,199539,627720,864800,250054,900488,806062,987441,753813,482336,637118,745686,825014,132195,41157,555981,514829,774871,617543,823319,1016817,737898,395064,128439,703730,829608,558274,334424,601025,943883,278619,516448,1011536,1014238,837723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]