SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313011 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313011 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568778,638523,586951,526187,616179,311281,355112,1028115,847479,590143,662924,643957,444226,438060,754269,1032666,330940,243834,901249,260758,361166,285581,234855,925401,705856,445346,329865,98890,103881,269617,291197,42389,623867,939388,112164,222239,327262,660715,667328,401651,956179,461022,1041552,941112,274848,940548,821394,989398,161020,586303,915178,267867,906025,897856,37217,789362,433005,708523,686826,918502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]