SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045182 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045182 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576509,961034,267515,753694,727396,385211,844362,658752,333531,284746,410438,119720,761678,685944,857404,307134,133276,668191,657343,945451,446758,253752,788672,873016,364525,938319,54237,818289,496500,908120,660595,187735,193907,788159,870850,876706,200641,791243,1029772,405719,280207,1008184,666244,105997,322187,966849,909688,1040667,999184,580839,336162,982394,440094,243461,108790,495130,954183,674135,352088,33907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]