SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456821 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456821 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012288,861004,436253,827732,272732,809585,706903,712968,150864,957832,216218,73871,393480,707049,833723,378263,1013156,482293,309613,756718,816888,428,1008309,579074,456002,806601,242467,55524,804572,585497,229856,604453,558477,262051,403144,567374,741638,158054,755515,773169,883656,901528,948563,577117,662091,1025950,39268,835079,939252,547387,942540,57871,426411,626652,1021555,593587,830420,1030182,958314,42178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]