SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385475 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385475 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537452,607874,1047273,345722,13356,797929,1022050,859525,7622,8462,486069,405856,1032912,101056,318925,781740,425891,151045,335394,903273,138320,368352,260086,991218,221123,304229,41113,154597,167742,10967,693639,432258,477557,453987,427092,432138,915544,955216,962080,430667,664050,938042,749350,446172,428758,72629,39265,793274,250291,313519,77645,1035213,210708,125504,769176,888564,892189,671873,26616,427165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002534s ]