SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681429 LIMIT 1 [ RunTime:0.004195s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681429 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935949,130952,167283,508937,648415,100699,493772,411142,1026398,503501,510207,979546,1015994,478169,285933,146345,798012,790294,760035,581962,794635,132179,143189,505829,112084,928512,541756,1008224,381233,407235,396496,972640,52070,101612,315310,186264,520891,917301,297754,422097,27657,945160,175190,748550,19119,707893,147565,313677,854621,162226,258503,833787,323199,756466,767833,122777,552522,758997,647687,503991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]