SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107230 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107230 [ RunTime:0.001424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778276,355008,758816,512586,775601,601569,566942,228446,750455,896990,422783,541612,275385,393587,1041406,600563,56335,1024746,845199,27858,250711,739560,320835,952841,428695,604247,751323,385587,124866,336804,840275,137733,305715,882052,491204,556712,378448,202494,16291,57072,250447,519794,717198,734182,580291,758559,206216,981036,485586,443687,307681,258129,285241,836315,340912,810223,98492,788104,165690,374673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]