SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019184 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019184 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139745,558606,123627,1040687,657609,818676,301437,29186,134330,158444,278095,22527,696678,265032,260612,490147,97863,522632,57270,499703,662483,386679,217988,375312,923516,614012,1039133,761006,293129,668405,174871,172318,669059,582890,20095,869766,12308,890038,253901,915669,978169,812231,150357,47407,939037,654095,171933,290543,217384,185348,667019,426662,399389,239346,833895,917673,1028091,645845,8472,882100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]