SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537213 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537213 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243616,361000,1006556,939533,929571,557825,951952,329312,826436,294018,1017045,463180,837210,322949,410911,126142,195570,980743,434210,479078,309553,465724,70914,795252,389390,954168,36797,719916,209623,616134,168459,416475,559055,352386,138155,489247,690440,149836,358467,162065,167318,692415,197310,838023,388864,414457,204027,240697,538346,885446,453624,1038831,774598,915390,168015,669691,804451,473890,724211,882373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]