SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670283 LIMIT 1 [ RunTime:0.001430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670283 [ RunTime:0.003348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43398,131386,677595,417718,141937,227107,14873,436071,638314,715868,260963,506351,255055,580037,472894,66062,608824,504312,405081,1007169,146850,80299,663745,70834,734559,657598,392060,774508,379879,946878,471587,537718,948005,844381,653777,809385,255658,518552,589149,302526,475710,118830,414357,472897,622157,405843,168302,1229,453332,626454,924729,168502,289615,208718,623449,358770,619698,565596,427250,933885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000872s ]