SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193491 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193491 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663983,1016409,226454,308691,233542,171136,762662,358176,625009,520454,248883,848891,644987,277783,581884,617992,659872,356935,988249,307846,1041936,513738,758177,866504,43524,612786,360798,6173,192739,43985,297071,490224,928327,813241,613052,40957,519271,477361,634105,250562,963829,663795,824068,107663,901120,859963,398001,947705,120569,112206,812972,200220,107562,626360,443726,573180,408295,963208,413603,398722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001116s ]