SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48081 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48081 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283975,407025,347768,890265,985805,907097,868243,626400,756374,568219,747234,969160,746016,580081,317533,424774,171957,725067,241901,894884,144201,267942,430092,185607,670947,106108,922380,56693,574204,876329,403837,488072,587565,49372,141236,243705,139379,151457,50862,192620,711306,777400,456288,501906,323650,977715,672760,720867,425375,237373,783591,70373,74726,240533,1020946,464088,806159,347715,508446,400156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]