SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478017 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478017 [ RunTime:0.001449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408968,251292,359432,590115,871652,246334,700533,397132,466843,356682,1006029,424071,70044,174359,538304,372338,709037,291444,710005,1021258,1040771,326636,149345,955165,338761,248351,671709,103320,618747,438887,250722,630388,170390,466892,56030,870029,510757,835874,789234,21733,331513,304098,161594,333665,372090,591824,614718,552544,983829,887393,361824,574895,81,805722,549589,84495,526151,525669,5610,60337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]