SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981083 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981083 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868041,213497,1006730,369509,557313,692741,644865,869743,275081,1047606,1021202,749303,973768,855949,314482,21379,463137,36336,683843,845495,739189,376041,568697,45582,216478,548432,880548,581404,922712,91597,916592,700764,144727,250128,61404,501014,340935,301948,125309,659888,493607,644432,621434,948835,402265,497980,508695,988923,753876,1047893,679518,942295,435732,238444,477896,551874,225070,747920,396068,605380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]