SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584271 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584271 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596735,651412,224116,228041,634825,847825,960150,704270,478197,919517,957252,540769,488953,1044329,619284,1007388,470712,524110,520570,113268,531811,418336,318213,884212,41205,265885,124454,215997,738176,341020,372029,155879,538218,274695,702455,618154,171754,228138,243195,124068,964231,934588,711005,150265,381111,254456,148555,268681,249665,13547,572910,508445,297803,1010680,406592,841715,330262,429178,70513,881882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]