SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522056 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522056 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287061,486613,61624,622335,77282,313415,451141,83532,449716,637314,849455,79883,821692,170223,558255,735134,289371,170080,951361,620181,44157,564252,360947,633655,309199,880102,958886,149111,299879,767155,620382,94458,1027669,4909,548463,270627,933886,626292,935436,664331,387816,271485,581605,940927,93306,757004,958272,233283,476273,94816,358250,346097,390133,380360,999929,286690,897176,494903,141850,375500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]