SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54125 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54125 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691529,876219,900749,471894,257022,281141,745064,926404,729757,735571,244349,995451,263802,949096,815795,684477,806927,238148,304907,372828,329970,574029,830627,833147,916360,369221,577227,755868,991864,939630,725514,85447,175962,97637,709230,107425,804007,239901,1012915,384484,889106,9973,116307,367315,109155,333360,258967,80432,1030866,735818,783991,894142,474933,720510,152359,285075,285269,338881,922225,845968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]