SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541228 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541228 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886134,858297,566896,309173,902142,373397,591006,759016,592823,667428,935597,245871,723210,634132,230884,249866,111098,921761,124308,821310,1009777,779638,214870,278825,1040783,977732,306663,820999,144357,211150,758939,224647,20530,292102,639816,927377,522736,172689,493751,672631,261289,87485,453192,267237,708162,956580,1035829,267050,858769,440707,1030842,350051,556865,838313,576063,383791,208564,846166,527875,823266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]