SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585980 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585980 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891137,52911,193719,378039,257998,880575,667334,507476,244995,305654,700662,482152,712441,1015732,258243,215075,448832,791683,735303,750980,470836,965811,183495,1001314,513653,875886,48759,979436,877002,520455,852775,3941,126938,404791,761434,294115,432206,117543,650727,370398,261385,503412,861281,630640,503965,279126,307940,342952,172493,594509,439333,936573,605681,233346,449407,1047225,170894,923453,704602,289228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]