SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820317 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820317 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521074,1010035,269298,559233,98949,197232,709167,541979,419445,786786,354894,892539,536980,856206,973027,848556,118899,503752,162909,37640,17748,887075,701017,877687,289590,908038,17795,458863,23337,626433,1047856,1026590,75662,842217,961143,720659,980405,304308,264513,919469,705752,801789,14336,837668,978821,412716,895801,507105,604916,909333,806941,588733,715435,469633,273427,275446,996514,48447,8912,736230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]