SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045108 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045108 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371446,381994,693542,123208,476083,679012,20291,975223,585921,871466,383316,258231,414166,183936,574583,836478,97863,273447,725878,905347,158360,615112,926316,651254,272226,486991,178116,500407,511506,916511,862619,483933,523974,529097,413236,855349,736584,366476,231558,759209,403610,964172,543591,490388,11188,989988,1030296,133496,987038,466525,529306,288582,129811,119018,898461,368327,172910,41010,358515,943462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]