SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3159 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3159 [ RunTime:0.003933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505795,747113,620182,143538,659047,953817,912988,606608,518539,617187,867792,501964,431818,1028553,599656,405595,824347,103117,615194,25299,866153,328338,365019,105922,269011,139522,842635,20888,468872,835158,984375,700364,951403,977718,643006,732472,1004103,632932,648138,793701,969573,93480,232522,613442,388917,915034,1025550,392,359548,143404,488781,254,64344,698803,496258,90244,823028,591420,87268,597513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]