SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110175 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110175 [ RunTime:0.003832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811182,93228,13687,403161,44739,1020820,626518,492971,88059,365166,781817,535670,44384,721510,963579,789920,225805,793754,443547,284671,677281,32791,337063,795016,370708,963636,196825,821502,1031191,596999,279691,692581,538301,1036539,352776,39823,480295,207438,452540,211872,66766,796864,349803,26590,647257,133299,433930,564073,409132,483765,291680,772804,246561,408542,800660,279470,847599,424910,991265,615746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]